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-18.104.22.1686002
ACLS_2 XMETA T 2012-10-21-22.214.171.1246002
AGENT_XMETAGEN_AGENT5874305 XMETA T 2012-10-21-126.96.36.1997003
AGENT_XMETAGEN_HANDLERTYPE5874> XMETA T 2012-10-21-188.8.131.527005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-184.108.40.2067001
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-220.127.116.117005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-18.104.22.1687001
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'"