Skip to main content
Start a Conversation

Unsolved

This post is more than 5 years old

cjzhuang

1 Rookie

 • 

17 Posts

1998

April 3rd, 2007 10:00

Scheduled backups fail on DB2 Version 9.1 on AIX 5.3

Backup Server:Red hat 3.0，Legato NetWorker 7.3.2
Client A: 64 bit AIX 5.3 with HACMP,64 bit DB2 v9.1.0.1,NetWorker 7.3.2 Client,NetWorker Module for DB2 2.1
Client B: 64 bit AIX 5.3 with HACMP,64 bit DB2 v9.1.0.1,NetWorker 7.3.2 Client,NetWorker Module for DB2 2.1

I can manual backup DB2 database successful。I have downloaded and installed the latest NMDB2 (LGTpa91317) hotfix:
gunzip nmdb221_LGTpa91317.aix51w.tar.gz
tar -xvf nmdb221_LGTpa91317.aix51w.tar
mv /usr/bin/nsrdb2sv /usr/bin/nsrdb2svbak
cp nsrdb2sv /usr/bin
nsrdb2sv -f /nsr/script/db2_cfg -P qwe!@#123
04/03/07 21:31:46 nsrdb2sv: Password encryption is successful.
ln -s /usr/opt/IBM/db2/V9.1/lib64 /usr/opt/db2_08_01/lib64
(My DB2 Product is installed at "/usr/opt/IBM/db2/V9.1".)

I have created group "test" with physical hostnames client,but Scheduled backups fail on DB2 Version 9.1 on AIX 5.3
Save Set: DB2:/iabakdb/NODE0000
Remote Access:*@*
Backup Command: nsrdb2sv -f /nsr/script/db2_cfg
Remote user:insttest
Password:qwe!@#123

[root@iacibaksrv root]# savegrp -l Full -Gv test
iacidbsrv1:DB2:/iabakdb/NODE0000 level=full
04/04/07 01:07:03 savegrp: Group will not limit job parallelism
04/04/07 01:07:03 savegrp: iacidbsrv1:probe started
savefs -s iacibaksrv -c iacidbsrv1 -g test -p -l full -R -v -F DB2:/iabakdb/NODE0000
iacidbsrv1:DB2:/iabakdb/NODE0000 level=full, dn=0, mx=1, vers=pools, p=4
* iacidbsrv1:Probe savefs iacidbsrv1: succeeded.
04/04/07 01:07:03 savegrp: iacidbsrv1:probe succeeded.
04/04/07 01:07:03 savegrp: iacidbsrv1:DB2:/iabakdb/NODE0000 started
nsrdb2sv -f /nsr/script/db2_cfg -s iacibaksrv -g test -LL -m iacidbsrv1 -l full -W 78 -N DB2:/iabakdb/NODE0000 DB2:/iabakdb/NODE0000
04/04/07 01:07:04 savegrp: command 'nsrdb2sv -f /nsr/script/db2_cfg -s iacibaksrv -g test -LL -m iacidbsrv1 -l full -W 78 -N DB2:/iabakdb/NODE0000 DB2:/iabakdb/NODE0000 ' for client iacidbsrv1 exited with return code 255.
* iacidbsrv1:DB2:/iabakdb/NODE0000 04/04/07 01:11:53 nsrdb2sv: Writing debug messages to /nsr/applogs/nsrdb2sv.log
* iacidbsrv1:DB2:/iabakdb/NODE0000 04/04/07 01:11:53 nsrdb2sv:
04/04/07 01:07:04 savegrp: iacidbsrv1:DB2:/iabakdb/NODE0000 failed.
04/04/07 01:07:04 savegrp: iacidbsrv1:DB2:/iabakdb/NODE0000 will retry 1 more time(s)
04/04/07 01:07:04 savegrp: iacidbsrv1:DB2:/iabakdb/NODE0000 started
nsrdb2sv -f /nsr/script/db2_cfg -s iacibaksrv -g test -LL -m iacidbsrv1 -l full -W 78 -N DB2:/iabakdb/NODE0000 DB2:/iabakdb/NODE0000
04/04/07 01:07:04 savegrp: command 'nsrdb2sv -f /nsr/script/db2_cfg -s iacibaksrv -g test -LL -m iacidbsrv1 -l full -W 78 -N DB2:/iabakdb/NODE0000 DB2:/iabakdb/NODE0000 ' for client iacidbsrv1 exited with return code 255.
* iacidbsrv1:DB2:/iabakdb/NODE0000 1 retry attempted
* iacidbsrv1:DB2:/iabakdb/NODE0000 04/04/07 01:11:54 nsrdb2sv: Writing debug messages to /nsr/applogs/nsrdb2sv.log
* iacidbsrv1:DB2:/iabakdb/NODE0000 04/04/07 01:11:54 nsrdb2sv:
04/04/07 01:07:04 savegrp: iacidbsrv1:DB2:/iabakdb/NODE0000 failed.
04/04/07 01:07:04 savegrp: iacidbsrv1:index started
save -s iacibaksrv -S -g test -LL -f - -m iacibaksrv -V -l full -LL -W 78 -N index:37deb87d-00000004-46110925-46111c11-00050000-58210009 /nsr/index/iacidbsrv1

