加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

DB2 Import 无法使用 报错SQLSTATE=51002 SQL3015N SQL0805N

(2011-01-14 14:20:41)
标签:

db2

import

sqlstate51002

杂谈

分类: DB2
执行步骤如下:
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

 
SQL0805,SQLSTATE 51002

Certain packages like SYSLN,SYSLH require multiple copies due to the
high
usage of them. By default there are three copies made for these. What
happens is an application is using a lot of cursors, sometimes because
of application programming where cursors aren't being closed.
By default when you bind
the db2cli.lst against your database there are 3 small dynamic packages
and 3 large dynamic packages bound into system catalog table
syscat.packages.  The number of small packages is fixed at 3, but the
number of large packages is variable in range from the default of 3 to
30, and is controlled using the bind option CLIPKG N.  For the default
of CLIPKG 3, there are 3 of each dynamic package bound to the database,
for example:  NULLID.SYSLH200, NULLID.SYSLH201 and NULLID.SYSLH202.
The effect of this CLIPKG option is described in more detail in the Call
Level Interface Guide and Reference manual.   For each small package,
there are 64 handles available, while each large package contains 364
handles.  This means that by default each application will have (64 * 3)
+ (364 * 3), or 1284 handles available.  Each prepare statement and
each
cursor that is created by the application utilizes one of these
handles,
and the handle will not be released until the prepared statement or
cursor are closed.  With JDBC applications, you can not guarantee when
garbage collection will occur, so you should ensure that stmt.close and
cursor.close are being issued when the associated statement or cursor
has completed its operation, especially if the prepare statement and/or
declare cursor calls are present inside a loop or a method that are
executed multiple times during the session.
Once your application has used all of the available handles, DB2 will
then attempt to access the next package name in sequence in order to
access more handles. When your application has allocated 1284 handles
and needs a 1285th, DB2 will attempt to locate NULLID.SYSLH203 for
access to an additional 364 handles.  Unless the db2cli.lst has been
bound with at least an option of CLIPKG 4, this package will not be
found, and the SQL0805N error will result.
The solution, in this case, is to rebind the db2cli.lst with a
sufficient number of packages to be able to process the number of
handles required by your application.  You may wish to start by doubling
the default and use CLIPKG 6 as follows, which should provide you with a
total of 2376 handles for use:
  db2 "bind @db2cli.lst blocking all sqlerror continue grant public
CLIPKG 6"
This will then add SYSLH203, SYSLH204 and SYSLH205 to your database.  If
you in turn use all 2376 handles, you will then find that you may obtain
an SQL0805 error on SYSLH206 in turn.  At that time, you may either wish
to go back to the application code to ensure that all handles are being
released when they are no longer required, or you may wish to rebind
with yet more packages listed with the CLIPKG option.  You may bind up
to a maximum of 30 dynamic packages.
If your application happens to use the type 4 JDBC driver from the
db2jcc.jar (using interface com.ibm.db2.jcc.DB2Driver), you will need to
use an alternate method to generate the additional packages.  The type 4
JDBC driver uses a separate set of package names than CLI or JDBC type 2
applications, and these packages are generated through the use of the
DB2Binder.class.  You may, therefore, accomplish the same task as above
using the type 4 driver syntax of:
java com.ibm.db2.jcc.DB2Binder -url jdbc:db2//server:port:database -user
userID -password password -size 6
Other than a change in the actual package names stored in the
syscat.packages system catalog table, the same rules apply to the -size
option of the DB2Binder.class as to the CLIPKG option of the db2 bind
command.
--------------
you must go to /opt/IBM/db2/V9.5FP5/bnd 
11:40:47 PM
or a directory simmilar to it 
11:41:03 PM
then run: 
11:41:32 PM
db2 bind @db2ubind.lst blocking all grant public 
11:41:39 PM
db2 bind @db2cli.lst blocking all grant public 

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有