reorgchk with display full tablename

[Albert Baumann]

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

[richard]

Albert Baumann <A.*******@t-online.de> wrote in message news:<co*************@news.t-online.com>...

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

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%'

[dotyet]

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

hth,
dotyet

sh*******@gmail.com (richard) wrote in message news:<ca**************************@posting.google. com>...

Albert Baumann <A.*******@t-online.de> wrote in message news:<co*************@news.t-online.com>...

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

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%'