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]

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

Type 128 is a temporary table.

"Jeff" <jbapplewhite@a ep.com> wrote in message
news:15ffd666.0 401300910.1ffb4 720@posting.goo gle.com...[color=blue]
> 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.[/color]