Hello Daniel
Thanks for the update. It is usually suggested that a user profile used to start replication has a storage limit of *NOMAX defined to avoid this sort of issue.
I always recommend that the user defined in the datastore connection credentials is specifically created for this purpose with the following attributes:
1) Initial program *NONE
2) Initial menu *SIGNOFF
3) Limit capabilities *YES
4) Password expiration *NOMAX
With these settings the user cannot be used to sign on interactively and short of a user with elevated authority specifying the user profile on a SBMJOB type command, the use of the user profile is effectively restricted to connections from the Access Server and resultant work.
The user also needs the appropriate authorities to the iSeries objects of course.
Regards
------------------------------
Robert Philo
------------------------------
Original Message:
Sent: Tue July 19, 2022 09:24 AM
From: Daniel Jose Lema Guanziroli
Subject: "RA MSG 1018 Agent successful Couldn't create user space" after upgrading to build 11101
As always, thank you Robert.
For your information, it was that the user was exceeding their storage maximum quota. To make troubleshooting difficult, it happens just the very same day we upgraded Access Server to build 11101 and, off course, we were pointing to the last change.
------------------------------
Daniel Jose Lema Guanziroli
Original Message:
Sent: Tue July 19, 2022 01:39 AM
From: Robert Philo
Subject: "RA MSG 1018 Agent successful Couldn't create user space" after upgrading to build 11101
Daniel
On the iSeries, the message IDs are not the same as for the LUW agents.
When you start replication (either data replication or a describe as part of amending the table mappings), various temporary objects with the subscription name are created such as user spaces in the CDC product library. My guess is that the process is failing for some subscriptions because the another user on the iSeries has previously worked with those subscriptions and created these objects with private authorities such that your user cannot delete them to recreate them, or to amend them.
What you will need to do this is to look at the job log detail on the iSeries. When the issue re-occurs, on the iSeries work with the RPLAGENT job that is active in the CDC subsystem under the user profile you use to connect in Management Console to display the job log detail.
If you do not have access to the iSeries and knowledge of it, you will need to work with the customer's iSeries operators or admins
Regards
Robert
------------------------------
Robert Philo
Original Message:
Sent: Mon July 18, 2022 07:11 PM
From: Daniel Jose Lema Guanziroli
Subject: "RA MSG 1018 Agent successful Couldn't create user space" after upgrading to build 11101
Good day:
I have upgraded IDR AccessServer (AIX) to build 11101, as well as the Management Console. After that, now I cannot create or modify some subscriptions. When I click on Map Tables, it fails with error
Loading target database users...
ERROR:
RA MSG 1018 Agent successful Couldn't create user space
It does not happens with all subscriptions, but some of them. The subscriptions failing involve source and target IBM I agent at level V11R4M0B32125. The working subscription is involving also other agents of the same platform and level.
Any idea?
PD: IBM Docs does not describe the event 1018, see Events 1000-1099 - IBM Documentation.
Daniel Lema
IT Specialist
#DataReplication
#DataIntegration