By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,223 Members | 1,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,223 IT Pros & Developers. It's quick & easy.

db2 bind db2ubind.lst error,help.

P: 11
I update db2v8 with new fix18,
and do db2 "bind /home/test1/sqllib/bnd/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD".
Most of the packages already exist ,so it most errors do not matter.
But I puzzled about the last error:
"MESSAGES FOR db2ubind.lst An error has occurred which has terminated processing".
Could you give me some advices about this error.
thanks a lot.


LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.

LINE MESSAGES FOR db2uiict.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUEE00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2uredp.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUIE00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2urexp.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUGE00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2clpnc.bnd
------ --------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to "UR".
SQLSTATE=01526

LINE MESSAGES FOR db2arxcs.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLA1E00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2arxrr.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLA2E00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2arxrs.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLA4E00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2arxnc.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLA5E00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2arxur.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLA3E00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2atld.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUATLD" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2dropv.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLE3E00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2uqtpd.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUME00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2uqtnm.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLULE00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2ulxld.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUNE01" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2uipkg.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "TEST1 ". Package
"NULLID.SQLUOE00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0082C An error has occurred which has terminated
processing.
SQL0091N Binding was ended with "15" errors and "1"
warnings.
Mar 6 '11 #1

✓ answered by vijay2082

Hi Victor,

These erros can be ignored as we expect these errors.

you can also use this command if you have any further confusion regarding the working of command

db2 "bind /home/test1/sqllib/bnd/@db2ubind.lst blocking all grant public action add sqlerror continue"

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

FYI
C:\Program Files\IBM\SQLLIB\bnd>db2 bind @db2ubind.lst blocking all grant public action add sqlerror continue

.........
.........
LINE MESSAGES FOR db2uiXmlparse.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "VIJAY ". Package
"NULLID.SQLUZG00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2uipkg.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "VIJAY ". Package
"NULLID.SQLUOG01" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2ats_sps.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "VIJAY ". Package
"NULLID.ATSG01" already exists. SQLSTATE=42710
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "33" errors and "0"
warnings.


Cheers, Vijay

Share this Question
Share on Google+
1 Reply


vijay2082
100+
P: 112
Hi Victor,

These erros can be ignored as we expect these errors.

you can also use this command if you have any further confusion regarding the working of command

db2 "bind /home/test1/sqllib/bnd/@db2ubind.lst blocking all grant public action add sqlerror continue"

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

FYI
C:\Program Files\IBM\SQLLIB\bnd>db2 bind @db2ubind.lst blocking all grant public action add sqlerror continue

.........
.........
LINE MESSAGES FOR db2uiXmlparse.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "VIJAY ". Package
"NULLID.SQLUZG00" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2uipkg.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "VIJAY ". Package
"NULLID.SQLUOG01" already exists. SQLSTATE=42710

LINE MESSAGES FOR db2ats_sps.bnd
------ --------------------------------------------------------------------
SQL0719N Bind error for user "VIJAY ". Package
"NULLID.ATSG01" already exists. SQLSTATE=42710
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "33" errors and "0"
warnings.


Cheers, Vijay
Mar 6 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.