how to know how many tables i created in the database

[narayana]

how to know about how many tables i created in that database.if the
database is connected to many users.

i want the query in this way that i want creater,number of
tables,time,updates .

the last two columns not required i need the number of tables i created
in that table

[Pierre Saint-Jacques]

Connect to your DB.
Short way: db2 list tables for USER
db2 list tables for schema <schemaname>
Or:
select tabschema,tabname,definer,create_time from syscat.tables where
tabschema=USER

Updates are not kept in those catalog tables. You'd have to creatr an event
monitor or take regular snapshot to get those numbers.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"narayana" <va***********@gmail.com> a écrit dans le message de news:
11**********************@g49g2000cwa.googlegroups. com...

how to know about how many tables i created in that database.if the
database is connected to many users.

i want the query in this way that i want creater,number of
tables,time,updates .

the last two columns not required i need the number of tables i created
in that table