IBM Support

WPG Instance ID required for executing archiver script

Technote (troubleshooting)


Problem(Abstract)

When executing archiver script, customer's userid has database admin authority but does not work. It gives error of SQLCODE-440

Symptom

When executing archiver script with dbadm authority, error msg:

"No authorized routine named routine-name of type routine-type having compatible arguments was found"

However, WPG is expecting customer to use the schema DB2 instance id to execute the bcgarchive

Cause

Un-sound security from DB2 perspective

Resolving the problem

APAR JR31482 improves the DB2 security in using WPG archiver

Document information

More support for: WebSphere Partner Gateway Enterprise Edition

Software version: 6.1, 6.1.0.1, 6.1.1, 6.1.1.1

Operating system(s): AIX, Linux, Windows

Software edition: Advanced, All Editions

Reference #: 1366016

Modified date: 09 December 2009