Count database objects ??

DBFinder · #1 (**permalink**) 10-13-11, 11:38

Hey friends : How do we count all database objects ??

please help with query if possible .

Regards
DBFinder

ARWinner · #2 (**permalink**) 10-13-11, 11:56

Can you be a little more specific what you want?

Andy

DBFinder · #3 (**permalink**) 10-13-11, 12:04

I want to keep the count of all user database objects count for keeping an eye on new objects in an OLTP database.

If the count increases, my DBA will look immediately and act if an action is needed. Operational DBA is some times bypassed by higher authority DBA team members. This watch will just let DBA know that something new has entered the database.

Reagrds

ARWinner · #4 (**permalink**) 10-13-11, 12:43

Are you talking about Tables, Views, Triggers, Stored Procedures, etc?

Then something like:

Code:

 select tabschema,count(*) from syscat.tables group by tabschema

should work.

Andy

DBFinder · #5 (**permalink**) 10-13-11, 19:07

Actually I was expecting whole list of DB object types so that I can add up for total count of user database objects.

eg
1. Tables
2. Views
3. Triggers
4. Functions
5. Procedures
6. Sequences
7. . . . . . . ..
8. . . . . . . .
9. . . . . . . .

Can some one help complete the list so that I do not miss even one of all ??

Regards
DBFinder

Marcus_A · #6 (**permalink**) 10-13-11, 20:10

The DB2 catalog tables are described in the Appendix of the SQL Reference Vol 1. You will have to look at the layouts since (for example) syscat.tables includes tables and views, even though syscat.views includes the view information. See the TYPE column of syscat.tables for more info.

DBFinder · #7 (**permalink**) 10-13-11, 20:33

Thanks Marcus,

It is Appendix D in v8 manual. I will do my home work now.

Regards
DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech