DB2 How To get View definition

Question: Given a view name , how can you get the definition of a View in DB2? Answer: Query the SYSCAT.VIEWS and return the TEXT column. An alternative is to use the db2look utility Syntax using SYSCAT.VIEWS SELECT TEXT FROM SYSCAT.VIEWS WHERE VIEWNAME = 'myview' and viewschema = 'myschema' Method 2 using db2look Db2look –d mydatabase -t myView Read More Create a DDL on an existing DB2 table Deciding to reorg DB2 tables with overflow value Commands to check for read only Linux file system SQL Parser Compare DDL of 2 databases in DB2 Linux top greater than 100 percent... Read more →

How to Troubleshoot - SQL1226N due to many db2agent processes attached to the instance

Question: On a DB2 LUW 9.7 instance , I’m getting these error messages. What commands can I use to investigate and troubleshoot SQL1226N due to many db2agent processes attached to the instance? I’ve read the post ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225" , but require some method to extract db2agent information and work with application owners. SQL1226N due to many db2agent processes attached to the instance ADM7009E An error was encountered in the "TCPIP" protocol support. A possible cause is that the maximum number of agents has been exceeded. Answer: It is sometimes difficult to... Read more →