iacidbsrv1/nsr/applogs>more nsrdb2sv.log

4/04/07 00:07:14 nsrdb2sv: *** NetWorker Module for DB2 backup session started (1090156) ***
04/04/07 00:07:14 nsrdb2sv: Function libdb2api:ClientConnectionAttrisSet - Node Change returned error -1390.
04/04/07 00:07:14 nsrdb2sv: NMDB2_ERROR: Could not set communication to connect to node 0000
04/04/07 00:07:14 nsrdb2sv: *** NetWorker Module for DB2 backup session started (823736) ***
04/04/07 00:07:14 nsrdb2sv: Function libdb2api:ClientConnectionAttrisSet - Node Change returned error -1390.
04/04/07 00:07:14 nsrdb2sv: NMDB2_ERROR: Could not set communication to connect to node 0000

I have created group "iacidbsrv1_svc_db" with virtual hostnames client,also Scheduled backups fail.
Pls help me !

ble1

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

April 3rd, 2007 11:00

What is LGTpa91317 fixing?

Anyway, if manual one works and scheduled one fails in that case issue is /nsr/script/db2_cfg - can you show content of that file?

cjzhuang

1 Rookie

 • 

17 Posts

April 3rd, 2007 22:00

I have solve the problem,because I set incorrect the DB2_NODE_NAME setting in /nsr/script/db2_cfg。You can read EMC NetWorker Module for DB2 Release 2.1
Release Notes March 07, 2007,In that file,It introduce LGTpa91317、New features and changes。

ble1

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

April 4th, 2007 00:00

Thnx CJ, I had older release note so I was not aware of change.

ble1

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

May 10th, 2007 06:00

Does in your case client initiated backup work? Are you really running 7.2 or is that 7.2.x patched (you can tell that by build number).

EvgenyBG

1 Message

May 10th, 2007 06:00

Hi

I have the same problem with DB2 V9 FixPack 1 and Networker 7.2

Conf file looks like:

hilsapq01:db2q01 53> cat DB2_CFG_Q01
DB2_NODE_NAME=db2q01
DB2INSTANCE=db2q01
DB2_USR=db2q01
DB2_PSWD=lc5w78
DB2_ALIAS=Q01
DB2_VENDOR_LIB_PATH=/usr/lib/libnsrdb2.o
DB2_OPTIONS=DB2BACKUP_DB,DB2BACKUP_FULL,DB2BACKUP_ONLINE,DB2BACKUP_INCLUDE_LOGS
NSR_SERVER=legato02
NSR_CLIENT=hilsapq01
NSR_LOG_VOLUME_POOL=SAPLogs
NSR_DATA_VOLUME_POOL=SAPData
NSR_DB2SV_DEBUG_LEVEL=9
NSR_DB2SV_DEBUG_FILE=/var/adm/nsr_applogs/nsrdb2sv.log
#NSR_DEBUG_LEVEL=1
#NSR_DEBUG_FILE=/var/adm/nsr_applogs/db2debug.log
#NSR_LIBNSRDB2_DEBUG_LEVEL=1
#NSR_LIBNSRDB2_DEBUG_FILE=/var/adm/nsr_applogs/db2sql.log


Log extaction is bellow.

Thanks for Help,

Evgeny

