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