Topics

1

MP Server / count(*) of the segment tables not in sync with ins_rows-del_rows

« on: November 28, 2017, 08:46:14 AM »

Hello all,

After a migration, we did a quantity-check of the inserted amount of documents in a ApplicationGroup.
There were discrepancies.
Then we did a deeper look into it and realized, that the "ins_rows-del_rows" values in the ARSSEG tables are not always correct.

Code: [Select]

$ db2 "select arsseg.table_name,arsseg.ins_rows,arsseg.del_rows,arsseg.ins_rows-arsseg.del_rows as Total_Rows from arsag,arsseg where arsag.agid=arsseg.agid and arsag.name='myApplGrp'"

TABLE_NAME         INS_ROWS             DEL_ROWS             TOTAL_ROWS         
------------------ -------------------- -------------------- --------------------
LBA1                            5422800                60000              5362800

  1 record(s) selected.

but

Code: [Select]

$ db2 "select count(*) as cnt from LBA1"

CNT       
-----------
    5423418

  1 record(s) selected.

How could this happen?
Is there a way to fix the ins_rows and del_rows columns?

Best Regards
Valentin

2

MP Server / How many Documents are stored in CMOD Application Group grouped by Application

« on: March 27, 2017, 07:58:21 AM »

Hello all,

With this SQL query it is possible to receive the number of documents per Application Group:
db2 "select arsag.name,sum(arsseg.ins_rows-arsseg.del_rows) as Total_Rows from arsag,arsseg where arsag.agid=arsseg.agid group by arsag.name"

Is there a way to receive the number of documents per Application?
(e.g. how many PDFs and how many AFPs are stored in given Application Group)

If yes, is there also a possibility to receive the required space (storage object size) per Application?

Thanks for your replies.

3

MP Server / Specifying the codepage (or charset) of the command line arguments of arsdoc

« on: March 07, 2017, 02:24:47 AM »

Is there a way to specify the codepage (or charset) of the command line arguments of arsdoc?

Example:
arsdoc  update -h myHost -u myUser -p myUser.stash -g myAG -f myFolder -v -i "where myDocid=12345678" -n myDescription='updated déscriptìón cöntäining spécial chärs'

In my environment, this only works correct, if the text in myDescription is in latin1.
Is there a way to say, that the value-string of myDescription is UTF-8 (codepage 1209)?

Thanks
Valentin