What means this db2diag.log?

Frank Hauptlorenz wrote:[color=blue]
> 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 Appid:84B43C19.0E04.031210070405
> sort/list_services sqlsSpillASORT Probe:10 Database:STORCH
>
> ibuff
> 3090 5b0f 0100 0000 0900 0000 0090 0000 0.[..... .......
> c203 0000 0000 0000 4887 0000 0000 0000 Â.......H?......
> 0000 0000 5417 5c0f 8caf 5b0f ....T.\.O¯[.
>
>
> 2003-12-10-09.49.33.421000 Instance:DB2 Node:000
> PID:812(db2syscs.exe) TID:772 Appid:84B43C19.0E04.031210070405
> sort/list_services sqlsSpillASORT Probe:15 Database:STORCH
>
> recptr
> 8caf 5b0f O¯[.
>
>
> This is a DB 2 V7.2 Fix 10 on Win 2000.
>
> Thank you,
> Frank[/color]

Hi Frank,

This message is harmless and probably showed up because a temp
tablespace filled up during a sort spill. You should not see these
messages anymore with FP11 except in a severe error scenario.

Lee

Frank Hauptlorenz wrote:[color=blue]
> 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 Appid:84B43C19.0E04.031210070405
> sort/list_services sqlsSpillASORT Probe:10 Database:STORCH
>
> ibuff
> 3090 5b0f 0100 0000 0900 0000 0090 0000 0.[..... .......
> c203 0000 0000 0000 4887 0000 0000 0000 Â.......H?......
> 0000 0000 5417 5c0f 8caf 5b0f ....T.\.O¯[.
>
>
> 2003-12-10-09.49.33.421000 Instance:DB2 Node:000
> PID:812(db2syscs.exe) TID:772 Appid:84B43C19.0E04.031210070405
> sort/list_services sqlsSpillASORT Probe:15 Database:STORCH
>
> recptr
> 8caf 5b0f O¯[.
>
>
> This is a DB 2 V7.2 Fix 10 on Win 2000.
>
> Thank you,
> Frank[/color]

Hi Frank,

This message is harmless and probably showed up because a temp
tablespace filled up during a sort spill. You should not see these
messages anymore with FP11 except in a severe error scenario.

Lee

Okay, thank you.
Perhaps you should write in every message
if its harmless or not...

Grüße
Frank

"Lee Chu" <me@me.com> schrieb im Newsbeitrag
news:brnbee$4mq$1@hanover.torolab.ibm.com...[color=blue]
> Frank Hauptlorenz wrote:[color=green]
> > 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 Appid:84B43C19.0E04.031210070405
> > sort/list_services sqlsSpillASORT Probe:10 Database:STORCH
> >
> > ibuff
> > 3090 5b0f 0100 0000 0900 0000 0090 0000 0.[..... .......
> > c203 0000 0000 0000 4887 0000 0000 0000 Â.......H?......
> > 0000 0000 5417 5c0f 8caf 5b0f ....T.\.O¯[.
> >
> >
> > 2003-12-10-09.49.33.421000 Instance:DB2 Node:000
> > PID:812(db2syscs.exe) TID:772 Appid:84B43C19.0E04.031210070405
> > sort/list_services sqlsSpillASORT Probe:15 Database:STORCH
> >
> > recptr
> > 8caf 5b0f O¯[.
> >
> >
> > This is a DB 2 V7.2 Fix 10 on Win 2000.
> >
> > Thank you,
> > Frank[/color]
>
> Hi Frank,
>
> This message is harmless and probably showed up because a temp
> tablespace filled up during a sort spill. You should not see these
> messages anymore with FP11 except in a severe error scenario.
>
> Lee
>[/color]

"Frank Hauptlorenz" <fhauptlorenz@nospam.de> wrote in message
news:brot14$au2$02$1@news.t-online.com...[color=blue]
> Okay, thank you.
> Perhaps you should write in every message
> if its harmless or not...
>
> Grüße
> Frank
>[/color]
It may not be "totally" harmless. It may be an indication of a tempspace
that is too small.

Hm, there is only a system managed temp tablespace on drive e:
and there are 31,5 GB free. Database size (Backup Image) is 2,6 GB.

Grüße,
Frank

"Mark A" <ma@switchboard.net> schrieb im Newsbeitrag
news:UUSDb.155$ya7.86464@news.uswest.net...[color=blue]
> "Frank Hauptlorenz" <fhauptlorenz@nospam.de> wrote in message
> news:brot14$au2$02$1@news.t-online.com...[color=green]
> > Okay, thank you.
> > Perhaps you should write in every message
> > if its harmless or not...
> >
> > Grüße
> > Frank
> >[/color]
> It may not be "totally" harmless. It may be an indication of a tempspace
> that is too small.
>
>[/color]