MVSFORUMS.com

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

hi,

I need to know the number of lines in a table right before initiating my processing.

The problem is that the table is extremely large and contains more than 2 billion lines, in average.

If I issue a "select count(*)", it will take me precious 20 minutes or so to get it done (I have simulated it already...).

Is there a way (a SYSIBM control table maybe...) to obtain the actual number of lines of a given table without issuing a "select count(*)" on it?

thanks,
jc

kolusu · Posted: Sat Jul 28, 2007 9:54 am Post subject:

jctgf,

If your shop updates the table statistics then you can use the CARDF column in sysibm.systables which contains the total number rows in a table.

check this link for exaplanation of columns in sysibm.systables

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQJ12/F.74?DT=20050325102208

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

CICS Guy · Intermediate Joined: 30 Apr 2007 Posts: 292 Topics: 3

dbzTHEdinosauer · Posted: Sat Jul 28, 2007 12:22 pm Post subject:

jctgf,

I was just wondering, why do you need to know the row count?
_________________
Dick Brenholtz
American living in Varel, Germany

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

1. after runstats, you can query cardf from catalog table get the number when runstats running
2. if your site enable RTS, query sysibm.tablespacestats, you can get the number by partition level.

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

actually i need the number of records in every partition of the table (it's a partitioned table).

the best way would be querying sysibm.tablspacestats, ok?

thanks,
jc

dbzTHEdinosauer · Posted: Mon Aug 06, 2007 8:15 am Post subject:

jctgf,

I was just wondering, why do you need to know the row count?
_________________
Dick Brenholtz
American living in Varel, Germany

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

it's a partitioned table and i want to place the record in the partition where there is free space
by knowing the number of records in each partition i may assign the correct value to my partition# column (my clustered column)
regards

dbzTHEdinosauer · Posted: Tue Aug 07, 2007 1:32 am Post subject:

jctgf,
thx for getting back.
_________________
Dick Brenholtz
American living in Varel, Germany

dbzTHEdinosauer · Posted: Tue Aug 07, 2007 4:14 am Post subject:

jctgf,
is this a batch or on-line application?

if on-line, what kind of insert volume do you have?
if on-line, does it run 24/7?
_________________
Dick Brenholtz
American living in Varel, Germany

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

dbzTHEdinosauer · Posted: Tue Aug 07, 2007 11:09 pm Post subject:

jctgf,
thx for the info and good luck. sounds like a very intensive (and stressful) process.
_________________
Dick Brenholtz
American living in Varel, Germany

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

recommendation:
Set up your system enable Real-Time Statistics.
Then you can query SYSIBM.TABLESPACESTATS to get the current row# of each partition