Messages

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 / Re: Unable to delete application group

« on: September 27, 2017, 01:22:13 AM »

Hello all,

Thanks for all the answers to my question. Especially to jsquizz's workaround.

With this steps I managed to get rid of the orphaned ApplicationGroup:
- Update the "Storage Set" of the orphaned ApplicationGroup (which we eventually want to delete as well, cause we have no use for this anymore)
  -- Add a new "Cache Only"-"Storage Node"
  -- Delete the TSM "Storage Node" pointing to the non-existing TSM node
  -- Update the "Cache Only"-"Storage Node" => Check the "Load Data" flag
  Now it is possible to save the manipulated "Storage Set"
- Delete the orphaned ApplicationGroup (works now without errors)
- Delete the "Storage Set" of the orphaned ApplicationGroup
Done.

Best Regards
Valentin

3

MP Server / Re: Unable to delete application group

« on: September 18, 2017, 02:50:40 AM »

I just stumble upon the same issue, while deleting an ApplicationGroup.
From the admin client I receive the error: "The server failed while accessing application group data. Contact your system administrator."
(See also: http://www-01.ibm.com/support/docview.wss?uid=swg21272955)

Unfortunatelly the whole TSM node containing the documents of this ApplicationGroup was already deleted some time ago.

Is there a way to delete such orphaned ApplicationGroups without recreating the TSM node?
E.g. by manipulating ARSAG.SID ?

4

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.

5

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

6

General / Re: CMOD -HCP Integration

« on: January 30, 2017, 01:13:49 AM »

Hello all,

Just to be sure.
If we want to use NetApp SnapLock WORM, we have to use a TSM/SSAM Layer between NetApp and CMOD?

Regards
Valentin