SELECT count(*) from SYSIBM.SYSTABLES WHERE CREATOR = 'OWNER' ;

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

Question Posted / s

2 Answers
4577 Views
I also Faced
E-Mail Answers

Answer Posted / s

SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is package in cobol db2?

904

What is image copy in db2?

789

What is a dbrm in db2?

795

List out the three types of page locks that can be held.

943

What is db2 command?

808

What is ibm db2 database?

763

What is lock escalation in db2?

812

What is database alias db2?

910

define clustering index.

835

What is db2 connect?

840

What is dbrm library?

822

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2319

What is isolation level in db2?

798

What is with ur in db2?

1067

What does a deadlock mean in DB2?

895