I need to view the number of tables existing und

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

I need to view the number of tables existing under one particular OWNER. ?

Q: I need to view the number of tables existing under one particular OWNER. Is it possible ? If so, please give the SQL query for this ?

An:
DB2 records information for its operation in a catalog which is actually a group of tables. So we can use the SYSTABLES to get answer to our query.

(Continued on next question...)

Other Job Interview Questions

• Name some of field from SQLCA?
• MAX number of columns in a DB2 table
• What will the DB2 optimizer do?
• How would one remove old reorg information from the DB2 catalog?
• What is meant by AUTO COMMIT
• How would you move a tablespace to a different DASD volume allocated to that tablespace?
• What is a correlated sub query?
• What is DCLGEN?
• When will you chose to run RUNSTATS?
• What does the CHECK Utility do?
• More...