Topics

1

z/OS Server / Upgrade and my 'personal' thoughts

« on: March 12, 2019, 07:11:11 AM »

Hi

I'm about to run into one of my most hated issues at work,
upgrading OnDemand. This time from 9.5 -> 10.1

If you don't like to read things from a "Grumpy old man", then
stop reading now!!!!

I don't really understand how it can be so hard for IBM to make
proper instructions how to do an 'downgrade' for CMOD, if you
managed to do an upgrade and realized that you're into big trouble
and need to do an 'downgrade'.

I did open an PMR and asked the question...
And not suprisingly!!?? the answers were:

"
..
As I mentioned, I did a quick compare and saw 3 tables that had more   
columns in 10.1 than 9.5, ARSHOLDMAP, ARSRES, and ARSSYS but again, that
is not an official statement and there may be other changes that I am   
not aware of
..
"

and

"
..
I appreciate that you don't think that answer is acceptable, but it is 
and has always been the answer for this release and all others prior.   
Development has never documented what changes the arsdb command will   
introduce, it is always recommneded to take backups of all the OnDemand
system tables (ARS*) and have those available if a rollback is required.
..
"

I don't understand how it can be so easily written by IBM, in the README-file
"
...
Customers will need to have a database backup and recovery plan implemented prior to
performing this procedure.
..
"

And that we accept ??

How hard can it be for IBM to make a script, so that we can do an 'downgrade'!

As I see it right now, you can do an upgrade.. but if anything happen, and you
need to do an 'downgrade. God forbid if you've loaded anything !!, then you're
out of synch !!
It might even be so that directly after you've upgraded adn starts the ARSSOCKD,
The System Log switch and messages are written to a new table...
whar will happen if you reload ARSSYS/ARSAG ??

Anybody have any thoughts ?
/Hakan Carlberg

2

OD/WEK & JAVA API / AFP2PDF Plus

« on: February 19, 2018, 11:47:38 PM »

Hi you all

I need a favor from you.
years ago I managed to code a Java-program that used ODWek to call AFP2PDF to convert my AFP-document to PDF.
But that was years ago.
Do any of you have any experience in that area?

I need:
- A small sample code from anybody
- explanation of how/where to put/how to use all propertie-files

regards
/H Carlberg

3

z/OS Server / CMOD load abends 0C4

« on: September 26, 2017, 11:28:58 PM »

Hi all

We've ran into a problem when running mixed mode of z/OS for a OAM-Plex.
One LPAR running z/OS 2.2 and the LPAR z/OS 2.3, loading data Always(almost) abends with 0C4,
have a look at OA54019

Regards
/H Carlberg

4

z/OS Server / Severe Error in OnDemand when using RACF for Application group checking

« on: May 14, 2017, 11:51:43 PM »

Hi everybody

I've recently found out that its a severe error in the code for OnDemand z/OS V9.5.0.7, when using RACF-checking for Application group authorization.
Let me try to explain:
A) You have a folder(TEST1) that have 2 Application Group( APG A(agid 5100) and APG B(agid 5110))
Now the PERMEXIT only checks for authorization on APG A, because it has the lowest agid, the exit is called 2 times, but both times the Application name supplied to the exit is A both times.

B)You have a folder(TEST2) that have 3 Application Group( APG X(agid 5050) ,APG A(agid 5100) and APG B(agid 5110))
Now the PERMEXIT only checks for authorization on APG X, because it has the lowest agid, the exit is called 3 times, but All times the Application name supplied to the exit is X.

So this means that if the user is authorized to only APG A, then he can't !! open folder TEST2 !!
And when opening folder TEST1, he can see APG A and APG B, although he's not authorized to that , he's only athorized to APG A!!

@Ed: I've opened PMR00540,160,846 for this



/H Carlberg

5

OD/WEK & JAVA API / Odwek getdocid in different format

« on: May 08, 2017, 06:14:57 AM »

Hi
Stupid question..
We are upgrading from V8.5.0 to V9.5.0... and get a strange behaviour in a ODWek Java application...
well strange and strange, but we can not find any information about it..

In 8.5.0 getdocid = DocID: "v7126-24826-24827-22773-FFK1-52FAAA-0-5396-0-2727-85-79-46......"
in 9.5.0 getdocid =  DocID: "Z2HlzcTg08nUBm4lkDIm8y8uPzMI6sFGbg+sBrvgXJTNozxMiHgmTCCuUoTAjydetpyI7tZ4MOAjuPUhGMzR..."

Anybody got any idead ?

Regards
/H Carlberg

6

z/OS Server / RACF and PASSTICKET

« on: June 03, 2016, 08:24:21 AM »

Hi Y'all experts

I have some questions.
We've been running with RACF-exit and using PASSTICKET.
But now we've starting to get weird messages.
I've been looking in the trace but I can't figure out what the heck is going on.

