Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQL Assist Error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: SQL Assist Error
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: 1013
Location: India

PostPosted: Thu Apr 08, 2010 4:04 pm    Post subject:
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: 1278
Location: Belgium

PostPosted: Thu Apr 08, 2010 4:10 pm    Post subject:
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    Post subject: Reply to: SQL Assist Error
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: 1013
Location: India

PostPosted: Thu Apr 08, 2010 4:48 pm    Post subject:
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: 1278
Location: Belgium

PostPosted: Thu Apr 08, 2010 6:52 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us