IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL Assist Error


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
GopiMB

New User


Joined: 05 Nov 2009
Posts: 3
Location: INDIA

PostPosted: Thu Apr 08, 2010 3:55 pm
Reply with quote

Hi Folks,

Iam trying to use the SQL assist.

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.
Iam able to query sysibm.systables.
What is the difference in v8.1.5 and 9.1 that SQL assist is not working?

Can anyone let me know what's been missed in settings for DB2 OS390 V 9.1?

Thanks
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Apr 08, 2010 4:04 pm
Reply with quote

GopiMB,

Quote:
"No authorized routine named "SYSIBM.SQLTABLES" of type "

DB2 doesn't have a table named "SQLTABLES".

Sushanth
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Apr 08, 2010 4:10 pm
Reply with quote

sushanth bobby wrote:
GopiMB,

Quote:
"No authorized routine named "SYSIBM.SQLTABLES" of type "

DB2 doesn't have a table named "SQLTABLES".

of course not, it's a stored procedure.
Back to top
View user's profile Send private message
GopiMB

New User


Joined: 05 Nov 2009
Posts: 3
Location: INDIA

PostPosted: Thu Apr 08, 2010 4:23 pm
Reply with quote

Thanks GuyC, sushanth bobby.
But how do i get rid of this message/error? Any settings, updation required in db2cli.ini file or similar?
Why this occurs only in V9.1 and not in V8.1.5 which i tested and mentioned in the earlier message.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Apr 08, 2010 4:48 pm
Reply with quote

"Routine".... ahh, i missed that.

GopiMB, Check in DB2 V9, if the routine exists.



Sushanth
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Apr 08, 2010 6:52 pm
Reply with quote

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
Back to top
View user's profile Send private message
GopiMB

New User


Joined: 05 Nov 2009
Posts: 3
Location: INDIA

PostPosted: Tue Apr 20, 2010 4:01 pm
Reply with quote

thanks GuyC and Sushanth.
The mainframe admin had missed building some procedures.
After this error, he had rebuilt and its working fine now.
Thanks folks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top