reorgchk with display full tablename

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Albert Baumann - 25 Nov 2004 18:47 GMT

Hello,

When running the db2 reorchk command, I receive the following Table Name...

BB FLASH_ORDER_LINE_> 157 0 3 4 11304 0 93 75 --*

Is there anyway to display the full Table Name????

Thanks in advance....

Albert

Reply to this Message

richard - 26 Nov 2004 16:46 GMT

> Hello,
>
[quoted text clipped - 7 lines]
>
> Albert

Table name is limitation of 18 chars in older version of DB2.
BB is the schema, FLASH_ORDER_LINE_* will be the table name
To find the table name
db2 select tabname from syscat.tables where tabschema='BB' and tabname
like 'FLASH_ORDER_LINE%'

Reply to this Message

dotyet - 29 Nov 2004 22:12 GMT

i think even today, it's capable of displaying only 30 characters of
the table name.

hth,
dotyet

> > Hello,
> >
[quoted text clipped - 13 lines]
> db2 select tabname from syscat.tables where tabschema='BB' and tabname
> like 'FLASH_ORDER_LINE%'

Reply to this Message