Bind Warning - DB2 V9 Z/os



IBM's flagship relational database management system

Bind Warning - DB2 V9 Z/os

Postby p19689 » Wed Jul 18, 2012 3:14 pm

Hi , When I issue BInd with explain(YES) getting the following warning :

DSNX105I -DBD9 BIND SQL WARNING
USING abcde AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=pg1000
STATEMENT=700
SQLCODE=220
SQLSTATE=01546
TOKENS=FUNC_VERSION.fghi.DSN_FUNCTION_TABLE

I had check the error code 220 and the explanation is 'An error occurred during the insertion of a row into an optional explanation table' .

I had checked the privileges and there is an alias created on fghi.DSN_FUNCTION_TABLE for abcde as owner and given all privileges to PUBLIC on the base table.

'TOKENS' I'm not exactly sure about this but presume it refers to 'column name' that has the issue ? As DSN_FUNCTION_TABLE is standard table can anyone shade some light on what can go wrong here. I know this is just a warning and explain(no) will remove the warning but would like to understand the issue. Also I tried to locate STATEMENT =700 but there are no statement no 700 in the package.
Thanks in advance.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Bind Warning - DB2 V9 Z/os

 

Re: Bind Warning - DB2 V9 Z/os

Postby GuyC » Wed Jul 18, 2012 4:49 pm

it has nothing to do with authority :
+220

THE COLUMN column-name IN EXPLANATION TABLE table-name IS NOT DEFINED
PROPERLY

Explanation

An error occurred during the insertion of a row into the explanation table.
The table is improperly defined for the following reasons:
A column is missing.
Columns are defined in the wrong order.
The table contains an extra column.
A column description is invalid because of its name, data type, length,
or null attributes.


What's new in DB2 9:
Format of DSN_FUNCTION_TABLE in Version 9
In this release of DB2® for z/OS®, DSN_FUNCTION_TABLE has two columns with changed data types.

You can find the CREATE TABLE statement to create the DSN_FUNCTION_TABLE in member DSNTESC of the SDSNSAMP library.
The CCSID of all EXPLAIN tables is changed to UNICODE.

The following columns have changed data types:

APPLNAME The data type is changed to VARCHAR(24)
GROUP_MEMBER The data type is changed to VARCHAR(24)
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post