Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - SV

Pages: [1] 2
1
z/OS Server / Z/OS To Multiplatform CMOD migration - ARSADMIN VS ARSDOC Getdoc
« on: February 02, 2021, 09:35:17 AM »
Hello Migrating from CMOD Z/OS to Multiplatform.
Plan is to extract documents (AFP) and load to target CMOD.

Has any one done comparison of "arsadmin retrieve" vs "arsdoc getdoc" by Loadid. I would like to know which one is MIPS (Z/OS  CPU) efficient and other performance and time consideration.

Current CMOD Z/OS 10.1 with multiple years of documents archived to OAM managed DASD and after x number of years migrated to OAM managed TAPE.

Any feed back is appreciated.

2
MP Server / ArcDBP_SegSQL:Unable to exec direct sql db
« on: December 06, 2019, 11:00:57 AM »
AIX CMOD stooped. Not starting. Trace shows these db errors. SQL ERROR code is not showing up in the log


39518276:258 12/06/2019 10:39:25:195243 ERROR arsseg.c(1132)ArcDBP_SegSQL:Unable to exec direct sql db hstmt=65538 db sql str=CREATE TABLE ccsuser.SL1685 ( time_stamp INTEGER NOT NULL, userid VARCHAR(128) NOT NULL, severity CHAR(1) NOT NULL, msg_num SMALLINT NOT NULL, msg_text VARCHAR(2000) NOT NULL, appl_id CHAR(1) NOT NULL, log_id INTEGER NOT NULL, account VARCHAR(60) NOT NULL, doc_name VARCHAR(11) NOT NULL, doc_off INTEGER NOT NULL, doc_len INTEGER NOT NULL, comp_off INTEGER NOT NULL, comp_len INTEGER NOT NULL, annot CHAR(1) FOR BIT DATA NOT NULL, comp_type CHAR(1) FOR BIT DATA NOT NULL, resource INTEGER NOT NULL, pri_nid SMALLINT NOT NULL, sec_nid SMALLINT NOT NULL , time_stamp_dt TIMESTAMP NOT NULL) IN USERSPACE1 sql=CREATE TABLE ccsuser.SL1685 ( time_stamp INTEGER NOT NULL, userid VARCHAR(128) NOT NULL, severity CHAR(1) NOT NULL, msg_num SMALLINT NOT NULL, msg_text VARCHAR(2000) NOT NULL, appl_id CHAR(1) NOT NULL, log_id INTEGER NOT NULL, account VARCHAR(60) NOT NULL, doc_name VARCHAR(11) NOT NULL, doc_off INTEGER NOT NULL, doc_len INTEGER NOT NULL, comp_off INTEGER NOT NULL, comp_len INTEGER NOT NULL, annot CHAR(1) FOR BIT DATA NOT NULL, comp_type CHAR(1) FOR BIT DATA NOT NULL, resource INTEGER NOT NULL, pri_nid SMALLINT NOT NULL, sec_nid SMALLINT NOT NULL , time_stamp_dt TIMESTAMP NOT NULL) IN USERSPACE1 db sql rc=-1,SQL_ERROR


I executed this sql in the above error and got this error
SQL0289N  Unable to allocate new pages in table space "USERSPACE1". 
SQLSTATE=57011

3
Windows Client / Admin client 9502 - Adding new user fails
« on: May 23, 2019, 11:53:53 AM »
question: CMOD Window Admin client 9.5.0.2 , while adding a new user fails with a popup window that indicates UserID "xx##### or UID "1018" already exists. There are no System Log.  I can see another user having the same uid.

4
MP Server / Implied Hold vs HOLD -Any drawback?
« on: February 27, 2018, 10:52:43 AM »
Has a requirement to apply hold for all documents and release at document level when certain event happens. Also, reload should happen when certain percentage of docs are out of hold and met the retention.

I thought I can use implied_hold to add a default hold during load. But IBM document says (pasted below), use implied hold if you are using another solution for retention management.

-What is best approach for my requirement.
- Any disadvantage of using implied-hold.
- If implied hold is used, will it cause any CMOD functionality like reload to stop.
- Also when I used Implied-Hold, hold field displays a value of 16384.

Holds
You indicate, through the use of searches, the specific documents that you want to hold. You can apply holds to documents in any application group. Use this type of hold if you are using Content Manager OnDemand as your retention management tool.

Implied holds
When Content Manager OnDemand loads documents, it applies a hold to all the documents in that load. You can apply this type of hold only to documents in new application groups. Use this type of hold if you are using another solution as your retention management tool.

5
MP Server / DB Password Encryption
« on: November 17, 2017, 10:06:58 AM »
 is DB password encrypted in transit while CMOD (9.5 or 10.1)  is  connecting to a remote oracle DB. I know the password is stored encrypted in stash file.

6
MP Server / Password and DB connection security
« on: October 05, 2017, 09:12:11 AM »
I have general questions around security

CMOD   version > 9.0

Is password encrypted
  -  from OnDemand Desktop thick client to CMOD?
  -  From ODWEK to CMOD?

Is DB connection from CMOD secured? Does CMOD encrypt pw to DB?

7
MP Server / ICOS as storage manager - ARS0452E return code 6
« on: September 11, 2017, 02:05:56 PM »
Hello,
Trying a proof of concept using ICOS as storage manager CMOD 10.1.0.1 on Linux X86.

The arsload  fails with ARS0452E with return code 6.

Has any one tried ICOS as storage manager and was it successful?



8
Documentation / How is resource expiration handled?
« on: December 09, 2016, 10:46:13 AM »
Has any one seen documentation on how the resource expiration is done in CMOD.
 

