db2syscs.exe CPU usage 100% & db2empfca failing

db2inst2

Hi all,

I am using win2K db2 8.1 fixpak 2.

lately db2syscs.exe started using 100% CPU. This will be the load on
the DB. An application will connect to the machine every 10minutes and
do few selects & inserts, updates. There is no major activity.

db2dart didn't report any error on the DB. I tried increasing the
Bufferpool but no luck. I tried configuring the params with
autoconfigure too.

Since all the tablespaces are SMS i tried to enable multipage file, it
failed with the following error in the db2diag.log

I am so stuck with this.

Thanks in advance for your help

2004-10-01-12.23.58.781000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0012F614 : 0x00000002 ....

PID:2752 TID:2716 Node:000 Title: Path/Filename
C:\PROGRA~1\IBM\SQLLIB\cfg\db2se.lvl

2004-10-01-12.23.58.812000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0012E7C0 : 0x00000003 ....

PID:2752 TID:2716 Node:000 Title: Path/Filename
C:\PROGRA~1\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR

2004-10-01-12.23.58.828000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0012E79C : 0x00000003 ....

PID:2752 TID:2716 Node:000 Title: Path/Filename
C:\PROGRA~1\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK

2004-10-01-12.23.58.890000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186FC364 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00006.BRG

2004-10-01-12.23.59.015000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqlofindf Probe:100

GetLastError:
0x186F8D70 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLOGDIR\SQLOGSEM.LOG

2004-10-01-12.24.00.296000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
data protection sqlpinit Probe:160

Database started with next LSN of 000000198459400C.

2004-10-01-12.24.00.453000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186F8E60 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00003.INX

2004-10-01-12.24.00.484000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186F8E60 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00011.INX

2004-10-01-12.24.00.500000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186F8E60 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00022.INX

2004-10-01-12.24.00.562000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPool Probe:4795
Database:<DBNAME>

Appending pages for tablespace 0.

2004-10-01-12.24.01.203000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqlofindf Probe:100 Database:<DBNAME>

GetLastError:
0x186FA9F0 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0000.0\SQL*.IN1

2004-10-01-12.24.01.218000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPool Probe:4795
Database:<DBNAME>

Appending pages for tablespace 2.

2004-10-01-12.24.01.828000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110 Database:<DBNAME>

GetLastError:
0x186FA8B8 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00011.INX

2004-10-01-12.24.01.859000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPool Probe:232
Database:<DBNAME>

DIA8506C Unexpected end of file was reached.
ZRC=0x870F0009

2004-10-01-12.24.01.859001 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPoolList Probe:3166
Database:<DBNAME>

DIA8506C Unexpected end of file was reached.
ZRC=0x870F0009

PID:1296 TID:2624 Node:000 Title: Tablespace ID:
0x186FAFF4 : 0x00000002 ....

2004-10-01-12.24.01.875001 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqlofica Probe:10 Database:<DBNAME>

PID:1296 TID:2624 Node:000 Title: SQLCA ˆ
0x144645F8 : 5351 4C43 4120 2020 8800 0000 7AFC FFFF SQLCA
ˆ...züÿÿ
0x14464608 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x14464618 : 2020 2020 2020 2020 2020 2020 2020 2020
0x14464628 : 2020 2020 2020 2020 2020 2020 2020 2020
0x14464638 : 2020 2020 2020 2020 2020 2020 2020 2020
0x14464648 : 2020 2020 2020 2020 5351 4C42 454D 5046
SQLBEMPF
0x14464658 : 0900 0F87 0000 0000 0000 0000 0000 0000
..‡............
0x14464668 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x14464678 : 2020 2035 3830 3035 58005

2004-10-01-12.24.01.890000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:*LOCAL.DB2.0155C1192358
DRDA Application Requester sqljrDrdaArCall Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8037006D".

Nov 12 '05 #1

Mark Yudkin

Had a similar problem. Install 8.1.5 or above.
"db2inst2" <db******@gmail.com> wrote in message
news:10**************************@posting.google.c om...

Hi all,

I am using win2K db2 8.1 fixpak 2.

lately db2syscs.exe started using 100% CPU. This will be the load on
the DB. An application will connect to the machine every 10minutes and
do few selects & inserts, updates. There is no major activity.

db2dart didn't report any error on the DB. I tried increasing the
Bufferpool but no luck. I tried configuring the params with
autoconfigure too.

Since all the tablespaces are SMS i tried to enable multipage file, it
failed with the following error in the db2diag.log

