UNIX UDB V 7 - In db2diag.log interpreting Obj={pool:1;obj:2;type:128}

[Jeff]

On occasions we have failures and in the db2diag.log this is in the
log identifying the failure. Please let me know if I have this right.

Obj={pool:1;obj:2;type:128}

pool is the tablespace id
obj is the is object id
type is the object

I do believe a type of 0 is a data object, 1 is an index object, 2 is
a long object. But I have no idea what a type 128 is. Can someone
inform me and also point me to where I can find all the object type
codes.

[Fred Nurk]

Type 128 is a temporary table.

"Jeff" <jb**********@aep.com> wrote in message
news:15**************************@posting.google.c om...

On occasions we have failures and in the db2diag.log this is in the
log identifying the failure. Please let me know if I have this right.

Obj={pool:1;obj:2;type:128}

pool is the tablespace id
obj is the is object id
type is the object

I do believe a type of 0 is a data object, 1 is an index object, 2 is
a long object. But I have no idea what a type 128 is. Can someone
inform me and also point me to where I can find all the object type
codes.