View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 04:39 PM
Peggy Wu
 
Posts: n/a
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






Reply With Quote