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

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" <vagu.narayana@gmail.com> a écrit dans le message de news:
1131732667.131444.152810@g49g2000cwa.googlegroups. com...[color=blue]
> 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
>[/color]