I am so stuck with this.

Thanks in advance for your help

2004-10-01-12.23.58.781000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0012F614 : 0x00000002 ....

PID:2752 TID:2716 Node:000 Title: Path/Filename
C:\PROGRA~1\IBM\SQLLIB\cfg\db2se.lvl

2004-10-01-12.23.58.812000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0012E7C0 : 0x00000003 ....

PID:2752 TID:2716 Node:000 Title: Path/Filename
C:\PROGRA~1\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR

2004-10-01-12.23.58.828000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:none
oper system services sqloopenp Probe:110

GetLastError:
0x0012E79C : 0x00000003 ....

PID:2752 TID:2716 Node:000 Title: Path/Filename
C:\PROGRA~1\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK

2004-10-01-12.23.58.890000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186FC364 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00006.BRG

2004-10-01-12.23.59.015000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqlofindf Probe:100

GetLastError:
0x186F8D70 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLOGDIR\SQLOGSEM.LOG

2004-10-01-12.24.00.296000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
data protection sqlpinit Probe:160

Database started with next LSN of 000000198459400C.

2004-10-01-12.24.00.453000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186F8E60 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00003.INX

2004-10-01-12.24.00.484000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186F8E60 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00011.INX

2004-10-01-12.24.00.500000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110

GetLastError:
0x186F8E60 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00022.INX

2004-10-01-12.24.00.562000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPool Probe:4795
Database:<DBNAME>

Appending pages for tablespace 0.

2004-10-01-12.24.01.203000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqlofindf Probe:100 Database:<DBNAME>

GetLastError:
0x186FA9F0 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0000.0\SQL*.IN1

2004-10-01-12.24.01.218000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPool Probe:4795
Database:<DBNAME>

Appending pages for tablespace 2.

2004-10-01-12.24.01.828000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqloopenp Probe:110 Database:<DBNAME>

GetLastError:
0x186FA8B8 : 0x00000002 ....

PID:1296 TID:2624 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00006\SQLT0002.0\SQL00011.INX

2004-10-01-12.24.01.859000 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPool Probe:232
Database:<DBNAME>

DIA8506C Unexpected end of file was reached.
ZRC=0x870F0009

2004-10-01-12.24.01.859001 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
buffer pool services sqlbAppendPagesForPoolList Probe:3166
Database:<DBNAME>

DIA8506C Unexpected end of file was reached.
ZRC=0x870F0009

PID:1296 TID:2624 Node:000 Title: Tablespace ID:
0x186FAFF4 : 0x00000002 ....

2004-10-01-12.24.01.875001 Instance:DB2 Node:000
PID:1296(db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.0155C1192358
oper system services sqlofica Probe:10 Database:<DBNAME>

PID:1296 TID:2624 Node:000 Title: SQLCA ^
0x144645F8 : 5351 4C43 4120 2020 8800 0000 7AFC FFFF SQLCA
^...züÿÿ
0x14464608 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x14464618 : 2020 2020 2020 2020 2020 2020 2020 2020
0x14464628 : 2020 2020 2020 2020 2020 2020 2020 2020
0x14464638 : 2020 2020 2020 2020 2020 2020 2020 2020
0x14464648 : 2020 2020 2020 2020 5351 4C42 454D 5046
SQLBEMPF
0x14464658 : 0900 0F87 0000 0000 0000 0000 0000 0000
..?............
0x14464668 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x14464678 : 2020 2035 3830 3035 58005

2004-10-01-12.24.01.890000 Instance:DB2 Node:000
PID:2752(db2empfa.exe) TID:2716 Appid:*LOCAL.DB2.0155C1192358
DRDA Application Requester sqljrDrdaArCall Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8037006D".

Nov 12 '05 #2

db2inst2

The application that we are using doesn't support that version of DB2
:(. So i got to figure out a way to fix.

Thanks for the response though.

"Mark Yudkin" <my***********************@nospam.org> wrote in message news:<cj**********@ngspool-d02.news.aol.com>...

Had a similar problem. Install 8.1.5 or above.
"db2inst2" <db******@gmail.com> wrote in message
news:10**************************@posting.google.c om...

Hi all,

I am using win2K db2 8.1 fixpak 2.

lately db2syscs.exe started using 100% CPU. This will be the load on
the DB. An application will connect to the machine every 10minutes and
do few selects & inserts, updates. There is no major activity.

Nov 12 '05 #3