9
MP Server / arsadmin command fails with systax error
« on: August 26, 2016, 04:38:37 PM »
CMOD V9.5
Windows 2012

Running the arsadmin fails with syntax error; Any fix. I referred V9.5 administrator guide for the syntax I do not see an issue.

"d:\Program Files\IBM\OnDemand\V9.5\bin\arsadmin" unload -h arsins1 -g test1   -L 5036-1-0-1FAA-20161017000000-20161017000000-5043 -u admin -p arsins.stash

10
MP Server / ARS0015E - While using remote oracle
« on: August 13, 2016, 11:30:45 PM »
RHEL       CMOD 9.5    DB -  remote oracle 11g

arsload fails:

Note:
 1) As per Alassandro's, suggestion in earlier post, left the ars.dbfs empty for using remote oracle.
 2) Permissions granted for the oracle DB schema (id) are as defined in this link except for TABLESPACE create and drop. http://www-01.ibm.com/support/docview.wss?uid=swg21571134

from system log :
ARS0015E  Unable to find SMS tablespace filesystems.  Either the defined SMS filesystems are full or there are no SMS filesystems defined.

arsload trace errors:
17728:140080102217504 08/14/2016 02:10:56:152994 ERROR arsload.c(6144)ArcLOADP_LoadDB:Current state msg_id=464
17728:140080102217504 08/14/2016 02:10:56:153014 ERROR arsload.c(6151)ArcLOADP_LoadDB:Current state msg_id=511
17728:140080102217504 08/14/2016 02:10:56:153124 ERROR arsload.c(10850)ArcLOADP_LoadArchive:Current state msg_id=1110
17728:140080102217504 08/14/2016 02:10:56:160606 ERROR arsload.c(15986)ArcLOAD_ProcessFile:Current state msg_id=1117
17728:140080102217504 08/14/2016 02:10:56:176486 ERROR (null)(0)(null):Sending message to library server msg timestamp=2016-08-14 02:10:56.160742 msg userid=ADMIN msg severity=2 msg num=88 msg text=ARS0088E Application Group Failed Load: Name(ITEST) LoadId(5016-1-0-4FAA-20161031000000-20161031000000-5017) File(/tmp/input/sample) msg appl=T msg logid=1538490249
17728:140080102217504 08/14/2016 02:10:56:176513 ERROR (null)(0)(null):CONSOLE message msg num=88
17728:140080102217504 08/14/2016 02:10:56:176532 ERROR (null)(0)(null):ARSLOG message msg num=88
17728:140080102217504 08/14/2016 02:10:56:179396 ERROR arsloadc.c(4476)ArcLOADC_Main:Current state msg_id=1126

11
MP Server / CMOD On Linux - Implmnenting HA with VERITAS cluster
« on: July 26, 2016, 10:43:36 AM »
I am asked to implement CMOD 9.5 on Linux where HA using VERITS cluster.  I am wondering if this is possible. Any suggestion.

1)   Availability of VCS HA agent for CMOD ? Standard or IBM customized available (for service start, stop, monitor& clean  )
2)   Recommended procedure for integration ( Filesystem layout, Disklayout, User details, Any additional IP requirement , Dependencies)
3)   Any best practices

12
MP Server / CMOD 9.5 on RHEL with remote Oracle
« on: July 14, 2016, 10:39:59 AM »
I have a new requirement to setup CMOD 9.5 on RHEL with remote ORACLE.

1)  I see the parameter ARS_ORACLE_HOIME what would be the value while having remote Oracle? Do I need to install any ORACLE component (Oracle server binary or Oracle client)  on the CMOD Library server?

3) Is it necessary to keep the CMOD instance owner id and the Oracle database owner id the same?

2) Can some one share  all the CMOD configuration parameters that need to be taken care, and what values are assigned to them.


3) Is tablespace creation user exit required with Oracle on remote server?
    With IBM documentation it seems we may not need it if we use default oracle tables space.

3) Is table space creation is a onetime requirement that I can have ORACLE DBA to create when configuring the oracle database?

4) If a tablespace user exit is required can some one share working sample.

13
MP Server / CMOD commands - How to capture return code
« on: July 13, 2016, 07:51:44 AM »
My client is planning to use VBScripts on windows to automate PDF indexer and arsload. They would like to know CMOD utilities like arspdoci, arsload returns any RC code upon completion. How to capture them with out scanning indexer or load command output message.

14
MP Server / arsdoc query on System log retruns timestamp without fraction of seconds
« on: July 12, 2016, 02:45:46 PM »
CMOD 9.0 on AIX - System log updated to new date format. Now the issue is "arsdoc query" on system log is not returning the timestamp in new date/time format.

When using windows client system log query returns the new date/time format as shown below: 

2016-07-04 06:39:49.422006   SECURE   100553   Info   Yes       34   User Add: Userid(USER1) Id(126)

Whereas "arsdoc query" returns timestamp as shown below. Is there anything missed, how do I get the query result to return new date/time style?

07/04/16 06:39:49,SECURE,4,34,User Add: Userid(NWUSER1) Id(126),T,100553,

15
z/OS Server / What is the best way to change retetion for Appgrp on OAM storage set
« on: July 08, 2015, 08:07:36 AM »
Working on retention change ( say 2 year to 3 year ) for an AppGrp that is on an OAM storage set. Found out there are more AppGrps on the same OAM storage set, which does not need retention change. What is the best way to change the retention for this 1 APpgrp?

200 MM Docs are on the Ap0Ggrp that require retention change. CMOD 9.0 on Z.OS. OAM is using DASD.

Pages: [1] 2