Is there an easy way to count number of records in the clustered CDPOS table without getting dump?

[Former Member]

Hello gurus

I appreciate if you can chime in. So far all attempts from se11 se16 ended up with dumps when trying to get the number of records for CDPOS table.

Regards

Tansu

[cristiandaniel_bernardi]

Hi, you can run tcode TAANA and run a CDPOS table analysis or use tcode DB02 single table analysis.

[former_member229916]

Use a custom sql with Open Cursor with Package size. Keep adding sy-dbcnt in the Fetch loop. At the end of loop it will give you the count of rows. Since cdpos is a cluster table it cannot be processed using database tools.

[cris_hansen]

Hi Tansu,

Have you tried report nrows?

Regards,

Cris

[former_member188883]

Hi Tansu,

If you are only interested in getting the count of records then run sql query on database level.

Regards,

Deepak Kori

[yakcinar]

Hello Tansu,

Using DBACOCKPIT --> Space --> Singe Table Analysis

Or

Using SQL Command Editor from DBACOCKPIT tx and running  "select count(*) CDPOS" may help.

Regards,

Yuksel AKCINAR