SQL Assist Error



IBM's flagship relational database management system

SQL Assist Error

Postby manesg » Thu Apr 08, 2010 3:52 pm

Iam trying to use the SQL assist. (command edit - SQL assist icon)

OS: Z/OS 1.10
DB: DB2 OS390 V 9.1
DB2 Client:
C:\myfold\db\db2udb95\BIN>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09051" with
level identifier "03020107".
Informational tokens are "DB2 v9.5.100.3130", "special_20479", "WR21402_20479",
and Fix Pack "1".
Product is installed at "C:\myfold\db\db2udb95" with DB2 Copy Name "DB2COPY1".

I get the error message when i click on "SQL" assist icon in the command editor from the client.
"No authorized routine named "SYSIBM.SQLTABLES" of type "" having compatible arguments was found

I checked this
OS: Z/OS 1.10
DB: DB2 OS390 V 8.1.5
DB2 Client: Same as above

When i click on SQL Assist icon in command editor, it works fine.

I can query sysibm.systables too. So there is permission is what i confirm.
Any difference in the version 8.1.5 and 9.1?
Can anyone let me know what's been missed in settings for DB2 OS390 V 9.1?
manesg
 
Posts: 22
Joined: Thu Jul 17, 2008 11:16 am
Has thanked: 0 time
Been thanked: 0 time

Re: SQL Assist Error

 

Re: SQL Assist Error

Postby GuyC » Thu Apr 08, 2010 4:07 pm

SYSIBM.SQLTABLES is a stored procedure, not the table SYSIBM.SYSTABLES.

make sure all stored procs are installed on Z/OS
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: SQL Assist Error

Postby manesg » Thu Apr 08, 2010 4:26 pm

Thanks GuyC,
How do i check that in Z/Os?
Can you please provide the information? Should i need to tell the mainframe admin to have this SQLTABLE procedure in place? If so, where?
manesg
 
Posts: 22
Joined: Thu Jul 17, 2008 11:16 am
Has thanked: 0 time
Been thanked: 0 time

Re: SQL Assist Error

Postby GuyC » Thu Apr 08, 2010 7:29 pm

GuyC wrote:SYSIBM.SQLTABLES is a stored procedure needed for ODBC/JDBC.

Usually setting up software to be able to access DB2 z/OS includes
creating and/or binding some stored procedures/packages in DB2 z/OS.

Sometimes it is Windows/unix setup that takes care of it,
Sometimes it is stated as a preriquisite
Sometimes it is some JCL you have to execute on the mainframe.

Possibly V9 uses another stored proc/version than V8.1.5
link to another forum removed

yes it is the dba's responsibility to enable JDBC on z/OS
google SYSIBM.SQLTABLES and you would find some info
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: SQL Assist Error

Postby manesg » Tue Apr 20, 2010 3:55 pm

Thanks GuC.
Seems like some procedures where missing and the mainframe admin has got them up.
Its working fine now.
Thanks.
manesg
 
Posts: 22
Joined: Thu Jul 17, 2008 11:16 am
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post