Sometimes I see:
"
Java_com_ibm_edms_od_ArsWWWInterface_apiLogon:(null) CsvLogon Server=CSODFT.CS.SHB.SE CsvLogon User=SEIDFT01 
Logon:Enter                                                                                                       
Logon:Return csv_rc=9,CSV_RC_MISC_ERROR csv_msgid=4,CSV_MSG_SERVER_CANNOT_CONNECT   

"

And sometimes:
"
Java_com_ibm_edms_od_ArsWWWInterface_apiLogon:(null) CsvLogon Server=CSODFT.CS.SHB.SE CsvLogon User=SEIDFT01   
Logon:Enter                                                                                                         
Logon:Return csv_rc=6,CSV_RC_NO_PERMISSION csv_msgid=28,CSV_MSG_INVALID_USER_OR_PASS 
"

Do any body of you have any clues ?

I can't find the meening of :
csv_rc=9,CSV_RC_MISC_ERROR ?

And
csv_rc=6,CSV_RC_NO_PERMISSION?
Because to our understanding, the user should have permission.

Regards
/H Carlberg

7

MP Server / CMOD 8.5 and Windows server 2012

« on: October 08, 2014, 09:28:24 AM »

Hi

A very stupid question, that we've been given today, and I've not been able to fin an answer on my favorite tool 'Google'.

Does anyone know if it's possible to run CMOD 8.5 on Windows Server 2012

regards
/H Carlberg

8

z/OS Server / OD 8.5.0.6 and OPC started JOBS with user not defined

« on: March 25, 2013, 09:33:29 AM »

Hi
This Weekend we upgraded our Largest production system to 8.5.0.6, and started to see some... weird things.

