IBM Support

Run SQL Scripts and CPI2101: Object QAQQINI in QTEMP type *FILE Created

Troubleshooting


Problem

This document discusses a new feature that was added to iSeries Navigator starting at r610.

Resolving The Problem

This document discusses a new feature that was added to iSeries Navigator starting at r610.

Starting at r610 a message CPI2101: Object QAQQINI in QTEMP type *FILE created is issued in the joblog when a user opens a Run SQL script window.

CPI2101    Information             00   06/07/12  12:52:32.685575  QLICRDUP     QSYS        0907     QSQDDL1     QSYS        *STMT
                                     From user . . . . . . . . . :   XDSR2
                                     To module . . . . . . . . . :   QSQEXCMD
                                     To procedure  . . . . . . . :   SQL_ExecuteCommand
                                     Statement . . . . . . . . . :   1758
                                     Message . . . . :   Object QAQQINI in QTEMP type *FILE created.

This is working as designed. There is new support that allows an application to temporarily override the existing QAQQINI file options with specific ones that the application wants. In Run SQL Scripts, we change some setting for our use. The changes make for Run SQL Scripts should not affect anything else except the Run SQL Scripts session/connection.

[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 for IBM i","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Historical Number

636268139

Document Information

More support for:
IBM i

Software version:
Version Independent

Operating system(s):
IBM i

Document number:
684369

Modified date:
18 December 2019

UID

nas8N1010929

Manage My Notification Subscriptions