Messages

196

Documentation / Re: CMOD / TSM and moving to AWS compatibility

« on: March 05, 2021, 07:08:13 AM »

I think that as long as you're within the compatibility matrix, you're fine -- OS, database, storage, etc.  I haven't seen any special requirements just because you're in the cloud.

-JD.

197

Report Indexing / Re: Loading large CSV using Generic indexer

« on: March 05, 2021, 06:12:17 AM »

What is your Application Configuration in CMOD?  Are you treating this document as line data?  You may have exceeded a 'number of lines per page' limit, since it appears to cut off at 2¹⁰.

It's probably best to treat this as a user defined data type, so that OnDemand treats it as a binary file.

-JD.
   

198

Documentation / Re: Translating names and values for configuration objects with SQL Server

« on: March 04, 2021, 01:32:36 PM »

Sounds like your CMOD database isn't in unicode.  Can you confirm the codepage that the Content Manager OnDemand database was created with?

-JD.

199

Report Indexing / Re: Date Format Error

« on: March 02, 2021, 07:35:11 AM »

My first guess is that there's a data quality issue.  Have you checked the report to see that the data is where you expect it to be on that 59th document?

-JD.

200

Windows Client / Re: Client Application Window is not Displaying

« on: February 26, 2021, 01:10:48 PM »

Are they running the OnDemand Thick Clients on Citrix?  I've seen strange window-handling like this before with desktops spanning multiple monitors while using the CMOD Client on Citrix.

-JD.

201

MP Server / Re: Any easy/fancy ways to gather all loads in one year time frame?

« on: February 25, 2021, 07:52:01 AM »

Yup, the overhead for this is tragic.  Probably more overhead in OnDemand's internal database tables than actual index data.

-JD.

202

Tips and Tricks / Re: Proof of Concept - Archiving the z/OS SYSLOG With ARSYSPIN

« on: February 25, 2021, 07:50:52 AM »

Hey Ed.  I just enabled the upload of .zip files.  You can edit your post and try again. 

-JD.

203

MP Server / Re: determine oldest doc in an app group?

« on: February 25, 2021, 07:49:20 AM »

Choose the OnDemand database segment from CMOD's arsseg table with the earliest start date, then search for the minimum value on the segment date field. 

As far as I know, the start and stop date fields in the segment table aren't updated as part of expiration processing, so the date in the segment table may not be accurate.

-JD.

204

Windows Client / Re: Merging query restriction permissions for multiple usergroups on same app.group?

« on: February 25, 2021, 07:44:30 AM »

You'd have to test it, but I'm not sure you can stack CMOD query restrictions through multiple group memberships.  Hopefully there's few-enough cases where you can create enough groups in Content Manager OnDemand to satisfy the requirements.

-JD.

205

MP Server / Re: Any easy/fancy ways to gather all loads in one year time frame?

« on: February 23, 2021, 06:24:06 PM »

The CMOD System Load (SA*) tables should be your first stop.  There's no AppGroup field in the OnDemand System Log without doing a full-text search, which is terrible for performance.  A few tweaks of SQL should help you get what you need.

Also, loading 100k files per month is terrible.  Load larger files less frequently to reduce the overhead in CMOD. 

-JD.

206

MP Server / Re: Issue with arsdoc query

« on: February 12, 2021, 02:54:32 PM »

Remember - you're searching the Content Manager OnDemand database field directly. with the OnDemand arsdoc -i parameter.  And the time in the CMOD database is stored as UTC, without timezones.  You need to adjust your query to match your local timezone.  There's probably a clever way to do this at the database level, but I don't know how, exactly.

-JD.

207

MP Server / Re: Issue with arsdoc query

« on: February 12, 2021, 12:37:28 PM »

Time zone settings. 

208

z/OS Server / Re: docid from OnDemand

« on: February 12, 2021, 12:36:30 PM »

You can probably do this with OnDemand's arsdoc query command.  You can query the Application Group and specify the fields you want, or you could build a Content Manager OnDemand Folder that exposes the CMOD Unique Doc ID.

-JD.

209

z/OS Server / Re: CMOD z/OS V10R1M0 - AbendU4080 running IVPs ARSIVPJ1 or ARSIVPJ2

« on: February 12, 2021, 12:18:48 PM »

I suspect your -d parameter is wrong.  You can omit the -d option if your XML file is in the same directory that you're running the command from.

-JD.

210

MP Server / Re: Multiple oracle instances configured on the same box

« on: February 10, 2021, 11:41:08 AM »

I generally don't recommend remote database instances with CMOD, as it adds complexity and latency.  Any network-related glitch can disconnect CMOD from the database, leading to availability issues for end users, and issues recovering transactions (loads, activity logs, etc.)

-JD.