Unix Technical Forum

Errors in DB2DIAG.LOG

This is a discussion on Errors in DB2DIAG.LOG within the DB2 forums, part of the Database Server Software category; --> DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 06:22 AM
Pierre Saint-Jacques
 
Posts: n/a
Default Errors in DB2DIAG.LOG

DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022" with
level identifier "03030106".
Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086", and
FixPak "9".
Product is installed at "D:\SQLLIB".

I'm getting the following in my db2diag.log - This appears every 4-5 minutes and is realy "polluting" my file and disk space.
Any ideas????

Thanks for the help, Pierre.

2005-11-11-15.57.43.220000-300 I2637227H394 LEVEL: Info
PID : 4324 TID : 1436 PROC : db2fmp.exe
INSTANCE: SES NODE : 000
APPID : *LOCAL.SES.051111205743
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x04A9E934 : 4700 0000 G...

2005-11-11-15.57.43.230000-300 I2637623H380 LEVEL: Info
PID : 4324 TID : 1436 PROC : db2fmp.exe
INSTANCE: SES NODE : 000
APPID : *LOCAL.SES.051111205743
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"

2005-11-11-15.57.43.230000-300 I2638005H359 LEVEL: Info
PID : 4324 TID : 1436 PROC : db2fmp.exe
INSTANCE: SES NODE : 000
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x04A9FB20 : 4700 0000 G...

2005-11-11-15.57.43.240000-300 I2638366H345 LEVEL: Info
PID : 4324 TID : 1436 PROC : db2fmp.exe
INSTANCE: SES NODE : 000
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"

2005-11-11-15.57.43.461000-300 I2638713H394 LEVEL: Info
PID : 4324 TID : 1436 PROC : db2fmp.exe
INSTANCE: SES NODE : 000
APPID : *LOCAL.SES.051111205744
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x04A9F600 : 4700 0000 G...

2005-11-11-15.57.43.471000-300 I2639109H380 LEVEL: Info
PID : 4324 TID : 1436 PROC : db2fmp.exe
INSTANCE: SES NODE : 000
APPID : *LOCAL.SES.051111205744
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"


--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 06:22 AM
mike_li
 
Posts: n/a
Default Re: Errors in DB2DIAG.LOG

Looks like the fault monitor daemon process is kicking.
you can disable fault monitor using: db2fmcu -d.
Then try to fix sqljcReceive problem.




Jacques wrote:
> DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022" with
> level identifier "03030106".
> Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086", and
> FixPak "9".
> Product is installed at "D:\SQLLIB".
>
> I'm getting the following in my db2diag.log - This appears every 4-5 minutes and is realy "polluting" my file and disk space.
> Any ideas????
>
> Thanks for the help, Pierre.
>
> 2005-11-11-15.57.43.220000-300 I2637227H394 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205743
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9E934 : 4700 0000 G...
>
> 2005-11-11-15.57.43.230000-300 I2637623H380 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205743
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> 2005-11-11-15.57.43.230000-300 I2638005H359 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9FB20 : 4700 0000 G...
>
> 2005-11-11-15.57.43.240000-300 I2638366H345 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> 2005-11-11-15.57.43.461000-300 I2638713H394 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205744
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9F600 : 4700 0000 G...
>
> 2005-11-11-15.57.43.471000-300 I2639109H380 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205744
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
>
> --
> Pierre Saint-Jacques
> SES Consultants Inc.
> 514-737-4515


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 06:22 AM
mike_li
 
Posts: n/a
Default Re: Errors in DB2DIAG.LOG

Looks like the fault monitor daemon process is kicking.
you can disable fault monitor using: db2fmcu -d.
Then try to fix sqljcReceive problem.




Jacques wrote:
> DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022" with
> level identifier "03030106".
> Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086", and
> FixPak "9".
> Product is installed at "D:\SQLLIB".
>
> I'm getting the following in my db2diag.log - This appears every 4-5 minutes and is realy "polluting" my file and disk space.
> Any ideas????
>
> Thanks for the help, Pierre.
>
> 2005-11-11-15.57.43.220000-300 I2637227H394 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205743
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9E934 : 4700 0000 G...
>
> 2005-11-11-15.57.43.230000-300 I2637623H380 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205743
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> 2005-11-11-15.57.43.230000-300 I2638005H359 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9FB20 : 4700 0000 G...
>
> 2005-11-11-15.57.43.240000-300 I2638366H345 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> 2005-11-11-15.57.43.461000-300 I2638713H394 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205744
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9F600 : 4700 0000 G...
>
> 2005-11-11-15.57.43.471000-300 I2639109H380 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205744
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
>
> --
> Pierre Saint-Jacques
> SES Consultants Inc.
> 514-737-4515


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-27-2008, 06:22 AM
Serge Rielau
 
Posts: n/a
Default Re: Errors in DB2DIAG.LOG

