STIGQter: STIG Summary: CA IDMS Security Technical Implementation Guide Version: 2 Release: 2 Benchmark Date: 01 Jul 2026:

The cache table procedures and views used for performance enhancements for dynamic SQL must be protected.

DISA Rule

SV-251646r961638_rule

Vulnerability Number

V-251646

Group Title

SRG-APP-000441-DB-000378

Rule Version

IDMS-DB-000820

Severity

CAT II

CCI(s)

• CCI-002420 - Maintain the confidentiality and/or integrity of information during preparation for transmission.

Weight

10

Fix Recommendation

Either turn off use of SQL cache or secure SQL cache tables.

Turn off SQL cache use in local using SYSIDMS parameter SQL_CACHE_ENTRIES=0. Turn off SQL cache use in IDMS CV and modify sysgen with statement DELETE SQL CACHE.

To secure SQL cache tables add RESTYPE DB entry and RESTYPE TABL occurrences for SQL cache tables (table procedures and views) SYSCA.DSCCACHE, SYSCA.DSCCACHEOPT,SYSCA.DSCCACHECTRL, SYSCA.DSCCACHEV) and any other views of SYSCA.DSCCACHE created by the organization.

For example:
#SECRTT TYPE=ENTRY,RESTYPE=DB,EXTCLS='CA@IDMS',
EXTNAME=(RESTYPE,ENVI,RESNAME),SECBY=OFF

#SECRTT TYPE=ENTRY,RESTYPE=TABL,EXTCLS='CA@IDMS',
EXTNAME=(ENVI,RESTYPE,SCHEMA,RESNAME),SECBY=EXTERNAL
... (other DB-covered ENTRYs e.g., NRU, DACC. etc.)
#SECRTT TYPE=OCCUR,RESNAME='<db/segment to secure>',RESTYPE=DB,SECBY=EXTERNAL

Secure SQL cache tables in external security manager (ESM) using the corresponding chosen external name (e.g., PROD.TABL.SYSCA.DSCCACHE).

Check Contents

For CA IDMS CV, issue "SELECT * FROM SYSCA.DSCCACHEOPT". If rows are returned, caching is on.

For local, if no statement, SQL_CACHE_ENTRIES=0 exists in the SYSIDMS specification, caching is on.

Examine RHDCSRTT in security domain for security on table procedures and views of DSCCACHE table; those supplied at installation (SYSCA.DSCCACHE, SYSCA.DSCCACHEOPT,SYSCA.DSCCACHECTRL, SYSCA.DSCCACHEV) or those created by organization.

If no security is found for these table procedures and views, this is a finding.

Vulnerability Number

V-251646

Documentable

False

Rule Version

IDMS-DB-000820

Severity Override Guidance

For CA IDMS CV, issue "SELECT * FROM SYSCA.DSCCACHEOPT". If rows are returned, caching is on.

For local, if no statement, SQL_CACHE_ENTRIES=0 exists in the SYSIDMS specification, caching is on.

Examine RHDCSRTT in security domain for security on table procedures and views of DSCCACHE table; those supplied at installation (SYSCA.DSCCACHE, SYSCA.DSCCACHEOPT,SYSCA.DSCCACHECTRL, SYSCA.DSCCACHEV) or those created by organization.

If no security is found for these table procedures and views, this is a finding.

Check Content Reference

M

Target Key

5418