#############################################################
05/10/07 12:05:18 nsrdb2sv: *** NetWorker Module for DB2 backup session started (503890) ***
05/10/07 12:05:18 nsrdb2sv: Found NSR_DB2SV_DEBUG_LEVEL=9
05/10/07 12:05:18 nsrdb2sv: Entering nsrdb2sv_log_program_args()
05/10/07 12:05:18 nsrdb2sv: argv[ 0] = /usr/bin/nsrdb2sv
05/10/07 12:05:18 nsrdb2sv: argv[ 1] = -f
05/10/07 12:05:18 nsrdb2sv: argv[ 2] = /db2/db2q01/DB2_CFG_Q01
05/10/07 12:05:18 nsrdb2sv: argv[ 3] = -s
05/10/07 12:05:18 nsrdb2sv: argv[ 4] = legato02
05/10/07 12:05:18 nsrdb2sv: argv[ 5] = -g
05/10/07 12:05:18 nsrdb2sv: argv[ 6] = Man_SAP
05/10/07 12:05:18 nsrdb2sv: argv[ 7] = -LL
05/10/07 12:05:18 nsrdb2sv: argv[ 8] = -m
05/10/07 12:05:18 nsrdb2sv: argv[ 9] = hilsapq01
05/10/07 12:05:18 nsrdb2sv: argv[10] = -l
05/10/07 12:05:18 nsrdb2sv: argv[11] = full
05/10/07 12:05:18 nsrdb2sv: argv[12] = -W
05/10/07 12:05:18 nsrdb2sv: argv[13] = 78
05/10/07 12:05:18 nsrdb2sv: argv[14] = -N
05/10/07 12:05:18 nsrdb2sv: argv[15] = DB2:/Q01/NODE0000
05/10/07 12:05:18 nsrdb2sv: argv[16] = DB2:/Q01/NODE0000
05/10/07 12:05:18 nsrdb2sv: /usr/bin/nsrdb2sv -f /db2/db2q01/DB2_CFG_Q01 -s legato02 -g Man_SAP -LL -m hilsapq01 -l full -W 78 -N DB2:/Q01/NODE0000 DB2:/Q01/NODE0000
05/10/07 12:05:18 nsrdb2sv: Leaving nsrdb2sv_log_program_args()
05/10/07 12:05:18 nsrdb2sv: Entering db2_log_cfg_file()
05/10/07 12:05:18 nsrdb2sv: Logging "/db2/db2q01/DB2_CFG_Q01" file
05/10/07 12:05:18 nsrdb2sv: DB2_NODE_NAME=db2q01
05/10/07 12:05:18 nsrdb2sv: DB2INSTANCE=db2q01
05/10/07 12:05:18 nsrdb2sv: DB2_USR=db2q01
05/10/07 12:05:18 nsrdb2sv: DB2_PSWD=...
05/10/07 12:05:18 nsrdb2sv: DB2_ALIAS=Q01
05/10/07 12:05:18 nsrdb2sv: DB2_VENDOR_LIB_PATH=/usr/lib/libnsrdb2.o
05/10/07 12:05:18 nsrdb2sv: DB2_OPTIONS=DB2BACKUP_DB,DB2BACKUP_FULL,DB2BACKUP_ONLINE,DB2BACKUP_INCLUDE_LOGS
05/10/07 12:05:18 nsrdb2sv: NSR_SERVER=legato02
05/10/07 12:05:18 nsrdb2sv: NSR_CLIENT=hilsapq01
05/10/07 12:05:18 nsrdb2sv: NSR_LOG_VOLUME_POOL=SAPLogs
05/10/07 12:05:18 nsrdb2sv: NSR_DATA_VOLUME_POOL=SAPData
05/10/07 12:05:18 nsrdb2sv: NSR_DB2SV_DEBUG_LEVEL=9
05/10/07 12:05:18 nsrdb2sv: NSR_DB2SV_DEBUG_FILE=/var/adm/nsr_applogs/nsrdb2sv.log
05/10/07 12:05:18 nsrdb2sv: #NSR_DEBUG_LEVEL=1
05/10/07 12:05:18 nsrdb2sv: #NSR_DEBUG_FILE=/var/adm/nsr_applogs/db2debug.log
05/10/07 12:05:18 nsrdb2sv: #NSR_LIBNSRDB2_DEBUG_LEVEL=1
05/10/07 12:05:18 nsrdb2sv: #NSR_LIBNSRDB2_DEBUG_FILE=/var/adm/nsr_applogs/db2sql.log
05/10/07 12:05:18 nsrdb2sv: Leaving db2_log_cfg_file()
05/10/07 12:05:18 nsrdb2sv: Setting value for DB2INSTANCE db2q01
05/10/07 12:05:18 nsrdb2sv: Trying to set the Node number 0000
05/10/07 12:05:18 nsrdb2sv: sqlesetc -- SET CLIENT
05/10/07 12:05:18 nsrdb2sv: User: db2q01
05/10/07 12:05:18 nsrdb2sv: Password: ******
05/10/07 12:05:18 nsrdb2sv: do_command(): PRECMD not found
05/10/07 12:05:18 nsrdb2sv: Attaching to an instance:
05/10/07 12:05:18 nsrdb2sv: instance alias or name: db2q01
05/10/07 12:05:18 nsrdb2sv: user ID : db2q01
05/10/07 12:05:18 nsrdb2sv: password : ******
05/10/07 12:05:18 nsrdb2sv:

---- error report -----------------------------

application message = libdb2api:sqleatin
line = 723
file = nmdb2api.c
SQLCODE = -1224

SQL1224N The database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated your particular request
due to a problem with your request. SQLSTATE=55032

SQLSTATE 55032: The CONNECT statement is invalid, because the database manager
was stopped after this application was started.

---- end error report ------------------------

05/10/07 12:05:18 nsrdb2sv: Return code from SqlInfoPrint is success but errno is set to A system call received a parameter that is not valid.. Clearing errno
05/10/07 12:05:18 nsrdb2sv: NMDB2_ERROR: InstAttach() failed
05/10/07 12:05:18 nsrdb2sv: Exiting nsrdb2sv: Return Code -1
05/10/07 12:05:18 nsrdb2sv: NMDB2_ERROR: NMDB2 backup failed.
05/10/07 12:05:19 nsrdb2sv: *** NetWorker Module for DB2 backup session started (503892) ***
05/10/07 12:05:19 nsrdb2sv: Found NSR_DB2SV_DEBUG_LEVEL=9
05/10/07 12:05:19 nsrdb2sv: Entering nsrdb2sv_log_program_args()
05/10/07 12:05:19 nsrdb2sv: argv[ 0] = /usr/bin/nsrdb2sv
05/10/07 12:05:19 nsrdb2sv: argv[ 1] = -f
05/10/07 12:05:19 nsrdb2sv: argv[ 2] = /db2/db2q01/DB2_CFG_Q01
05/10/07 12:05:19 nsrdb2sv: argv[ 3] = -s
05/10/07 12:05:19 nsrdb2sv: argv[ 4] = legato02
05/10/07 12:05:19 nsrdb2sv: argv[ 5] = -g
05/10/07 12:05:19 nsrdb2sv: argv[ 6] = Man_SAP
05/10/07 12:05:19 nsrdb2sv: argv[ 7] = -LL
05/10/07 12:05:19 nsrdb2sv: argv[ 8] = -m
05/10/07 12:05:19 nsrdb2sv: argv[ 9] = hilsapq01
05/10/07 12:05:19 nsrdb2sv: argv[10] = -l
05/10/07 12:05:19 nsrdb2sv: argv[11] = full
05/10/07 12:05:19 nsrdb2sv: argv[12] = -W
05/10/07 12:05:19 nsrdb2sv: argv[13] = 78
05/10/07 12:05:19 nsrdb2sv: argv[14] = -N
05/10/07 12:05:19 nsrdb2sv: argv[15] = DB2:/Q01/NODE0000
05/10/07 12:05:19 nsrdb2sv: argv[16] = DB2:/Q01/NODE0000
05/10/07 12:05:19 nsrdb2sv: /usr/bin/nsrdb2sv -f /db2/db2q01/DB2_CFG_Q01 -s legato02 -g Man_SAP -LL -m hilsapq01 -l full -W 78 -N DB2:/Q01/NODE0000 DB2:/Q01/NODE0000
05/10/07 12:05:19 nsrdb2sv: Leaving nsrdb2sv_log_program_args()
05/10/07 12:05:19 nsrdb2sv: Entering db2_log_cfg_file()
05/10/07 12:05:19 nsrdb2sv: Logging "/db2/db2q01/DB2_CFG_Q01" file
05/10/07 12:05:19 nsrdb2sv: DB2_NODE_NAME=db2q01
05/10/07 12:05:19 nsrdb2sv: DB2INSTANCE=db2q01
05/10/07 12:05:19 nsrdb2sv: DB2_USR=db2q01
05/10/07 12:05:19 nsrdb2sv: DB2_PSWD=...
05/10/07 12:05:19 nsrdb2sv: DB2_ALIAS=Q01
05/10/07 12:05:19 nsrdb2sv: DB2_VENDOR_LIB_PATH=/usr/lib/libnsrdb2.o
05/10/07 12:05:19 nsrdb2sv: DB2_OPTIONS=DB2BACKUP_DB,DB2BACKUP_FULL,DB2BACKUP_ONLINE,DB2BACKUP_INCLUDE_LOGS
05/10/07 12:05:19 nsrdb2sv: NSR_SERVER=legato02
05/10/07 12:05:19 nsrdb2sv: NSR_CLIENT=hilsapq01
05/10/07 12:05:19 nsrdb2sv: NSR_LOG_VOLUME_POOL=SAPLogs
05/10/07 12:05:19 nsrdb2sv: NSR_DATA_VOLUME_POOL=SAPData
05/10/07 12:05:19 nsrdb2sv: NSR_DB2SV_DEBUG_LEVEL=9
05/10/07 12:05:19 nsrdb2sv: NSR_DB2SV_DEBUG_FILE=/var/adm/nsr_applogs/nsrdb2sv.log
05/10/07 12:05:19 nsrdb2sv: #NSR_DEBUG_LEVEL=1
05/10/07 12:05:19 nsrdb2sv: #NSR_DEBUG_FILE=/var/adm/nsr_applogs/db2debug.log
05/10/07 12:05:19 nsrdb2sv: #NSR_LIBNSRDB2_DEBUG_LEVEL=1
05/10/07 12:05:19 nsrdb2sv: #NSR_LIBNSRDB2_DEBUG_FILE=/var/adm/nsr_applogs/db2sql.log
05/10/07 12:05:19 nsrdb2sv: Leaving db2_log_cfg_file()
05/10/07 12:05:19 nsrdb2sv: Setting value for DB2INSTANCE db2q01
05/10/07 12:05:19 nsrdb2sv: Trying to set the Node number 0000
05/10/07 12:05:19 nsrdb2sv: sqlesetc -- SET CLIENT
05/10/07 12:05:19 nsrdb2sv: Function libdb2api:ClientConnectionAttrisSet - Node Change returned error -1090.
05/10/07 12:05:19 nsrdb2sv: Return code from ConnectionAttrsSet is success but errno is set to Bad file number. Clearing errno
05/10/07 12:05:19 nsrdb2sv: NMDB2_ERROR: Could not set communication to connect to node 0000
05/10/07 12:05:19 nsrdb2sv: Exiting nsrdb2sv: Return Code -1
05/10/07 12:05:19 nsrdb2sv: NMDB2_ERROR: NMDB2 backup failed.
hilsapq01:db2q01 67>