Pierre Saint-Jacques wrote:
> DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022" with
> level identifier "03030106".
> Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086", and
> FixPak "9".
> Product is installed at "D:\SQLLIB".
>
> I'm getting the following in my db2diag.log - This appears every 4-5
> minutes and is realy "polluting" my file and disk space.
> Any ideas????
>
> Thanks for the help, Pierre.
>
> 2005-11-11-15.57.43.220000-300 I2637227H394 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205743
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9E934 : 4700 0000 G...
>
> 2005-11-11-15.57.43.230000-300 I2637623H380 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205743
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> 2005-11-11-15.57.43.230000-300 I2638005H359 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9FB20 : 4700 0000 G...
>
> 2005-11-11-15.57.43.240000-300 I2638366H345 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> 2005-11-11-15.57.43.461000-300 I2638713H394 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205744
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> MESSAGE : CCI Error:
> DATA #1 : Hexdump, 4 bytes
> 0x04A9F600 : 4700 0000 G...
>
> 2005-11-11-15.57.43.471000-300 I2639109H380 LEVEL: Info
> PID : 4324 TID : 1436 PROC : db2fmp.exe
> INSTANCE: SES NODE : 000
> APPID : *LOCAL.SES.051111205744
> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
> "No connection"
>
> --
> Pierre Saint-Jacques
> SES Consultants Inc.
> 514-737-4515

Are you running diag level 4? If so you got what you asked for ;-)
I agree that this must be some daemon (could also be the health monitor).

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-27-2008, 06:22 AM
Pierre Saint-Jacques
 
Posts: n/a
Default Re: Errors in DB2DIAG.LOG

Thanks all.
Yes, I was at level 4 and got more than I wanted.
Can't be fault monitor as I'm on an WinXP platform and I don't think it has
fault monitors.
I suspect it is as Serge says the Health Monitor.
No problem shows when I run at level 3.
Thnaks, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Serge Rielau" <srielau@ca.ibm.com> a écrit dans le message de news:
3tkskaFt9lpnU2@individual.net...
> Pierre Saint-Jacques wrote:
>> DB21085I Instance "SES" uses "32" bits and DB2 code release "SQL08022"
>> with
>> level identifier "03030106".
>> Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086",
>> and
>> FixPak "9".
>> Product is installed at "D:\SQLLIB".
>> I'm getting the following in my db2diag.log - This appears every 4-5
>> minutes and is realy "polluting" my file and disk space.
>> Any ideas????
>> Thanks for the help, Pierre.
>>
>> 2005-11-11-15.57.43.220000-300 I2637227H394 LEVEL: Info
>> PID : 4324 TID : 1436 PROC : db2fmp.exe
>> INSTANCE: SES NODE : 000
>> APPID : *LOCAL.SES.051111205743
>> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
>> MESSAGE : CCI Error:
>> DATA #1 : Hexdump, 4 bytes
>> 0x04A9E934 : 4700 0000 G...
>> 2005-11-11-15.57.43.230000-300 I2637623H380 LEVEL: Info
>> PID : 4324 TID : 1436 PROC : db2fmp.exe
>> INSTANCE: SES NODE : 000
>> APPID : *LOCAL.SES.051111205743
>> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
>> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
>> "No connection"
>> 2005-11-11-15.57.43.230000-300 I2638005H359 LEVEL: Info
>> PID : 4324 TID : 1436 PROC : db2fmp.exe
>> INSTANCE: SES NODE : 000
>> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
>> MESSAGE : CCI Error:
>> DATA #1 : Hexdump, 4 bytes
>> 0x04A9FB20 : 4700 0000 G...
>> 2005-11-11-15.57.43.240000-300 I2638366H345 LEVEL: Info
>> PID : 4324 TID : 1436 PROC : db2fmp.exe
>> INSTANCE: SES NODE : 000
>> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
>> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
>> "No connection"
>> 2005-11-11-15.57.43.461000-300 I2638713H394 LEVEL: Info
>> PID : 4324 TID : 1436 PROC : db2fmp.exe
>> INSTANCE: SES NODE : 000
>> APPID : *LOCAL.SES.051111205744
>> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
>> MESSAGE : CCI Error:
>> DATA #1 : Hexdump, 4 bytes
>> 0x04A9F600 : 4700 0000 G...
>> 2005-11-11-15.57.43.471000-300 I2639109H380 LEVEL: Info
>> PID : 4324 TID : 1436 PROC : db2fmp.exe
>> INSTANCE: SES NODE : 000
>> APPID : *LOCAL.SES.051111205744
>> FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
>> RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
>> "No connection"
>> --
>> Pierre Saint-Jacques
>> SES Consultants Inc.
>> 514-737-4515

> Are you running diag level 4? If so you got what you asked for ;-)
> I agree that this must be some daemon (could also be the health monitor).
>
> Cheers
> Serge
> --
> Serge Rielau
> DB2 SQL Compiler Development
> IBM Toronto Lab


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:45 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com