INLINE_LENGTH column changed after upgrade

bayard0

Newcomer
Joined
Nov 22, 2011
Messages
4
Reaction score
0
Points
0
Hello,
we just did an upgrade of our TSM from 6.2.2 to 6.2.3.

this changed the length of columns from what they were set to previously
example: TSM>select colname, length from syscat.columns where tabschema='TSMDB1' and tabname='LIBVOLUMES'COLNAME: LIBRARY_NAME
LENGTH: 31
COLNAME: MEDIATYPE
LENGTH: 64
COLNAME: OWNER
LENGTH: 64
COLNAME: STATUS
LENGTH: 16
COLNAME: VOLUME_NAME
LENGTH: 65

If you see the column name: status & volume_name both lenghts combined are 81 (16+65), so when I run a simple command like: select volume_name, status from libvolumes where status='Scratch' it turncates it from a table to a list.

Before the update it would display the results in a table format with rows/columns, now it displays it as a list.

Example: TSM>select volume_name, status from libvolumes where status='Scratch'
VOLUME_NAME: PTY210L2
STATUS: Scratch
VOLUME_NAME: PTY211L2
STATUS: Scratch



I know there is a fix that requires me to change my query found here: http://www-01.ibm.com/support/docview.wss?uid=swg21502715&myns=swgtiv&mynp=OCSSGSG7&mync=R

But I am wondering if there is a way of changing the length of the colums in the DB2?
 
Back
Top