IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

taking the count


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Sun Jun 21, 2009 1:45 am
Reply with quote

hi,

We are having db2 database with z/os.
After LOAD/UNLOAD of data we need to create a report in which we provide the count of all the tables present in our db2 subsystem.
we follow the policy of having 1 database>>1 tablespace>>1 table.

At present we create the report of taking count through rexx but it usually takes more time. Do we have some SQL query through which we can get the count of all the tables in one shot?

kindly guide me and correct me if i am wrong.
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 459
Location: Belgium

PostPosted: Sun Jun 21, 2009 1:51 am
Reply with quote

SYSIBM.SYSTABLES but work with generic select criteria.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
No new posts Insert header record with record coun... DFSORT/ICETOOL 14
No new posts Count the number of characters in a f... CA Products 1
Search our Forums:

Back to Top