Fixes are available
Rational Asset Analyzer for System z Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer for System z Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1
APAR status
Closed as program error.
Error description
The batch insert procedure for inserting analysis requests into the RAA queue is failing with a SQL -407, when the userid executing the batch insert newer have signed in to RAA.
Local fix
You will need to grant EXECUTE authority on the plan for the DMHTEP2 program in order to use it. 1. GRANT EXECUTE ON PLAN <plan_prefix>TEP2 TO PUBLIC; 2. Use the attached DMHJCLBU job for batch loading. It has an INSRTUSR step that ensures the current user's id is inserted into the DMH_USER table. Note: The step makes use of a DMHTBQUL variable that is the high-level qualifier for RAA tables (eg. DMH). //WSSTUDIO JOB 00000000,'WSAA BATCH UPDATE', // CLASS=A,MSGCLASS=H,MSGLEVEL=(1,0),NOTIFY=&SYSUID //* //* copyright-start //************************************************************** ** //* Licensed Materials - Property of IBM //* 5724-V27, 5655-R10, 5655-M22, 5655-L21, 5655-I49, 5655-D92 //* Copyright IBM Corp. 1993, 2013 //* //* All Rights Reserved //* US Government Users Restricted Rights - Use, duplication //* or disclosure restricted by GSA ADP Schedule Contract //* with IBM Corp. //************************************************************** ** //* copyright-end //*------------------------------------------------------------- ----* //* WSAA Batch Update interface to queue scan requests for * //* container(s) and/or file(s). This interface only queues the * //* request(s), to process queued requests run the DMHJCLQU job. * //*------------------------------------------------------------- ----* //* //* Before submitting this JOB, it must be customized. //* //* 1. Provide a valid JOB card for your installation. //* //* 2. Update this JOB's variables. Valid values for your site //* can be found in: &DMHHLQ.CONFIG.REXX(DMHPARMS) //* //* Variable Represents Example //* -------- ---------------------------- ------------- //* &DMHDB2L DB2 Runtime Library SYS1.DSNLOAD //* &DMHDB2S DB2 Subsystem GRT1 //* &DMHHLQ Product High-Level Qualifier DMH.V5R1M0 //* &DMHPLPX DB2 Plan Prefix DMH //* &DMHLE LE Runtime Library SYS1.SCEERUN //* &DMHLANG LE Language (ENU, JPN or KOR) ENU //* &DMHTBQUL Qualifier for tables DMH //* //* 3. Update DD INFILE with the scan requests. //* //* Lines starting with an asterisk are comments. Non-comment //* lines have two forms: one for change, the other for delete. //* //* For CA-Panvalet, z/OS PDS: //* C rmType site container memberFilter [[parentApp,] app] //* D rmType site container member //* //* For Serena ChangeMan: //* C CM site SERx,appId [TS=yyyy-mm-dd] [[parentApp,] app] //* D CM site SERx,appId member //* //* For z/OS SCLM: //* C SCLM site project,group [TS=yyyy-mm-dd] [[parentApp,] app] //* D SCLM site project,group member //* //* app : for assigning member to an application //* appId : ChangeMan Application Id //* memberFilter : allowed wild-cards are: * and ? //* parentApp : for assigning app to a parent application //* rmType : PAN or PDS //* SERx : ChangeMan Subsystem Id //* TS=yyyy-mm-dd : include only members changed since this date //* //* Examples: //* C PDS SITEA WSAA.V4R2M0.SDMHSSRC DMHSRC* IVP //* D PAN SITEA SYS1.PROD.PANLIB FILEA //* C PAN SITEA WSAA.V4R2M0.SDMHSSRC DMHJCL01 WSAA,IVP //* C SCLM SITEA ACCT,PAYROLL //*------------------------------------------------------------- ----* //* //INSRTUSR EXEC PGM=IKJEFT01,DYNAMNBR=20 //STEPLIB DD DISP=SHR,DSN=&DMHHLQ.SDMHLOAD // DD DISP=SHR,DSN=&DMHDB2L // DD DISP=SHR,DSN=&DMHLE //DBRMLIB DD DSN=&DMHHLQ.SDMHDBRM,DISP=SHR //SYSTSPRT DD DUMMY //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(&DMHDB2S) RUN PROGRAM(DMHTEP2) PLAN(&DMHPLPXTEP2) END //SYSIN DD * SET CURRENT SCHEMA = &DMHTBQUL; INSERT INTO DMH_USER SELECT (SELECT MAX(USER_ID)+1 FROM DMH_USER), USER FROM SYSIBM.SYSDUMMY1 WHERE NOT EXISTS ( SELECT 1 FROM DMH_USER WHERE UCASE(USER_NAME) = UCASE(USER) ); /* //STEP001 EXEC PGM=IKJEFT01 //STEPLIB DD DISP=SHR,DSN=&DMHHLQ.SDMHLOAD // DD DISP=SHR,DSN=&DMHDB2L // DD DISP=SHR,DSN=&DMHLE //DB2TRACE DD DUMMY //INFILE DD * * * Enter CHANGE and DELETE requests here * //RDPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(&DMHDB2S) RUN PROGRAM(DMH0700) PARM('NATLANG(&DMHLANG) /') - PLAN(&DMHPLPXP0700) END //SYSTSPRT DD SYSOUT=* //*
Problem summary
SQL -407, when the userid executing the batch INSERT has never signed into the web UI, so it does not exist in the DMH_USER table.
Problem conclusion
Updated dmh0700, dmh6000, and dmh0731 to ensure that the current userid is inserted into the DMH_USER table.
Temporary fix
Comments
APAR Information
APAR number
PI21468
Reported component name
RAA FOR SSTEM Z
Reported component ID
5655W5700
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-07-07
Closed date
2014-10-16
Last modified date
2014-11-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
unknown
Fix information
Fixed component name
RAA FOR SSTEM Z
Fixed component ID
5655W5700
Applicable component levels
R610 PSY
UP
Document Information
Modified date:
17 October 2021