Professional Web Applications Themes

DB2 binding question on os/390 - IBM DB2

Dear all, I am a programmer coding COBOL program on DB2 OS/390 Last week we drop one table and create the table with the same name , but different table layout , we add a new column at the last column As my co-worker and me known, we need to recompile, link and re-bind all the programs that using this table. but we found something strange is Some program we didnot do above step, then submit the program to run . the plan will auto rebind when we submit.. but some program could not auto rebind ,, the job return ...

  1. #1

    Default DB2 binding question on os/390

    Dear all,

    I am a programmer coding COBOL program on DB2 OS/390
    Last week we drop one table and
    create the table with the same name ,
    but different table layout ,
    we add a new column at the last column

    As my co-worker and me known,
    we need to recompile, link and re-bind all the programs that using this
    table.

    but we found something strange is
    Some program we didnot do above step, then submit the program to run .
    the plan will auto rebind when we submit..
    but some program could not auto rebind ,,
    the job return code is 693.

    after we rebind those programs that return code is 693
    we re-submit those program, all of them is rc= 00,

    Does anyone know when need to re-bind and when the program autobind
    themselves??
    Do we miss any SYSIBM.??? DB2 system table setting ??
    or we need to do some command (ex: grant ......) ?

    Thanks for your kindly help

    Peggy Wu






    Peggy Guest

  2. #2

    Default Re: DB2 binding question on os/390

    Hi Peggy,

    so you changed some column specifications and added a new column at the
    end?
    I think a program not using any of the changed columns will autobind, any
    other will require a bind/rebind.

    Regards Rolf
    Rolf Guest

  3. #3

    Default Re: DB2 binding question on os/390


    "Peggy Wu" <com.tw> wrote in message
    news:bmeh4e$hinet.net... 
    this 
    Let's assume that the existing programs don't use the new column and that
    none of them do a select * from the table (all column names are explicitly
    named).

    When the table is dropped, all plans that use that table are marked as
    invalid. The first program that executes the program with an invalid plan
    will attempt an automatic rebind. If the table has been re-created (with one
    extra column), then the rebind will succeed and the program will function as
    normal.

    If the auto-rebind fails (the new table has not been re-created yet) then
    the plan is marked as inoperative and the program will not execute and an
    explicit bind or rebind must be executed by a DBA or programmer (after the
    table is re-created).

    I am not sure what caused the -693. If it had select * that might cause it.
    Or maybe the table and indexes were in the process of being dropped when the
    auto-rebind was attempted. Look at the code and see if there is anything
    different in the SQL of those programs.


    Mark Guest

  4. #4

    Default Re: DB2 binding question on os/390

    "Mark A" <net> wrote in message

    Correction to above post

    "The first program that executes the program with an invalid plan
    will attempt an automatic rebind."

    Should read:

    "The first time a program with an invalid plan is executed, DB2
    will attempt an automatic rebind."


    Mark Guest

Similar Threads

  1. binding question
    By sjk1976 in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: December 16th, 05:32 PM
  2. Replies: 0
    Last Post: June 1st, 04:01 PM
  3. binding data question
    By gbrothers in forum Coldfusion - Getting Started
    Replies: 0
    Last Post: May 9th, 05:20 PM
  4. DataGrid Binding Question - Multiple Rows as One.
    By Mike in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: October 14th, 04:49 PM
  5. URGENT question about binding collection to a datagrid onitemdatabound
    By ITnerd in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: November 2nd, 11:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139