IBM Support

Debug Run SQL Scripts job

Troubleshooting


Problem

Steps to debug the Run SQL Scripts QZDASOINIT job.

Resolving The Problem

If you attempt to put the QZDASOINIT Run SQL Scripts job under debug, it might fail with CPF3501:
Message ID . . . . . . . . . :   CPF3501                                     
Message . . . . :   Job is already being serviced, traced, or debugged.       
Cause . . . . . :   One of the following requests have been made:             
    --Service a job that is being serviced.                                   
    --Service a job that is being traced.                                     
    --Service a job that is being debugged.                                   
    --Trace a job that is being serviced.                                     
    --Trace a job that is being traced.                                       
Recovery  . . . :   When current servicing, tracing, or debugging is complete, try the request again.
==================================

The failure is caused by a preference setting in Run SQL Scripts.

Ensure that the following box is NOT checked and restart Run SQL Scripts before debugging:
image-20230607131438-5

Document Location

Worldwide


[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CTpAAM","label":"IBM i Access-\u003EAccess Client Solutions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Document Information

More support for:
IBM i

Component:
IBM i Access->Access Client Solutions

Software version:
All Versions

Operating system(s):
IBM i

Document number:
7001897

Modified date:
07 June 2023

UID

ibm17001897

Manage My Notification Subscriptions