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

SQL2072N Unable to bind the shared library "". Reason code: "".

P: n/a
UDBV8 fp 6a - AIX 5.1
We have scheduled cron jobs to do backups. Periodically and starting to
occur more frequently, a backup fails with this error:

SQL2072N Unable to bind the shared library "". Reason code: "".

We are backing up to a file system on the server. Can't find anything
in the logs. We can manually resubmit the job 15 or 30 minutes later
and everything works fine. Any ideas on what might be happening? The
documentation on SQL2072N is no help because there is no return code.

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Could you please provide us with more information, by increasing the
diag & notify levels'. And also post the backup statement!!

Nov 12 '05 #2

P: n/a
k. Sorry there was something in the diaglog, If I'm not mistaken isn't
it logging a -818. But on what and why does it only happen
periodically? This backup has worked every night since then. Also, this
problem only started happening since we upgraded to v8. I also included
the backup statement as well. Thanks for your help.

job started on: EDWPROD2 -
/db2temp/db2inst5/maintenance/IKWDB001/DB2INST5.IKWDB001.backup at Fri
Mar 18 23:00:05 EST 2005

nice db2 backup database IKWDB001 online INCREMENTAL to
/db2backup05/db2inst5/backups , /db2backup06/db2inst5/backups ,
/db2backup07/db2inst5/backups , /db2backup08/db2inst5/backups with 8
buffers buffer 2048 parallelism 4 compress

SQL2072N Unable to bind the shared library "". Reason code: "".

job ended at: Fri Mar 18 23:00:42 EST 2005

2005-03-18-23.00.07.070691 Instance:db2inst5 Node:000

PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.095719040007
database utilities sqlubcka Probe:0 Database:IKWDB001

Starting an incremental database backup.

2005-03-18-19.45.28.735932 Instance:db2inst5 Node:000

PID:114998(db2agent (idle) 0) TID:1
Appid:*LOCAL.db2inst5.060699004503
database utilities sqlubcka Probe:130 Database:IKWDB001

Backup Complete.

2005-03-18-23.00.07.070691 Instance:db2inst5 Node:000

PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.095719040007
database utilities sqlubcka Probe:0 Database:IKWDB001

Starting an incremental database backup.

2005-03-18-23.00.36.672104 Instance:db2inst5 Node:000

PID:251604(db2bm.136044.3 0) TID:1
Appid:*LOCAL.db2inst5.0810B9020603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

DiagData

0x2391028C : 0xFFFFF7E8

2005-03-18-23.00.36.697042 Instance:db2inst5 Node:000

PID:251604(db2bm.136044.3 0) TID:1
Appid:*LOCAL.db2inst5.0810B9020603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

0x2391028C : 0xFFFFF7E8

2005-03-18-23.00.36.672132 Instance:db2inst5 Node:000

PID:227180(db2bm.136044.2 0) TID:1
Appid:*LOCAL.db2inst5.01E7B9020603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

DiagData

0x2426E45C : 0xFFFFF7E8

2005-03-18-23.00.37.177912 Instance:db2inst5 Node:000

PID:227180(db2bm.136044.2 0) TID:1
Appid:*LOCAL.db2inst5.01E7B9020603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

0x2426E45C : 0xFFFFF7E8

2005-03-18-23.00.41.980787 Instance:db2inst5 Node:000

PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.095719040007
database utilities sqlubcka Probe:140 Database:IKWDB001

Backup Terminated.

Nov 12 '05 #3

P: n/a
k. Sorry there was something in the diaglog, If I'm not mistaken isn't
it logging a -818. But on what and why does it only happen
periodically? This backup has worked every night since then. Also, this

problem only started happening since we upgraded to v8. I also included

the backup statement as well. Thanks for your help.

nice db2 backup database IKWDB001 online INCREMENTAL to
/db2backup05/db2inst5/backups , /db2backup06/db2inst5/backups ,
/db2backup07/db2inst5/backups , /db2backup08/db2inst5/backups with 8
buffers buffer 2048 parallelism 4 compress


