升级db2后cq掉线的解决办法

[db2inst1@ITM-TEST~]$ db2 connect to teps

 

   Database Connection Information

 

 Database server        = DB2/LINUX 9.1.C

 SQL authorization ID   = DB2INST1

 Local database alias   = TEPS

 

[db2inst1@ITM-TEST~]$

[db2inst1@ITM-TESTbnd]$ pwd

/opt/ibm/db2/V9.1/bnd

[db2inst1@ITM-TEST bnd]$ db2 bind @db2ubind.lst blocking all grant public

 

LINE    MESSAGES FOR db2ubind.lst

------  --------------------------------------------------------------------

        SQL0061W  The binder is in progress.

LINE    MESSAGES FOR db2clpnc.bnd

------  --------------------------------------------------------------------

        SQL0595W  Isolation level "NC" has been escalated to "UR". 

                  SQLSTATE=01526

LINE    MESSAGES FOR db2arxnc.bnd

------  --------------------------------------------------------------------

        SQL0595W  Isolation level "NC" has been escalated to "UR". 

                  SQLSTATE=01526

LINE    MESSAGES FOR db2ubind.lst

------  --------------------------------------------------------------------

        SQL0091N  Binding was ended with "0" errors and "2"warnings.

[db2inst1@ITM-TESTbnd]$ 

[db2inst1@ITM-TESTbnd]$ 

[db2inst1@ITM-TESTbnd]$ db2 bind @db2cli.lstblocking all grant public

LINE    MESSAGES FOR db2cli.lst

------  --------------------------------------------------------------------

        SQL0061W  The binder is in progress.

        SQL0091N  Binding was ended with "0" errors and "0"warnings.

[db2inst1@ITM-TESTbnd]$ 

[db2inst1@ITM-TESTbnd]$ 

[db2inst1@ITM-TESTbnd]$ db2 binddb2schema.bnd blocking all grant public

 

LINE    MESSAGES FOR db2schema.bnd

------  --------------------------------------------------------------------

        SQL0061W  The binder is in progress.

        SQL0091N  Binding was ended with "0" errors and "0"warnings.

[db2inst1@ITM-TESTbnd]$