Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1281
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: 1281
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 3270 Data stream error Benchwarmer CICS 4 Tue Apr 17, 2018 12:06 am
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts IMS error U4038 while executing my PL... abdulrafi IMS DB/DC 2 Thu Feb 08, 2018 1:05 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us