IBM Support

Data virtualization Manager (DVM) cannot read SMF log stream data when SQL query is executed

Troubleshooting


Problem

When a SQL query against a SMF virtual table is executed to read data from log stream then an ABEND X'0C4' occurs

Symptom

select * from SMF_10100_QWAC__IFASMF_Q_JA0_STREAM limit 10 FOR FETCH ONLY - SQLCODE 0
SRB SYSTEM ABEND X'0C4' AT CLUSRC/AVZ$650E+X'00000001' RETRY AT X'2B6BA162' ERRORID 732                                         
FRR ABEND REASON X'0000003B' DATA AT PSW - 00000000_00000000_00000000, RELATED-TCB 0079B2B0, HOME-ASCB 00EAEA00, PASN 01AD, SASN
-RTNE RETRYX01                                                                                                                  
Z/ARCH-PSW 0784_1001_80000000_00000000_B08A0000 (AM64,KEY8,SUP,PRI) - HIGH HALVES OF 64-BIT REGISTERS ARE NON-ZERO              

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"ARM Category":[{"code":"a8m3p000000PCIhAAO","label":"Server"}],"ARM Case Number":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions"},{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS6QWT","label":"IBM QMF Analytics for Multiplatforms"},"ARM Category":[{"code":"a8m0z000000cxH0AAI","label":"QMF Data Service"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
02 August 2024

UID

ibm17162083