SQL2072N Unable to bind the shared library "". Reason code: "".

2005-03-18-23.00.07.070691 Instance:db2inst5 Node:000
PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.09571904*0007
database utilities sqlubcka Probe:0 Database:IKWDB001
Starting an incremental database backup.
2005-03-18-23.00.07.070691 Instance:db2inst5 Node:000
PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.09571904*0007
database utilities sqlubcka Probe:0 Database:IKWDB001
Starting an incremental database backup.
2005-03-18-23.00.36.672104 Instance:db2inst5 Node:000
PID:251604(db2bm.136044.3 0) TID:1
Appid:*LOCAL.db2inst5.0810B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

DiagData
0x2391028C : 0xFFFFF7E8
2005-03-18-23.00.36.697042 Instance:db2inst5 Node:000
PID:251604(db2bm.136044.3 0) TID:1
Appid:*LOCAL.db2inst5.0810B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

0x2391028C : 0xFFFFF7E8
2005-03-18-23.00.36.672132 Instance:db2inst5 Node:000
PID:227180(db2bm.136044.2 0) TID:1
Appid:*LOCAL.db2inst5.01E7B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

DiagData
0x2426E45C : 0xFFFFF7E8
2005-03-18-23.00.37.177912 Instance:db2inst5 Node:000
PID:227180(db2bm.136044.2 0) TID:1
Appid:*LOCAL.db2inst5.01E7B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

0x2426E45C : 0xFFFFF7E8
2005-03-18-23.00.41.980787 Instance:db2inst5 Node:000
PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.09571904*0007
database utilities sqlubcka Probe:140 Database:IKWDB001
Backup Terminated.

Nov 12 '05 #4

P: n/a
k. Sorry there was something in the diaglog, If I'm not mistaken isn't
it logging a -818. But on what and why does it only happen
periodically? This backup has worked every night since then. Also, this

problem only started happening since we upgraded to v8. I also included

the backup statement as well. Thanks for your help.
nice db2 backup database IKWDB001 online INCREMENTAL to
/db2backup05/db2inst5/backups , /db2backup06/db2inst5/backups ,
/db2backup07/db2inst5/backups , /db2backup08/db2inst5/backups with 8
buffers buffer 2048 parallelism 4 compress

SQL2072N Unable to bind the shared library "". Reason code: "".
Here is what was in diaglog

2005-03-18-23.00.07.070691 Instance:db2inst5 Node:000
PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.09571904*0007
database utilities sqlubcka Probe:0 Database:IKWDB001
Starting an incremental database backup.
2005-03-18-23.00.36.672104 Instance:db2inst5 Node:000
PID:251604(db2bm.136044.3 0) TID:1
Appid:*LOCAL.db2inst5.0810B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

DiagData
0x2391028C : 0xFFFFF7E8
2005-03-18-23.00.36.697042 Instance:db2inst5 Node:000
PID:251604(db2bm.136044.3 0) TID:1
Appid:*LOCAL.db2inst5.0810B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

0x2391028C : 0xFFFFF7E8
2005-03-18-23.00.36.672132 Instance:db2inst5 Node:000
PID:227180(db2bm.136044.2 0) TID:1
Appid:*LOCAL.db2inst5.01E7B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

DiagData
0x2426E45C : 0xFFFFF7E8
2005-03-18-23.00.37.177912 Instance:db2inst5 Node:000
PID:227180(db2bm.136044.2 0) TID:1
Appid:*LOCAL.db2inst5.01E7B902*0603
database utilities sqluBMLoadComprLibrary Probe:20 Database:IKWDB001

0x2426E45C : 0xFFFFF7E8
2005-03-18-23.00.41.980787 Instance:db2inst5 Node:000
PID:136044(db2agent (IKWDB001) 0) TID:1
Appid:*LOCAL.db2inst5.09571904*0007
database utilities sqlubcka Probe:140 Database:IKWDB001
Backup Terminated.

Nov 12 '05 #5

P: n/a
Here lies the answer in case anybody needs to know:

http://www-1.ibm.com/support/docview...id=swg1IY57670

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.