PI21468: RAA DMH0700 FAILS WITH SQL -407 TRYING TO INSERT ANALYSIS REQUESTS INTO RAA QUEUE

Fixes are available

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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
17 October 2021

Tips

PI21468: RAA DMH0700 FAILS WITH SQL -407 TRYING TO INSERT ANALYSIS REQUESTS INTO RAA QUEUE

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R610 PSY

Document Information

Share your feedback

Need support?