Messages

436

MP Server / Re: connecting to new remote SQL server

« on: October 17, 2017, 10:08:26 AM »

I've only done one implementation on the windows platform a few years back, and I am 99% sure that was the backdoor way of doing it. Not sure if that would be supported tho.

437

MP Server / Re: connecting to new remote SQL server

« on: October 17, 2017, 09:34:44 AM »

registry?

438

MP Server / Re: 17A4 Compliance

« on: October 17, 2017, 05:13:39 AM »

Thanks Justin. Scoping out a new environment with the latest and greatest.

Looks like TSM is our best way to go.

439

MP Server / Re: 17A4 Compliance

« on: October 16, 2017, 11:34:07 AM »

What would be a sample scenario involving 17A4 compliance.

440

MP Server / 17A4 Compliance

« on: October 16, 2017, 10:43:08 AM »

Just wondering if anyone on here is using storage that is 17A4 compliant with CMOD, V10.1 of course.

441

MP Server / Re: File name from 127 Records

« on: October 16, 2017, 09:45:06 AM »

Thanks Nolan.

WHY MUST IT ALWAYS BE SOMETHING SO SIMPLE.

 

442

MP Server / File name from 127 Records

« on: October 16, 2017, 06:30:09 AM »

Greetings all,

Got a request last week. Simple one, but I think my syntax is off here.

I need to match up file names that were unloaded, VIA 127 records..With file names that were loaded with the associated load ID via 87 records. I was able to get all my 127's-

$ARSDOC -u $USER -p $PASSWORD -h $HOST -f "System Log" -o $1recs.out -S 10/1/17,10/12/17 -i "WHERE msg_num ='$1'" -v

issue q 127

10/16/17 09:22:46 : Starting arsdoc.  Version:  8.5.0.6
10/16/17 09:22:46 : /usr/lpp/ars/bin/arsdoc query -u admin -h archive -f System Log -o 127recs.out -S 10/1/17,10/12/17 -i WHERE msg_num ='127' -v
10/16/17 09:22:46 : Attempting login for userid 'admin' on server 'archive' ...
10/16/17 09:22:46 : Login successful
10/16/17 09:22:46 : Searching for folder 'System Log' ...
10/16/17 09:22:46 : Search successful
10/16/17 09:22:46 : Searching for documents in 'System Log' ...
10/16/17 09:22:46 : Querying database with SQL string 'WHERE msg_num ='127''
10/16/17 09:22:46 : Search successful
10/16/17 09:22:46 : Writing 892 hits in file '127recs.out'...
10/16/17 09:22:46 : Write successful
10/16/17 09:22:46 : arsdoc completed.

New command- might be wrong with my ARSDOC here.

$ARSDOC -u $USER -p $PASSWORD -h $HOST -f "System Log" -o out.out -S 10/1/17,10/12/17 -i "WHERE msg_num ='87' and msg_text like '5323-1-0-7FAA-15612-15612'" -v

Typical command that's pointing me towards a syntax issue.

Usage: arsdoc query -h hostname [-u <userid>] [-p <passwd>] [-U <user_alias>] [-v] (-F <parmfile> | ((-i <sql_query> | -q <namedquery> | -X <load_id>) [-x <load_id>] [-B <order_by_clause>] [-f <foldername>] [-G <name>] [-l <holdname>] [-e <delim>] [-H] [-I <type>] [-N <(field1)>][-n] [-o <filename>] [-d <dir>] [-L <max_hits>] [-S <startdate,enddate[,format]>]))
Version:  8.5.0.6

Am I thinking to hard with this one?

443

Content Navigator / First time ICN setup/config

« on: October 13, 2017, 06:28:06 AM »

Hi All,

I am going to be standing up various environments over the next few months in preparation of a large migration. I am looking from some best practice advice from some of you experts.

I am going to have 3 Non-Prod tiers..2 servers each.. running in a Redhat  / DB2 environment

CMOD 10.1 / ERM / PDF / TSM
ODWEK / AFP2PDF / WAS / ICN

Prod environment will be like this-

CMOD 10.1 / ERM / PDF /TSM (1 Library / 1 Object)
ODWEK / AFP2PDF
WAS / ICN

I haven't ever dabbled in ICN, and ODWEK/AFP2PDF was always covered by the "front end folks". Just wondering if these setups look good, or if anyone can give me some advice based on what they've done in the past.

Thanks

444

Report Indexing / Re: Extracting Indexes loading

« on: October 05, 2017, 08:10:05 AM »

Alrighty thanks much. I know that in my past gigs this was done by use of ARSULOAD exit. There was another script that was thrown in the post processor that I cant remember for the life me me look liked.

445

Report Indexing / Re: Extracting Indexes loading

« on: October 05, 2017, 05:18:59 AM »

I could have swore there was another way to do this.

What is the best way to pull the loadID from the DB to run the arsdoc against it to gather the indexes?

446

MP Server / Re: Send CMOD systel log to store to Centralized Log or syslog

« on: October 04, 2017, 06:40:19 AM »

use arsdoc get to dump the system log folder into a file and then load it into some kind of centralized log, im assuming you mean splunk or the like..?

probably just as easy to open the client and just view the folder, and easier to parse the data in my opinion.

447

MP Server / Re: Changing retention for historical loads

« on: October 03, 2017, 11:43:21 AM »

Not to bump this thread back from the dead.

Heres 2 scenarios.

Lets say I have an application group...

Load to cache for 5 days, then migrate over to TSM. Expire from TSM @ 30 days

Then we run our arsmaint -cvrmsid

30 days passes, and we run arsmaint as regularly scheduled. By now, the document has been expired from cache, and migrated to TSM. It's at its 30 day point, so ARSMAINT will remove the indexes from the db, and TSM will expire the data, because we have RETVER=30 as the setting.

Lets say I have another application group...

Load directly to TSM, never expire

Then we run our arsmaint -cmvrsid regularly, and our RETVER=9999 (Or whatever max aka forever is...)

The document will be expired in like 30 years 

Does ARSMAINT trigger or "TELL" TSM, hey, its time to delete this data? How does that work? is it proprietary?

448

Report Indexing / Re: Extracting Indexes loading

« on: October 03, 2017, 07:55:35 AM »

I could have swore that back a few years ago in another installation, we had a script that ran, and extracted the indexes somehow. I don't think it connected to DB2. I'm not sure how it worked.

Basically, I just want to get something like a file that says

DOCUMENTNAME, RDATE, POLICY
DOUCMENTNAME, RDATE, POLICY
DOCUMENTNAME, RDATE, POLICY

I could be taking the wrong approach

449

Report Indexing / Extracting Indexes loading

« on: October 03, 2017, 07:29:01 AM »

What is the best way to extract indexes from a particular file after loading.. this is for reconciliation purposes.

I've read about using a post processor, and I do recall using a C exit back in the day. I don't have C dev skills, so maybe a shell script in the post processor is my best bet.

Anyone have an idea/suggestion as to what it may look like?

450

MP Server / Re: Upgrade from 8.5 to 10.1

« on: September 26, 2017, 05:32:25 PM »

Okay, I absolutely will.