ADSM-L

DB2 backup problem

2002-12-09 08:53:17
Subject: DB2 backup problem
From: Lars Bebensee <LBebensee AT HAITEC DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Dec 2002 14:50:35 +0100
Hi guys and girls,

hope there is some kind of DB2 guru reading in this list. When doing a DB2
backup we are getting the following messages in the appropriate DB2 diag
log:

2002-12-08-18.00.35.226529   Instance:db2minst   Node:001
PID:90534(db2agent (DB2MPROD) 1)   Appid:C0A80196.046F.021207182454
base_sys_utilities  sqleflsr   Probe:3   Database:DB2MPROD

DiagData
0000 0150                                     ...P


2002-12-08-18.00.35.260127   Instance:db2minst   Node:001
PID:90534(db2agent (DB2MPROD) 1)   Appid:C0A80196.046F.021207182454
base_sys_utilities  sqleflsr   Probe:3   Database:DB2MPROD

RIDS/sqleflsr MS/ABNOR_TERRM PRCS/30000 0150
...P


2002-12-08-18.00.35.270169   Instance:db2minst   Node:001
PID:90534(db2agent (DB2MPROD) 1)   Appid:C0A80196.046F.021207182454
base_sys_utilities  sqleflsr   Probe:4   Database:DB2MPROD

DiagData
5351 4c43 4120 2020 0000 0088 ffff fb38       SQLCA   ....ÿÿû8
0000 2020 2020 2020 2020 2020 2020 2020       ..
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 5351 4c45 4941 4754               SQLEIAGT
0000 0000 0000 0000 0000 0000 0000 0000       ................
0000 0000 0000 0001 2020 2020 2020 2020       ........
2020 2020 2020 2020


2002-12-08-18.00.35.293557   Instance:db2minst   Node:001
PID:90534(db2agent (DB2MPROD) 1)   Appid:C0A80196.046F.021207182454
base_sys_utilities  sqleflsr   Probe:4   Database:DB2MPROD

RIDS/sqleflsr MS/ABNOR_TERRM PRCS/45351 4c43 4120 2020 0000 0088 ffff fb38
SQLCA   ....ÿÿû8
0000 2020 2020 2020 2020 2020 2020 2020       ..
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 5351 4c45 4941 4754               SQLEIAGT
0000 0000 0000 0000 0000 0000 0000 0000       ................
0000 0000 0000 0001 2020 2020 2020 2020       ........
2020 2020 2020 2020


2002-12-08-18.00.51.894542   Instance:db2minst   Node:001
PID:26964(db2agent (DB2MPROD) 1)   Appid:
base_sys_utilities  sqleMergeSqlca   Probe:20   Database:DB2MPROD

Received sqlcode 1496 for request 8000001e from node number 2

Data Title:SQLCA PID:26964 Node:001
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: 1496   sqlerrml: 0
 sqlerrmc:
 sqlerrp : SQLESRSU
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000002
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)       (11)
 sqlstate:


2002-12-08-18.00.55.880949   Instance:db2minst   Node:001
PID:102342(db2spmrm 1)   Appid:none
oper_system_services  sqloopenp   Probe:36

errno: 0000 0011                                     ....


2002-12-08-18.01.15.702362   Instance:db2minst   Node:001
PID:95324(db2bp)   Appid:*N1.db2minst.021208170115
database_utilities  sqlubckp   Probe:26

DiagData
ffff fbf5                                     ÿÿûõ


2002-12-08-18.01.18.341954   Instance:db2minst   Node:002
PID:55850(db2bp)   Appid:*N2.db2minst.021208170118
database_utilities  sqlubckp   Probe:26

DiagData
ffff fbf5                                     ÿÿûõ

The database is running on AIX 4.3.3 and is backed up up offline after
stopping it with a "db2stop force" and starting it with "db2start".

Your help is very much appreciated

Cya Lars
<Prev in Thread] Current Thread [Next in Thread>
  • DB2 backup problem, Lars Bebensee <=