Unable to get the total number of docs in a MAXDB 7.6 database SAP repository

[former_member204787]

Dear DMS experts,

I need to know how many documents are inside of a MAX DB datase 7.6. Is there any command  that indicates the number of different documents stored in Content server .

Thanks,

Chandu

[Former Member]

Hi Chandu,

You can directly see the number of docs with the information "corrupted or not" by using report DMS_KPRO_CHECK1 from SE38..

Run the report  DMS_KPRO_CHECK1

Select your content repository; like "DMS_C1" ( of course yours is different"

RFC Destination: SAPHTTPA

You will see your LOIOS in KPRO referenece to DMS and also LOIOS in DMS reference to KPRO etc..

Regards

Ömür

[former_member188883]

Hi Chandu,

Use Tcode Se38

Type the Program name DMS_KPRO_CHECK1 .

Fill in the following input parameters

Content Repository = <Name of your content repository>

RFC Destination = SAPHTTPA

Select checkbox Checking KPRO - DMS

Then execute.

Hope this helps.

Regards,

Deepak Kori

[former_member204787]

Dear Deepak kori,

I am looking to know maximum file size and total number of file loaded into MAXDB. For this any third party tools need to instal .  We are working on Windows server 2008 R2. let me know

As per above post  i found that below particulars.

  LOIOS in KPRO w/o Reference to DMS  

  Number of LOIOS: 37

LOIOS in DMS w/o Reference to KPR

Number of LOIOS: 0

Let me know what is LOIOS ??   

Thanks,

chandu

[Former Member]

Hi,

on db level you can count the number of rows in the tables where the documents are stored.

For each repository you have on COMPONENTS<nr> table. The <nr> repository number

ist stored togehter with the repository name in the table CONTREP

Use sqlcli, Database Studio or SQL Studio count the numer of rows on database level.

>sqlcli -d CS -u SAPR3,*** select TABLENAME from tables where tablename LIKE 'COMPONENTS____'

| TABLENAME             |
| -------------------------------- |
| COMPONENTS0001   |

| COMPONENTS0002   |

2 row selected (24.619 msec)

>sqlcli -d CS -u SAPR3,*** select count(*) from COMPONENTS0001
| EXPRESSION1       |
| ----------------------------- |
|                         101 |

1 row selected (12.559 msec)

In repository 1 101 documents are stored. Do this for all other COMPONENTS<nr> tables

If you are a SAP Customer please check also SAP Note No. 1678771

Best reagrds,

Burkhard

[former_member204787]

Dear Burkhard,

Thanks for your support,

Based on table rows we can analyse how much of  data stored in the MAXDB.  up to this fine my intention is to know  who are attached file and how much of size file uploaded from database level or OS level. There is any option in IIS services to identify maximum size of file stored .

Every thing funtioning  fine.

Thanks,

chandu

[Former Member]

Hello chandu,

on IIS level I could not help you and I am not sure that I have undestood your question

On database level you get the maximum size of all stored documents in your repositories.

select sum(treeleavessize)+sum(lobsize)

from tables t, files f

where tablename like 'COMPONENTS____'

and (tableid = fileid or tableid = primaryfileid)

This query returns the length over all repositories using the like expression.

The retuned value is in 1k byte.

It accumulates the length stored in treeleavessize (SHORT COLUMNS) and lobsize (LOB FILES)

Since not all documents are stored in LOB files.

Kind regards,

Burkhard