I am executing a list table command on XMETA DB and got the result like this...
*bold*db2 list tables for schema XMETA | head*bold*
Table/View Schema Type Creation time
ACLENTRIES_2 XMETA T 2012-10-21-220.127.116.116002
ACLS_2 XMETA T 2012-10-21-18.104.22.1686002
AGENT_XMETAGEN_AGENT5874305 XMETA T 2012-10-21-22.214.171.1247003
AGENT_XMETAGEN_HANDLERTYPE5874> XMETA T 2012-10-21-126.96.36.1997005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-188.8.131.527001
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-184.108.40.2067005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-220.127.116.117001
here as u can see here, I am not able see the whole table name.
Is there another way by which I can increase the column size ?
Pinned topic Not able to see thw whole column in db2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-22T13:01:17Z at 2012-11-22T13:01:17Z by SystemAdmin
SystemAdmin 110000D4XK17917 Posts
Re: Not able to see thw whole column in db22012-11-22T13:01:17ZThis is the accepted answer. This is the accepted answer.Hello Atul,
Just query the catalog view SYSCAT.TABLES :
db2 "select TABNAME, TABSCHEMA, TYPE, CREATE_TIME from SYSCAT.TABLES where TABSCHEMA='XMETA'"