search cancel

Post install task, 'Create Required DB2 Objects', failed with a -904 error due to an unavailable resource, package PTADRVAC.

book

Article ID: 53876

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS Endevor Software Change Manager (SCM) Endevor Software Change Manager - Natural Integration (SCM) Endevor Software Change Manager - ECLIPSE Plugin (SCM) Endevor Software Change Manager - Enterprise Workbench (SCM)

Issue/Introduction

Description:

During the post install process, install task ssid0001 'Create Required DB2 Objects', failed with a -904 SQL error.

DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN 
   UNAVAILABLE RESOURCE. REASON 00E70010, TYPE OF RESOURCE 
   00000801, AND RESOURCE NAME AUTH1107_COM.PTADRVAC.17706531010-
   C5D99 
DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE 
DSNT415I SQLERRP    = DSNXIDPM SQL PROCEDURE DETECTING ERROR 
DSNT416I SQLERRD    = 35  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION 
DSNT416I SQLERRD    = X'00000023'  X'00000000'  X'00000000' 
   X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC 
   INFORMATION

How can the -904 error be resolved?

Solution:

The Package PTADRVAC performs SELECTs from the following ACM Tables;

PTALT_ACM_0610
PTALT_SYSTBL_0610

These are both in Tablespace PTITSTBL.

The package was unable to perform it's SQL due to either of these tables being locked.

Changing the THREADS parameter of the BATPROC PARMLIB member from 2 to 1, should resolve this problem.

A THREADS parameter of 1, specifies that Batch Processor will use single-thread SELECT and SQL processing. This should eliminate the contention and allow the ssid0001 Install task to complete.

If object contention such as this occurs regularly when using Batch Processor, then consider setting THREADS(1) permanently, otherwise use THREADS(2) for improved performance.

THREADS(1) - single-thread processing
THREADS(2) - multiple-thread processing

Environment

Release:
Component: ENDBAS