UNSOLVED

wuxiaodong

updated

20 years ago

W

wuxiaodong

10 Posts

0

2123

November 17th, 2006 00:00

Can't backup db2 with nmdb2 2.1 for HP_UX

$ db2level

DB21085I Instance "db2st32" uses "32" bits and DB2 code release "SQL08016"

with level identifier "02070106".

Informational tokens are "DB2 v8.1.0.56", "s040616", "U497646", and FixPak "6".

Product is installed at "/opt/IBM/db2/V8.1".



$ uname -a

HP-UX workf1 B.11.11 U 9000/800 3101864130 unlimited-user license



$ db2 backup db FBPMDB online load /usr/lib/libnsrdb2.sl

SQL2079N An error was reported by the shared library "/usr/lib/libnsrdb2.sl".

Return code: "30".

$ ls

nmdb2.log

$ more *

14978#0 Wed Nov 15 09:40:24 2006 nsrdb2_check_init_input: NMDB2_ERROR: Invalid backup type

14978#0 Wed Nov 15 09:40:24 2006 sqluvdel: NMDB2_ERROR

16314#0 Wed Nov 15 09:41:37 2006 nsrdb2_check_init_input: NMDB2_ERROR: Invalid backup type

16314#0 Wed Nov 15 09:41:37 2006 sqluvdel: NMDB2_ERROR

16486#0 Wed Nov 15 09:44:15 2006 nsrdb2_check_init_input: NMDB2_ERROR: Invalid backup type

16486#0 Wed Nov 15 09:44:15 2006 sqluvdel: NMDB2_ERROR

17903#0 Wed Nov 15 10:00:32 2006 nsrdb2_check_init_input: NMDB2_ERROR: Invalid backup type

17903#0 Wed Nov 15 10:00:32 2006 sqluvdel: NMDB2_ERROR

18422#0 Wed Nov 15 10:04:28 2006 nsrdb2_check_init_input: NMDB2_ERROR: Invalid backup type

18422#0 Wed Nov 15 10:04:28 2006 sqluvdel: NMDB2_ERROR



something in db2diag.log:

Starting a full database backup.

2006-11-15-10.28.55.434313 Instance:db2st32 Node:000
PID:20704(db2med.20702.0 0) TID:1 Appid:none
database utilities sqluvintCall Probe:10

Signal encountered in sqluvint

0x6FFF1E10 : 0x800F00AF ....

2006-11-15-10.28.55.437964 Instance:db2st32 Node:000
PID:20704(db2med.20702.0 0) TID:1 Appid:none
database utilities sqluMapVend2MediaRCWithLog Probe:0

Vendor error: rc = 30 returned from function sqluvint.
Return_code structure from vendor library libnsrdb2.sl:


0x6FFF1C58 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x6FFF1C68 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x6FFF1C78 : 0000 0000 0000 0000 ........

2006-11-15-10.28.55.441083 Instance:db2st32 Node:000
PID:20704(db2med.20702.0 0) TID:1 Appid:none
database utilities sqluMCInitBackupMC Probe:85

Media controller -- vendor device initialization error (zrc = 0x0000001e)





otherwise,db2uext can archive log rightly.

PS:I use NMDB2 2.1

who can help me?
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    813

    0

    Posted November 17th, 2006 01:00

    From what is posted it looks like as API used by DB2 module has some problems, but I can't decrypt what exactly (might be related to module, might be related to patch level of the box or application). I would suggest to open this with support. Did this ever worked for you or is this new installation?
  • wuxiaodong

    10 Posts

    813

    0

    Posted November 17th, 2006 19:00

    It's a new installation.

    But the NMDB2 2.1 is too old.......Feb 7,2006......
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    813

    0

    Posted November 18th, 2006 07:00

    What makes you think it's too old? I believe it's current.
  • wuxiaodong

    10 Posts

    813

    0

    Posted November 19th, 2006 19:00

    it is created at Feb 7,2006 and now is Nov 20,2006.......
    DB2 may have many changes on 9 months,i think
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    813

    0

    Posted November 20th, 2006 00:00

    I'm quite sure you can have that module for years. DB2 gets changed, but minor releases do not change anything, but rather patch things up. Also, when it comes to backup API there is no much change even in major releases.. once there is change then module needs to be tested and if there is not reason for change it remains. Currently all DB2 8.x are supported by this module.
  • cjzhuang

    1 Rookie

    •

    17 Posts

    813

    0

    Posted November 20th, 2006 23:00

    Hi Wuxiaodong,I am Caijia Zhuang,we have meet in Chengdu。you can use the NMDB2 1.5 for HP-UX module ,because the 1.5 version is also full support db2 8.1 too 。and you need to concern the 32 bit or 64 bit db2 software,you must select the match db2 module software version。my msn is zcjgrace@hotmail.com, I hope to talk with you.