Hi Carmen,
No, the ID doesn't exist on the mainframe but I don't think it needs to be
there. I'm currently running ISKLM 2.5 and the DB2 ID that is defined with
the older ISKLM exists only on the ISKLM 2.5 servers as a local admin. Since
this DB2 ID is used only on the SKLM server for local DB2 admin work, I don't
believe it needs to be defined anywhere else. The SKLM install manual
specifically says not to use a domain ID, but a local ADMIN ID.
If the DB2 ID needs to be somewhere else, I'll be more than happy to get it
there.
Rex
-----Original Message-----
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of
Carmen Vitullo
Sent: Friday, August 23, 2019 7:42 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [External] Re: ISKLM problems - kind of related to mainframe
No SQL or SKLM expert but does this ID exist on the mainframe and server, same
password requirements ?
Carmen Vitullo
----- Original Message -----
From: "Rex Pommier" <rpomm...@sfgmembers.com>
To: IBM-MAIN@LISTSERV.UA.EDU
Sent: Thursday, August 22, 2019 4:27:22 PM
Subject: ISKLM problems - kind of related to mainframe
Hello,
Is there somebody on the list who would be willing to give me a hand installing
ISKLM 3.0.1? I'm trying to install it on a brand new windows 2016 box and the
DB2 install is failing with
SQL30082N Security processing failed with reason "19" ("USERID DISABLED or
RESTRICTED"). SQLSTATE=08001
This is at the end of the db2 install log.
The ID sklmdb31 was defined before starting the install and defined as a local
admin on the machine (not a domain ID at all) and the install added the
sklmdb31 ID to the DB2ADMINS group as part of the install, but then it dies
saying some USERID is DISABLED. What ID are they talking about and how do I get
past this error? The messages give me no indication that I've found to tell me
what ID they're talking about.
TIA,
Rex
Here's the rest of the log (with blank lines and junk lines removed for size)
User name sklmdb31
Country/region code 000 (System Default) Account active Yes Account expires
Never Password last set 8/22/2019 2:47:54 PM Password expires Never Password
changeable 8/22/2019 2:47:54 PM Password required Yes User may change password
Yes
Local Group Memberships *Administrators Global Group memberships *None
Alias name DB2ADMNS
Comment This group and local administrators will have complete access to all
DB2 objects through the operating system.
Members
-------------------------------------------------------------------------------
sklmdb31
The command completed successfully.
System error 1378 has occurred.
The specified account name is already a member of the group.
System error 1377 has occurred.
The specified account name is not a member of the group.
User name sklmdb31
Account active Yes
Account expires Never
Local Group Memberships *Administrators *DB2ADMNS Global Group memberships
*None The command completed successfully.
Return=0
DB20000I The DB2ICRT command completed successfully.
DB20000I The START DATABASE MANAGER command completed successfully.
DB20000I The CREATE DATABASE command completed successfully.
SQL1026N The database manager is already active.
SQL30082N Security processing failed with reason "19" ("USERID DISABLED or
RESTRICTED"). SQLSTATE=08001
DB20000I The DROP DATABASE command completed successfully.
DB20000I The STOP DATABASE MANAGER command completed successfully.
The information contained in this message is confidential, protected from
disclosure and may be legally privileged. If the reader of this message is not
the intended recipient or an employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any disclosure,
distribution, copying, or any action taken or action omitted in reliance on it,
is strictly prohibited and may be unlawful. If you have received this
communication in error, please notify us immediately by replying to this
message and destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
The information contained in this message is confidential, protected from
disclosure and may be legally privileged. If the reader of this message is not
the intended recipient or an employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any disclosure,
distribution, copying, or any action taken or action omitted in reliance on it,
is strictly prohibited and may be unlawful. If you have received this
communication in error, please notify us immediately by replying to this
message and destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