CroWiz

26 Posts

April 1st, 2008 07:00

i have problem similar to EvgenyBG. if i set wrong node name, i can provoke error similar to CJ Zhuang (SQLCODE -1390), else it is SQLCODE -1224 (as EvgenyBG)

ble1

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

April 4th, 2008 02:00

What about client initiated one?

aldenkamps

9 Posts

October 6th, 2008 08:00

Concerning this exact problem and the solution:

how can you tell what the NODE_NAME (and also NODE_NUM) is?


A lot of our DB2 backups work fine even scheduled but all of the version 9.1.0.4 seem to fail. We already applied the special fix (new nsrdb2sv) but this didn't solve it.

So I am also verifying the db2_cfg file but it is almost the same as the DB2 backups that work.


Regards and thanks in advance.

Steven

aldenkamps

9 Posts

October 6th, 2008 08:00

Concerning this exact problem and the solution:

how can you tell what the NODE_NAME (and also NODE_NUM) is?


A lot of our DB2 backups work fine even scheduled but all of the version 9.1.0.4 seem to fail. We already applied the special fix (new nsrdb2sv) but this didn't solve it.

So I am also verifying the db2_cfg file but it is almost the same as the DB2 backups that work.


Regards and thanks in advance.

Steven

Was this post helpful?

View All

No Events found!

Top