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 ?
This topic has been locked.
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.
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'"