PM93115: SQL -973 ERRORS RELATED TO AGENT_STACK_SZ WHEN RENDERING DIAGRAMS IN RAA.

Fixes are available

APAR status

Closed as program error.

Error description

Using RAA 6.0.0.11, when attempting to Show Control
flow diagram, Show program diagram, or Show structure diagram,
the diagram starts to render but never finishes, even after
multiple hours.
At first, SQL -101 errors (which result in a SQL -727 as a
side-effect), are logged regarding STMTHEAP size, but after
raising the STMTHEAP value, you may then receive
SQL -973 errors  related to AGENT_STACK_SZ and cannot resolve
those errors even by setting AGENT_STACK_SZ to its maximum
value.

Local fix

```
none known.
```

Problem summary

Showing an application diagram results in SQL -973 that isn't
fixed by increasing the DB2 AGENT_STACK_SZ setting.

Problem conclusion

RAA online data store query was rewritten to remove redundant
predicates and shorten query.

Temporary fix

Comments

APAR Information

APAR number
PM93115
Reported component name
RATL ASSET ANAL
Reported component ID
5724V2700
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-16
Closed date
2014-02-20
Last modified date
2014-02-20

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

Modules/Macros

```
diagram
```

Fix information

Fixed component name
RATL ASSET ANAL
Fixed component ID
5724V2700

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.0","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
02 November 2021

Tips

PM93115: SQL -973 ERRORS RELATED TO AGENT_STACK_SZ WHEN RENDERING DIAGRAMS IN RAA.

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?