View previous topic :: View next topic
|
Author |
Message |
GopiMB
New User
Joined: 05 Nov 2009 Posts: 3 Location: INDIA
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
GopiMB,
Quote: |
"No authorized routine named "SYSIBM.SQLTABLES" of type " |
DB2 doesn't have a table named "SQLTABLES".
Sushanth |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
GopiMB
New User
Joined: 05 Nov 2009 Posts: 3 Location: INDIA
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
"Routine".... ahh, i missed that.
GopiMB, Check in DB2 V9, if the routine exists.
Sushanth |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
GopiMB
New User
Joined: 05 Nov 2009 Posts: 3 Location: INDIA
|
|
|
|
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 |
|
|
|