What is these messages in the db2diag.log ?

[Odd Bjørn Andersen]

Every night at 21.30 we perform a full offline database backup. Just before the backup starts we do a db2stop/db2start. After the db2stop there is a message in the db2diag.log, and after the backup there is another message. And this happens every time. Here is an extract of the db2diag.log:
2004-03-01-21.30.38.812504 Instance:db2bpu 1 Node:000

PID:25106(db2st op2) Appid:none

base_sys_utilit ies stopdbm Probe:911

Database manager is stopped.

2004-03-01-21.30.40.505322 Instance:db2bpu 1 Node:000

PID:16712(db2sp mrm) Appid:none

oper_system_ser vices sqloopenp Probe:20

errno: 0000 0011 ....

String Title:Path/Filename PID:16712 Node:000

/bpufs/files/sqllib/spmlog/SPMLOG.LCF

2004-03-01-21.30.40.692473 Instance:db2bpu 1 Node:000

PID:25110(db2st ar2) Appid:none

base_sys_utilit ies startdbm Probe:911

Database manager is started.

2004-03-01-21.30.45.845152 Instance:db2bpu 1 Node:000

PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040

database_utilit ies sqlubcka Probe:0 Database:XDJO00

Starting a full database backup.

2004-03-01-21.37.15.258024 Instance:db2bpu 1 Node:000

PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040

database_utilit ies sqlubcka Probe:0 Database:XDJO00

Backup Complete.

2004-03-01-21.37.20.560258 Instance:db2bpu 1 Node:000

PID:59966(db2bp ) Appid:*LOCAL.db 2bpu1.040302033 040

base_sys_utilit ies sqle_db2ra_ar_r stdet Probe:18

DIA9999E An internal error occurred. Report the following error code : "0x

47".

Everythings seems to work fine in the database afterwards. I just wondered if anyone have seen something like this before, and what it means, or know if this is serious ?
--
Regards
-----------
Odd Bjørn Andersen
ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon [phone], Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

[dbtnews.torolab.ibm.com]

Your first message indicates that someone ran the db2stop command and the instance (database manager) was stopped

Your second message indicates that someone ran the db2start command and the instance (database manager) was started

Your third message indicates that the backup command was issued and DB2 has started to backup the database

Your fourth message indicates the backup completed

Hope this helps,
...Dwaine

"Odd Bjørn Andersen" <od**********@e rgo.no> wrote in message news:10******** *******@makrell .interpost.no.. .
Every night at 21.30 we perform a full offline database backup. Just before the backup starts we do a db2stop/db2start. After the db2stop there is a message in the db2diag.log, and after the backup there is another message. And this happens every time. Here is an extract of the db2diag.log:
2004-03-01-21.30.38.812504 Instance:db2bpu 1 Node:000

PID:25106(db2st op2) Appid:none

base_sys_utilit ies stopdbm Probe:911

Database manager is stopped.

2004-03-01-21.30.40.505322 Instance:db2bpu 1 Node:000

PID:16712(db2sp mrm) Appid:none

oper_system_ser vices sqloopenp Probe:20

errno: 0000 0011 ....

String Title:Path/Filename PID:16712 Node:000

/bpufs/files/sqllib/spmlog/SPMLOG.LCF

2004-03-01-21.30.40.692473 Instance:db2bpu 1 Node:000

PID:25110(db2st ar2) Appid:none

base_sys_utilit ies startdbm Probe:911

Database manager is started.

2004-03-01-21.30.45.845152 Instance:db2bpu 1 Node:000

PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040

database_utilit ies sqlubcka Probe:0 Database:XDJO00

Starting a full database backup.

2004-03-01-21.37.15.258024 Instance:db2bpu 1 Node:000

PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040

database_utilit ies sqlubcka Probe:0 Database:XDJO00

Backup Complete.

2004-03-01-21.37.20.560258 Instance:db2bpu 1 Node:000

PID:59966(db2bp ) Appid:*LOCAL.db 2bpu1.040302033 040

base_sys_utilit ies sqle_db2ra_ar_r stdet Probe:18

DIA9999E An internal error occurred. Report the following error code : "0x

47".

Everythings seems to work fine in the database afterwards. I just wondered if anyone have seen something like this before, and what it means, or know if this is serious ?
--
Regards
-----------
Odd Bjørn Andersen
ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon [phone], Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

[Odd Bjørn Andersen]

Thank you for your answer, but what I was wondering about was the following messages:
........
2004-03-01-21.30.40.505322 Instance:db2bpu 1 Node:000

PID:16712(db2sp mrm) Appid:none

oper_system_ser vices sqloopenp Probe:20

errno: 0000 0011 ....

..............

2004-03-01-21.37.20.560258 Instance:db2bpu 1 Node:000

PID:59966(db2bp ) Appid:*LOCAL.db 2bpu1.040302033 040

base_sys_utilit ies sqle_db2ra_ar_r stdet Probe:18

DIA9999E An internal error occurred. Report the following error code : "0x

47".

To me they seem to report some kind of error state, but I have not been able to figure out what kind...

Regards

Odd Bjørn

"dbtnews.torola b.ibm.com" <ds***@ca.ibm.c om> wrote in message news:c2******** **@hanover.toro lab.ibm.com...
Your first message indicates that someone ran the db2stop command and the instance (database manager) was stopped

Your second message indicates that someone ran the db2start command and the instance (database manager) was started

Your third message indicates that the backup command was issued and DB2 has started to backup the database

Your fourth message indicates the backup completed

Hope this helps,
..Dwaine

