473,378 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

What is these messages in the db2diag.log ?

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:db2bpu1 Node:000

PID:25106(db2stop2) Appid:none

base_sys_utilities stopdbm Probe:911

Database manager is stopped.

2004-03-01-21.30.40.505322 Instance:db2bpu1 Node:000

PID:16712(db2spmrm) Appid:none

oper_system_services 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:db2bpu1 Node:000

PID:25110(db2star2) Appid:none

base_sys_utilities startdbm Probe:911

Database manager is started.

2004-03-01-21.30.45.845152 Instance:db2bpu1 Node:000

PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040

database_utilities sqlubcka Probe:0 Database:XDJO00

Starting a full database backup.

2004-03-01-21.37.15.258024 Instance:db2bpu1 Node:000

PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040

database_utilities sqlubcka Probe:0 Database:XDJO00

Backup Complete.

2004-03-01-21.37.20.560258 Instance:db2bpu1 Node:000

PID:59966(db2bp) Appid:*LOCAL.db2bpu1.040302033040

base_sys_utilities sqle_db2ra_ar_rstdet 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 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no
Nov 12 '05 #1
3 5532
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**********@ergo.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:db2bpu1 Node:000

PID:25106(db2stop2) Appid:none

base_sys_utilities stopdbm Probe:911

Database manager is stopped.

2004-03-01-21.30.40.505322 Instance:db2bpu1 Node:000

PID:16712(db2spmrm) Appid:none

oper_system_services 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:db2bpu1 Node:000

PID:25110(db2star2) Appid:none

base_sys_utilities startdbm Probe:911

Database manager is started.

2004-03-01-21.30.45.845152 Instance:db2bpu1 Node:000

PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040

database_utilities sqlubcka Probe:0 Database:XDJO00

Starting a full database backup.

2004-03-01-21.37.15.258024 Instance:db2bpu1 Node:000

PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040

database_utilities sqlubcka Probe:0 Database:XDJO00

Backup Complete.

2004-03-01-21.37.20.560258 Instance:db2bpu1 Node:000

PID:59966(db2bp) Appid:*LOCAL.db2bpu1.040302033040

base_sys_utilities sqle_db2ra_ar_rstdet 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 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no
Nov 12 '05 #2
Thank you for your answer, but what I was wondering about was the following messages:
........
2004-03-01-21.30.40.505322 Instance:db2bpu1 Node:000

PID:16712(db2spmrm) Appid:none

oper_system_services sqloopenp Probe:20

errno: 0000 0011 ....

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

2004-03-01-21.37.20.560258 Instance:db2bpu1 Node:000

PID:59966(db2bp) Appid:*LOCAL.db2bpu1.040302033040

base_sys_utilities sqle_db2ra_ar_rstdet 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.torolab.ibm.com" <ds***@ca.ibm.com> wrote in message news:c2**********@hanover.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**********@ergo.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:db2bpu1 Node:000

PID:25106(db2stop2) Appid:none

base_sys_utilities stopdbm Probe:911

Database manager is stopped.

2004-03-01-21.30.40.505322 Instance:db2bpu1 Node:000

PID:16712(db2spmrm) Appid:none

oper_system_services 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:db2bpu1 Node:000

PID:25110(db2star2) Appid:none

base_sys_utilities startdbm Probe:911

Database manager is started.

2004-03-01-21.30.45.845152 Instance:db2bpu1 Node:000

PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040

database_utilities sqlubcka Probe:0 Database:XDJO00

Starting a full database backup.

2004-03-01-21.37.15.258024 Instance:db2bpu1 Node:000

PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040

database_utilities sqlubcka Probe:0 Database:XDJO00

Backup Complete.

2004-03-01-21.37.20.560258 Instance:db2bpu1 Node:000

PID:59966(db2bp) Appid:*LOCAL.db2bpu1.040302033040

base_sys_utilities sqle_db2ra_ar_rstdet 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 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no
Nov 12 '05 #3
[ 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**********@ergo.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:db2bpu1 Node:000
PID:16712(db2spmrm) Appid:none
oper_system_services sqloopenp Probe:20
errno: 0000 0011 ....
..............
2004-03-01-21.37.20.560258 Instance:db2bpu1 Node:000
PID:59966(db2bp) Appid:*LOCAL.db2bpu1.040302033040
base_sys_utilities sqle_db2ra_ar_rstdet 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.torolab.ibm.com" <ds***@ca.ibm.com> wrote in message
news:c2**********@hanover.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**********@ergo.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:db2bpu1 Node:000
PID:25106(db2stop2) Appid:none
base_sys_utilities stopdbm Probe:911
Database manager is stopped.
2004-03-01-21.30.40.505322 Instance:db2bpu1 Node:000
PID:16712(db2spmrm) Appid:none
oper_system_services 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:db2bpu1 Node:000
PID:25110(db2star2) Appid:none
base_sys_utilities startdbm Probe:911
Database manager is started.
2004-03-01-21.30.45.845152 Instance:db2bpu1 Node:000
PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040
database_utilities sqlubcka Probe:0 Database:XDJO00
Starting a full database backup.
2004-03-01-21.37.15.258024 Instance:db2bpu1 Node:000
PID:25112(db2agent (XDJO00)) Appid:*LOCAL.db2bpu1.040302033040
database_utilities sqlubcka Probe:0 Database:XDJO00
Backup Complete.
2004-03-01-21.37.20.560258 Instance:db2bpu1 Node:000
PID:59966(db2bp) Appid:*LOCAL.db2bpu1.040302033040
base_sys_utilities sqle_db2ra_ar_rstdet 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 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Frank Hauptlorenz | last post by:
Hello Folks, does anybody know what these message in the db2diag.log means: 2003-12-10-09.49.33.250000 Instance:DB2 Node:000 PID:812(db2syscs.exe) TID:772 ...
7
by: Shawn | last post by:
We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and no new line written into it for few days. The last lines in db2diag.log shows: Warning: active log held by dirty pages....
15
by: Walter Dnes (delete the 'z' to get my real address | last post by:
I'm trying to initialize an array of error messages, so that I can print out an error message by using the 'nth string in an array, e.g. printf("%s\n", messages); I'm still hazy on arrays of...
3
by: ariel | last post by:
Hello, I am running DB2 version v8.1.3.88 on a Sun v40z server running RedHat Linux AS 4 kernel version 2.6.9. My problem is that the db2diag.log file is growing without bounds (I just deleted a...
14
by: Gio Galma | last post by:
how I can invoke the db2diag utility in a Windows environment? in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only db2diag.dll, and it seems there isn't the command line version; which...
5
by: Gregor Kovač | last post by:
Hi! If I do IMPORT with ADMIN_CMD procedure and use MESSAGES ON SERVER option with IMPORT where are those messages stored? I know ADMIN_CMD returns a result set for IMPORT and an SQL I can get...
5
by: Norm | last post by:
Does anyone have any suggestions for securing against this vulnerability: http://nvd.nist.gov/nvd.cfm?cvename=CVE-2007-1027 Fixes are not yet available from IBM. They will be in FP2 for V9...
6
by: KG | last post by:
Hi, Does anyone knows how to recover the test file db2diag.log. By mistake I have delete the contents of db2diag.log, wondering if I could restore the contents of my db2diag.log.
0
by: eddy82 | last post by:
Hi All, I have this db2start in my db2diag.log everyday around the same time. But no db2stop in the db2diag.log or in the db2.nfy. I already check and no corruption or cronjob running during...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.