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?
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?