DB2 Import 无法使用 报错SQLSTATE=51002 SQL3015N SQL0805N
标签:
db2importsqlstate51002杂谈 |
分类: DB2 |
执行步骤如下:
11:40:47 PM
11:41:03 PM
11:41:32 PM
11:41:39 PM
sharedhrdds:/home/FLY$ .
/opt/IBM/InformationServer85/Server/DSEngine/dsenv
ksh: ulimit: outside the allowable range
sharedhrdds:/home/FLY$ db2 connect to bpXX user bpXX using
sapXX
Database Connection Information
Database server = DB2/AIX64 9.5.4
SQL authorization ID = BPXX
Local database alias = BPXX
sharedhrdds:/home/FLY$ db2 IMPORT FROM /dev/null OF DEL
REPLACE INTO 'BPCOGADM.CERT_XX'
SQL3015N An SQL error "-805" occurred during processing.
SQL0805N Package "NULLID.SQLUFH13 0X4141414141594758" was not
found.
SQLSTATE=51002
sharedhrdds:/home/FLY$
http://s5/middle/70121896g75c740d62714&690Import 无法使用 报错SQLSTATE=51002 SQL3015N SQL0805N" TITLE="DB2 Import 无法使用 报错SQLSTATE=51002 SQL3015N SQL0805N" />
I did the following commands:
sharedhrdds:/home/forsburg$ su - db2cae97
sharedhrdds:/home/db2cae97$ db2 "connect to BPDBNAME user
BPDBUSER using XXX"
Database Connection Information
Database server = DB2/AIX64 9.5.4
SQL authorization ID = BPDBUSER
Local database alias = BPDBNAME
sharedhrdds:/home/db2cae97$ db2 "bind
/opt/IBM/db2/V9.7/bnd/@db2cli.lst blocking all grant public"
LINE MESSAGES FOR db2cli.lst
------
--------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0"
warnings.
sharedhrdds:/home/db2cae97$ db2 "bind
/opt/IBM/db2/V9.7/bnd/@db2ubind.lst blocking all grant
public"
LINE MESSAGES FOR db2ubind.lst
------
--------------------------------------------------------------------
SQL0061W The binder is in progress.
LINE MESSAGES FOR db2ueiwi.bnd
------
--------------------------------------------------------------------
2239 SQL0204N "SYSTEM.SYSUSERAUTH" is an undefined name.
SQLSTATE=42704
2243 SQL0204N "SYSTEM.SYSUSERAUTH" is an undefined name.
SQLSTATE=42704
LINE MESSAGES FOR db2clpcs.bnd
------
--------------------------------------------------------------------
3358 SQL0440N No authorized routine named
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884
LINE MESSAGES FOR db2clprr.bnd
------
--------------------------------------------------------------------
3358 SQL0440N No authorized routine named
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884
LINE MESSAGES FOR db2clpur.bnd
------
--------------------------------------------------------------------
3358 SQL0440N No authorized routine named
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884
LINE MESSAGES FOR db2clprs.bnd
------
--------------------------------------------------------------------
3358 SQL0440N No authorized routine named
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884
LINE MESSAGES FOR db2clpnc.bnd
------
--------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to
"UR".
SQLSTATE=01526
3358 SQL0440N No authorized routine named
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884
LINE MESSAGES FOR db2arxnc.bnd
------
--------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to
"UR".
SQLSTATE=01526
LINE MESSAGES FOR db2ats_sps.bnd
------
--------------------------------------------------------------------
1173 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1203 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1234 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1482 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1499 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1517 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1555 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1679 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1696 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1715 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1732 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1895 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined
name.
SQLSTATE=01532
1950 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined
name.
SQLSTATE=01532
1962 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined
name.
SQLSTATE=01532
1979 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined
name.
SQLSTATE=01532
LINE MESSAGES FOR db2_adminotm.bnd
------
--------------------------------------------------------------------
342 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
371 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
455 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
536 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
570 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
590 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
671 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
767 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
903 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined
name.
SQLSTATE=01532
LINE MESSAGES FOR db2ubind.lst
------
--------------------------------------------------------------------
SQL0082C An error has occurred which has terminated
processing.
SQL0091N Binding was ended with "6" errors and "28"
warnings.
---参考文献
SQL0805,SQLSTATE 51002 of DB2
--------------
you must go to
/opt/IBM/db2/V9.5FP5/bnd
◄
or a directory simmilar to
it
◄
then run:
◄
db2 bind @db2ubind.lst blocking all grant
public
◄
db2 bind @db2cli.lst blocking all grant
public
后一篇:db2 系统表清单

加载中…