Unable to call db2 procedures with XMETA user

[deepu09]

DataStage 8.5 running in AIX 5.3 OS. We are unable to run any procedures related to db2 with xmeta, db2inst1 and db2fenc1 users.

To know the size of xmeta DB I called procedure [call get_dbsize_info(?,?,?,0)] it is throwing error message

SQL1042C An unexpected system error occurred. SQLSTATE=58004

I tried with all users xmeta, db2inst1, dasusr1 and db2fenc1 every time it is giving same error message.

db2diag.log file is not giving me any proper error message (below is contents from log file).

2012-11-07-10.05.38.350482-480 E15248850A1385 LEVEL: Error
PID : 2338924 TID : 7751 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : XMETA
APPHDL : 0-4405 APPID: *LOCAL.db2inst1.121107180543
AUTHID : DB2INST1
EDUID : 7751 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:30
DATA #1 : String, 29 bytes
Number of IPC resource found:
DATA #2 : signed integer, 4 bytes
1
DATA #3 : String, 29 bytes
Number of IPC resource freed:
DATA #4 : signed integer, 4 bytes
1
CALLSTCK:
[0] 0x09000000147801F4 pdLog + 0xFC
[1] 0x0900000012C7337C sqlerRemoveAllIPCforRow__FP11sqlerFmpRowb + 0x600
[2] 0x0900000012C72C38 @136@sqlerRemoveFmpFromTable__FP11sqlerFmpRowPP11sqlerFmpRowT2bT4Ci + 0x2D8
[3] 0x0900000012C72908 sqlerRemoveFmpFromTable__FP11sqlerFmpRowb + 0x30
[4] 0x0900000012C7279C @136@sqlerShutdownFMP__FP11sqlerFmpRowP14sqlerFmpHandleP13sqlerFmpTableP8sqeAgentbT5 + 0x754
[5] 0x090000001063413C sqlerGetFmpFromPool__FP14sqlerFmpHandleP13sqlerFmpParms + 0x174
[6] 0x09000000115D3BC0 sqlerInvokeFencedRoutine__FP13sqlerFmpParms + 0xAC
[7] 0x090000001477E7CC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x4B4
[8] 0x090000001477F37C sqlricall__FP8sqlrr_cb + 0x120
[9] 0x09000000147FD308 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5AC
$

I am struggling with this for past one week. Can some one please help me if you have any clue how to fix this? Our DataStage 8.5 repository is running in db2. I new to DataStage any help is greatly appreciated.

[ray.wurlod]

Can you obtain the size information by any other means outside of DataStage, such as DB2 Control Center?

If so, how are you providing parameters to match the stored procedure parameter placeholders in the stored procedure call? For that matter, how are you attempting to call the stored procedure from DataStage?

[cipsy]

Please check owner thats folder

/opt/IBM/db2
/opt/IBM/InformationServer/Repos

Repos folder have xmeta db2 files. if change to owner repos folder your db2 acces to xmeta .

[deepu09]

Hi Ray,

We dont have license to connect to xmeta repository (db2) through any client. I can only connect to xmeta through command line.

[First I will login with my personal user ID to our DataStage server. Then I will sudo to db2inst1 user. From there I will connect to db2 database. To connect to xmeta schema with xmeta user I use command db2 connect command. Then To know the size of xmeta DB I called procedure [call get_dbsize_info(?,?,?,0)] it is throwing error message.

Below are commands I use to connect to xmeta schema in DataStage server. Please correct me if I am doing anything wrong.

800100@xx.xx.x.xx's password:
[YOU HAVE NEW MAIL]
$ sudo su - db2inst1
Password:
$
$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => connect to xmeta user xmeta using xxxxx

Database Connection Information

Database server = DB2/AIX64 9.7.0
SQL authorization ID = XMETA
Local database alias = XMETA

db2 => call get_dbsize_info(?,?,?,0)
SQL1042C An unexpected system error occurred. SQLSTATE=58004
db2 =>