Messages

76

MP Server / Re: Audit , SSL/TLS

« on: June 07, 2022, 09:50:36 AM »

Hello ,

1-is CMOD V10.5 Multiplatform containing audit trail feature ?
If yes how can I enable it , or how to configure it

2- What's the version of TLS/SSL is supported from the CMOD V10.5 ?

What exactly do you mean by audit trail?

77

z/OS Server / Migrating AIX exits to ZOS

« on: May 18, 2022, 09:27:32 AM »

Hi All,

we recently migrated to the ZOS platform from MP. We ran an ARSLOG exit on our AIX library server.

The question is - do we have to move this script/repurpose it on the Z/OS server - or is there some other way we can do it, possibly on one of our load servers that runs arsload scripts.

Thank you!

78

Content Navigator / Message of the day + Content Navigator

« on: May 11, 2022, 03:28:12 PM »

Hi All,

does anyone know if its possible to use the message of the day feature with content navigator?

Obviously it works when a user uses the thick client - We are wondering if its possible when someone uses ICN.

Thanks

79

MP Server / Re: arsjesd broken in 10.5.0.4

« on: April 18, 2022, 10:17:58 AM »

Hi Ed,

Can you provide any more information on this?

Thanks

80

Report Indexing / Re: Bad Character in data file

« on: March 14, 2022, 07:42:48 AM »

Thanks...We had JUST recreated a new APP GRP because of another index field they wanted to increase the size of.  Hate you cant just go in to the current APP GRP and increase fields lengths on the fly

Yeah agree. Not a DBA, but I know there's limitations/restrictions to increasing column length and things like that.

I've usually pushed back on the business but hey - they pay the bills.

81

Report Indexing / Re: Bad Character in data file

« on: March 09, 2022, 09:43:35 AM »

I saw this a few months back, I think it's because there's a blank space after the special character - And it's increasing your field past the 38 threshold. I think unfortunately we were in a hurry, and i just recreated the app group and increased the length.

I'm not an ACIF indexing expert but I am sure that if you're using it -  you can do some fancy footwork to accomodate.

82

MP Server / Re: Field maximum length issue

« on: February 03, 2022, 09:54:27 AM »

One of two things I've done in the past.

A.
1) rename old app group, APPGROUP_OLD
2) Copy app group, APPGROUP , except make the field length whatever you need or expect
3) Copy corresponding application(s)
4) Map to existing folder(s)

B.   Push back on your business partners to keep it at 160.

I'm also sure there's pre/post processors that can work- but i've never done that approach.

83

Content Navigator / Re: Test

« on: January 26, 2022, 07:39:33 AM »

Good Morning!

84

Content Navigator / Re: CMOD PDF Fails to Load

« on: January 26, 2022, 07:39:23 AM »

Usually when I see this, I do some digging and find a load that failed, yet generated a loadID

I'll then fire off an arsadmin unload using the -L <LoadID> flag, and that resolves it.

I don't have the exact error code handy - but if you google it, there's a technote somewhere directly from IBM on how to resolve this at the database. But my method has worked fine.

85

MP Server / Re: migrating from DB2 to Oracle

« on: January 11, 2022, 08:11:19 AM »

@jsquizz - Did you manage to find a solution for this? If so, please pots here the approach. Thanks.

I have since left the project - however the plan was to use oracle's  "heterogenous link" functionality. I am not an oracle guru at all - but my colleague who was - said it should work.

https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity#:~:text=Oracle%20supports%20heterogeneous%20services%20to%20allow%20data%20in,uses%20ODBC%20or%20OLEDB%20to%20make%20the%20connections.

After the link is setup, migrate all the cache from onprem to azure.

86

MP Server / Re: Determine the active segment table being used

« on: December 27, 2021, 07:11:10 AM »

Thanks JD/Darrell, this will work. Haven't had to use this command but this will be a GREAT help! I am still however, getting the same error.

Code: [Select]

preProd:root# arstblsp -a3 -h archive
ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=, Line=

87

MP Server / Re: Determine the active segment table being used

« on: December 16, 2021, 01:18:52 PM »

You can try this too:

arstblsp -a3 -h archive

This will show all the tables that are open for loading by application group.

Makes sense that this would work,

however.

Code: [Select]

dev:bin# arstblsp -a 3 -I archive
ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=, Line=

88

MP Server / Re: Determine the active segment table being used

« on: December 10, 2021, 08:25:54 AM »

Thanks Greg!

the solution I came up with, was something along the lines of-

joining arsseg/arsag, pulling table_name based on where app_group=xyz order by table_name then a tail -1 on the results.

I think that will work. Still testing and reviewing with my colleagues..seems a bit too easy

89

MP Server / Determine the active segment table being used

« on: December 08, 2021, 02:25:16 PM »

Hi All,

wondering if anyone has a db2 query handy, or any suggestions on writing a query-  that will return the active app group segment table being loaded to.

Thanks!

90

MP Server / Best way to query system log using UTC date?

« on: November 30, 2021, 08:40:33 AM »

Hi Folks,

I am writing a simple script that captures some daily activity from the system log, using arsdoc query.

In dealing with the system log storing the date in UTC format so here's a quick snippet of my plan:

Code: [Select]

YESTERDAY=`something that generates yesterdays date`
2DAYSAGO=`somethinh that generates 2 days ago`
Now, throwing it into arsdoc query, my plan is this, example is - capturing 88 records for 11/29/21 Server Time-

Code: [Select]

"-i "where ODDAT_LOAD_DATE BETWEEN '$2DAYSAGO.16.59.59' and $YESTERDAY.16.59.59'"
Trying that approach and I am getting this error

Code: [Select]

DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0180N  The syntax of the string representation of a datetime value is incorrect.  SQLSTATE=22007  -- SQLSTATE=22007, SQLCODE=-180, File=arsdoc.c, Line=3563
Does anyone have a handy way of getting things from the system log for the previous day, from a monitoring script, report, etc..?

Thanks!