We're using OPC-started jobs to load data into OD(on z/OS), and the user that are used for OPC have never been defined in OnDemand.
All the jobs are 'pointing' to an arsload.cfg file which includes the userid/pw for the load.
Now we're seeing the following messages in the ARSSOCKD-job:
"
ICH408I USER(OTTRAPP ) GROUP(CDDPUOP ) NAME(RAPP-TT.OPC-ID
  LOGON/JOB INITIATION - INVALID PASSWORD                 
"

But the ARSLOAD-job ends with RC=0 and loads all the data.
Another strange thing is that we can ONLY see theese messages on the OnDemand-instances that are setup for SYSPLEX.

Does anybody have any clue ? Before I open an PMR.

Regards
/H Carlberg

9

z/OS Server / Doing MODIFY RECOVERY .. on ARSDBASE gives ARSSOCKD 00C90101

« on: October 29, 2012, 06:22:34 AM »

Hi

I Just want to inform you all that IBM has opened an APAR PM74595, that affects all of you out there who has following scenario:
- Data sharing
- Running Modify RECOVERY... on a 'large' DBD
- At the same time viewing documents from CMOD

We manage to get this error and IBM has now opened an APAR for it

"
ABEND04E RC00C90101 DSNGEPUF:500A was issued on DB2 V10 NFM
when a big DBD was read while another member was updating the
DBD.
The DBD on DSNDB01.SYSDBDXA was correct.
The DBD was big and split in many sections.
While one member was reading the DBD, another member updated the
DBD.
Then early some sections were read from the old DBD and later
sections were read from the new DBD.
Then the read DBD was inconsistent.
"

Regards
/H Carlberg

10

z/OS Server / CMOD 8.5.0.5 and RACF-exit

« on: May 28, 2012, 08:21:12 AM »

Hi

I've upgraded my CMOD from 8.4.0.4 to 8.5.0.5:
- Run the command '...arsdb -u ', received msg to set "ARS_CODESET=IBM-278"
- Compiled the RACF-exit(Without any error)

Now that we run, and there's an check for authorization against a FOLDER including NLS-character we get this check
in RACF(visiable thru NOTIFY-keyword in RACF):
"
ICH70004I IN CLASS ''ODTT?FOL'' AT 11:57:48 ON MAY 28, 2012             
ICH70004I USER(HACA02) GROUP(CDDPUOP) NAME(H?KAN CARLBERG)             
ICH70004I ATTEMPTED ''READ'' ACCESS OF                                 
ICH70004I ENTITY ''TEST$''                                             
"

note that the Entety should be "TEST?" and not "TEST$".

Now I should point out that if I'm running as a System Administor and "SRVR_FLAGS_FORCE_SECURITY=0" then everything works, so it's no problem to have a FOLDERNAME in NLS-characters...it's just the RACF-exit that gives me a problem.
I didn't have any problem using the RACF-exit in 8.4.0.4

This error is recieved both thru ODWek and OnDemand-client.

I've opened a PMR, but just wanted to check if anybody have stunbled over this earlier.

Regards
/H Carlberg

11

z/OS Server / CMOD 8.5.0 and ARSWIZ

« on: July 08, 2011, 05:20:35 AM »

Hi

I've just finish doing the SMP-work, and started reading the README-file.
Noticed the thing about ARS.ARSV850.ARSEXEC(ARSWIZ).

Tried to understand the function number 4"Execute V841 to V850 update jobs", but couldn't find any information regarding it either on the internet or any Manuals.
Does anybody have any information regarding that function? Did you run it ?

Regards
/H Carlberg

12

z/OS Server / Multiple System Logs

« on: December 27, 2010, 06:52:36 AM »

Hi
I'm running in a Sysplex environment with 4 started task running ARSSOCKD-pgm for one of my OD-instance. 2 are for Intranet and 2 are for Internet(another IP-stack).
 
If I look in my ARSUSER.ARSSEG-table I see two !! System Logs-tables that are in use ?!?!
I didn't expect that!!!!
If I run a query:
"
SELECT * FROM ARSUSER.ARSSEG 
  WHERE TABLE_NAME LIKE 'SL%'
FETCH FIRST 10 ROWS ONLY     
WITH UR;                     
AGID  TABLE_NAME     START_DATE           STOP_DATE             
--+---------+-------+---------+---------+---------+-
5001  SL2            1114082059           1212401118
5001  SL3            1212401123           1275631463
5001  SL4            1212401123           1245868532
5001  SL5            1275631463           1293456132
5001  SL6            1275631463           1275631463
"
Some other SQL:
"
 SELECT TABLE_NAME, INS_ROWS, START_DATE                 
          FROM ARSUSER.ARSSEG                           
   WHERE TABLE_NAME LIKE 'SL%'                           
 FETCH FIRST 10 ROWS ONLY                               
 WITH UR;                                               
---------+---------+---------+---------+---------+-------
TABLE_NAME             INS_ROWS  START_DATE             
---------+---------+---------+---------+---------+-------
SL2                    10005432               1114082059
SL3                    10003345               1212401123
SL4                    10007996               1212401123
SL5                      6640223              1275631463
SL6                               1               1275631463
"

"
 SELECT * FROM ARSUSER.SL6                                               
 FETCH FIRST 2 ROWS ONLY WITH UR;                                       
---------+---------+---------+---------+---------+---------+---------+---
 TIME_STAMP  USERID                                                     
---------+---------+---------+---------+---------+---------+---------+---
 1275631463  SEIP03PR                                                   
DSNE610I NUMBER OF ROWS DISPLAYED IS 1                                   
DSNE612I DATA FOR COLUMN HEADER MSG_TEXT COLUMN NUMBER 5 WAS TRUNCATED   
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100             
---------+---------+---------+---------+---------+---------+---------+---
 SELECT * FROM ARSUSER.SL5                                               
 FETCH FIRST 2 ROWS ONLY WITH UR;                                       
---------+---------+---------+---------+---------+---------+---------+---
 TIME_STAMP  USERID                                                     
---------+---------+---------+---------+---------+---------+---------+---
 1275631463  SEKA03PR                                                   
 1275631464  SEKA03PR                                                   
DSNE610I NUMBER OF ROWS DISPLAYED IS 2                                   
"
How can it come that I have 2 active System Logs ??
Have any of you seen this before ?

Regards
/H Carlberg

13

z/OS Server / Migration to 8.4.1 from OD 7.1 and a fallback

« on: June 28, 2010, 10:02:15 PM »

Hi

I've got a question for you guys.
Since I had this problem with downgrading to OD 7.1 from OD 8.4, I've been thinking about how I should have done.
I've been thinking about 2 possibly ways of doing my downgrade:
1) Done an unload of all the tables, then I only needed to do a load with that data and I've should have been 'home'(almost)
2) Using a technic of renaming the current tables, allocation new ones with the 'old look', and then using some SQL to load the 'old ones' from the new ones...

How did you guys do it ?

Regards
/H Carlberg

14

z/OS Server / OD 7.1 -> 8.4 -> 7.1 Problem

« on: June 04, 2010, 06:54:20 AM »

Hi,

I did a convert to OD 8.4.1 from a 7.1 system, and followed the instructions in the 'README' document.
In the section "DATABASE UPGRADE" the nr 3 item:
3.    Backup the OnDemand Database or make sure a current backup is available.

I don't know how I should have read that !!!
In my World that is an Image Copy, right ?
I got an Image Copy,  :-D

I then ran all the commands in item nr 4... fine !!

Now that we have tested the migration to 8.4.1 ... WE CAN'T GOBACK !!!

the reason....
all the 'arsdb -I <instance_name> -vd'-commands dropped some tables, and recreated them !!!
So my Image Copy is of no use since the OBID for the tables have changed !!

Does anybody have any idea ??


Regards
/H Carlberg

15

z/OS Server / DataWatch RMS

« on: November 11, 2009, 07:42:00 AM »

Hi,

Is there anybody out there that are running RMS from DataWatch?
We're looking into a solution for converting some reports from AFP, to Excel out for the customer.
Or is there any other solution for that?

/H Carlberg