"Odd Bjørn Andersen" <od**********@e rgo.no> wrote in message news:10******** *******@makrell .interpost.no.. .
Every night at 21.30 we perform a full offline database backup. Just before the backup starts we do a db2stop/db2start. After the db2stop there is a message in the db2diag.log, and after the backup there is another message. And this happens every time. Here is an extract of the db2diag.log:
2004-03-01-21.30.38.812504 Instance:db2bpu 1 Node:000

PID:25106(db2st op2) Appid:none

base_sys_utilit ies stopdbm Probe:911

Database manager is stopped.

2004-03-01-21.30.40.505322 Instance:db2bpu 1 Node:000

PID:16712(db2sp mrm) Appid:none

oper_system_ser vices sqloopenp Probe:20

errno: 0000 0011 ....

String Title:Path/Filename PID:16712 Node:000

/bpufs/files/sqllib/spmlog/SPMLOG.LCF

2004-03-01-21.30.40.692473 Instance:db2bpu 1 Node:000

PID:25110(db2st ar2) Appid:none

base_sys_utilit ies startdbm Probe:911

Database manager is started.

2004-03-01-21.30.45.845152 Instance:db2bpu 1 Node:000

PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040

database_utilit ies sqlubcka Probe:0 Database:XDJO00

Starting a full database backup.

2004-03-01-21.37.15.258024 Instance:db2bpu 1 Node:000

PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040

database_utilit ies sqlubcka Probe:0 Database:XDJO00

Backup Complete.

2004-03-01-21.37.20.560258 Instance:db2bpu 1 Node:000

PID:59966(db2bp ) Appid:*LOCAL.db 2bpu1.040302033 040

base_sys_utilit ies sqle_db2ra_ar_r stdet Probe:18

DIA9999E An internal error occurred. Report the following error code : "0x

47".

Everythings seems to work fine in the database afterwards. I just wondered if anyone have seen something like this before, and what it means, or know if this is serious ?
--
Regards
-----------
Odd Bjørn Andersen
ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon [phone], Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

[Matt Emmerton]

[ stripped HTML formatting ]

The first probe (sqloopenp, probe 20, errno 0x11) is a harmless warning.
(DB2 tried to create a file which already existed.)

The second probe (sqle_db2ra_ar_ rstdet, probe 18, errno 0x47) is also
harmless.
(The other end of a communications channel disconnected prematurely, which
sometimes happens.)

--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab

"Odd Bjørn Andersen" <od**********@e rgo.no> wrote in message
news:10******** *******@makrell .interpost.no.. .
Thank you for your answer, but what I was wondering about was the following
messages:
........
2004-03-01-21.30.40.505322 Instance:db2bpu 1 Node:000
PID:16712(db2sp mrm) Appid:none
oper_system_ser vices sqloopenp Probe:20
errno: 0000 0011 ....
..............
2004-03-01-21.37.20.560258 Instance:db2bpu 1 Node:000
PID:59966(db2bp ) Appid:*LOCAL.db 2bpu1.040302033 040
base_sys_utilit ies sqle_db2ra_ar_r stdet Probe:18
DIA9999E An internal error occurred. Report the following error code : "0x
47".
To me they seem to report some kind of error state, but I have not been able
to figure out what kind...

Regards
Odd Bjørn
"dbtnews.torola b.ibm.com" <ds***@ca.ibm.c om> wrote in message
news:c2******** **@hanover.toro lab.ibm.com...
Your first message indicates that someone ran the db2stop command and the
instance (database manager) was stopped

Your second message indicates that someone ran the db2start command and the
instance (database manager) was started

Your third message indicates that the backup command was issued and DB2 has
started to backup the database

Your fourth message indicates the backup completed

Hope this helps,
...Dwaine

"Odd Bjørn Andersen" <od**********@e rgo.no> wrote in message
news:10******** *******@makrell .interpost.no.. .
Every night at 21.30 we perform a full offline database backup. Just before
the backup starts we do a db2stop/db2start. After the db2stop there is a
message in the db2diag.log, and after the backup there is another message.
And this happens every time. Here is an extract of the db2diag.log:
2004-03-01-21.30.38.812504 Instance:db2bpu 1 Node:000
PID:25106(db2st op2) Appid:none
base_sys_utilit ies stopdbm Probe:911
Database manager is stopped.
2004-03-01-21.30.40.505322 Instance:db2bpu 1 Node:000
PID:16712(db2sp mrm) Appid:none
oper_system_ser vices sqloopenp Probe:20
errno: 0000 0011 ....

String Title:Path/Filename PID:16712 Node:000
/bpufs/files/sqllib/spmlog/SPMLOG.LCF
2004-03-01-21.30.40.692473 Instance:db2bpu 1 Node:000
PID:25110(db2st ar2) Appid:none
base_sys_utilit ies startdbm Probe:911
Database manager is started.
2004-03-01-21.30.45.845152 Instance:db2bpu 1 Node:000
PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040
database_utilit ies sqlubcka Probe:0 Database:XDJO00
Starting a full database backup.
2004-03-01-21.37.15.258024 Instance:db2bpu 1 Node:000
PID:25112(db2ag ent (XDJO00)) Appid:*LOCAL.db 2bpu1.040302033 040
database_utilit ies sqlubcka Probe:0 Database:XDJO00
Backup Complete.
2004-03-01-21.37.20.560258 Instance:db2bpu 1 Node:000
PID:59966(db2bp ) Appid:*LOCAL.db 2bpu1.040302033 040
base_sys_utilit ies sqle_db2ra_ar_r stdet Probe:18
DIA9999E An internal error occurred. Report the following error code : "0x
47".
Everythings seems to work fine in the database afterwards. I just wondered
if anyone have seen something like this before, and what it means, or know
if this is serious ?

--
Regards
-----------
Odd Bjørn Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon [phone], Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no