473,320 Members | 1,612 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Control Center SQL Assist

We're trying to use SQL Assist in the DB2 Control Center for DB2/LUW 9.5 and
we are getting the following error:
"Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error
SQLSTATE with diagnostic text "SYSIBM:CLI:-727". SQLSTATE=38553"

If I try to call the SP directly I get the same error:

call sysibm.sqltables('','ACCTASGN','AUTO_NUMBERS','',' ');

SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned
an
error SQLSTATE with diagnostic text "SYSIBM:CLI:-727". SQLSTATE=38553

Looking up SQL727 I get this:

SQL0727N An error occurred during implicit system action type
"<action-type>". Information returned for the error includes
SQLCODE "<sqlcode>", SQLSTATE "<sqlstate>" and message tokens
"<token-list>".

Explanation:

The processing of a statement or command has caused the database manager
to implicitly perform additional processing. During this processing an
error was encountered. The action attempted is shown by the
"<action-type>":

1 implicit rebind of a package

2 implicit prepare of a cached dynamic SQL statement

3 implicit regeneration of a view

4 This return code is reserved for use by DB2.

5 incremental bind of a static SQL statement, not bound during
package bind time

6 implicit prepare of a reoptimizable statement containing
host-variables, special registers, or parameter markers

7 implicit regeneration of a trigger

8 implicit regeneration of a function

9 implicit regeneration of a check constraint

10 implicit instantiation of a global variable

The sqlcode, sqlstate and message token list (each token is separated by
the vertical bar character) are provided. The message tokens may be
truncated. See the corresponding message for the "<sqlcode>" for further
explanation of the error.

The original SQL statement or command that caused the "<action-type>"
cannot be processed and the implicit system action was not successful.

Federated system users: You may have received this message because you
dynamically prepared an SQL statement in a pass-through session and then
tried to execute the statement after the session was closed.

User response:

Check the message associated with the SQLCODE of the SQL statement that
failed. Follow the action suggested by that message.

For an invalid package, the REBIND command can be used to recreate the
error or to explicitly validate the package once the cause of the error
has been resolved.

For a failure while regenerating a view, the name of the view that
failed is recorded in the administration notification log. The failing
view can be dropped or a change made to the statement or command that
caused the view regeneration.

Federated system users: If the statement that failed was dynamically
prepared in a pass-through session, open another pass-through session,
write and prepare the statement again, and execute it while the session
is still open.

sqlcode: -727

sqlstate: 56098

But because the error doesn't return the error parameters I can't figure out
on what object the error is occuring. Any thoughts?

There is no problem when I'm logged in to CC with DBA access. Only with a
user that has less permissions, so I assume it's some sort of permission
issue for that user.

Thanks,
Frank

Jun 27 '08 #1
0 2157

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sonu K Mehrotra | last post by:
mysql server is <172.16.27.39> running on Linux 9.1 I have installed mysql control center (client GUI) on 172.16.27.252 running on Windows 2000 advanced server The machines are connected in...
6
by: Franco Lombardo | last post by:
Hi all, I'm running DB2 8.1.5 on Windows 2000 professional SP4. When I try to start Control Center, I see the splash screen for a while, then it closes and nothing else happens. It happens...
10
by: Andy K | last post by:
Hi again , I've been trying to connect to a distant database with my control center on WinXp . I'm using a personnal edition DB2 v8.1.9.700 for the control center on WinXp. I've setup a...
11
by: trinitypete | last post by:
Hi all, I have a user control that uses control literal to build a heading with a link, and a div containing links below. As the link heading is hit, I want to change the style of the div,...
2
by: Chris Fink | last post by:
This should be relatively simple but I am unable to find an asp:button tag in a datalist footer. I have tried it numerous ways including the FindControl method from the many events that the...
11
by: Hoku | last post by:
I am using dual monitors on a dual head ATI AGP4x video card. I installed the Nov 11 2005 release of ATI's catalyst control center with Hydravision to manage the dual monitor setup. I recently...
4
by: gsb58 | last post by:
Hi! On a form I have a calendar. The form is rezised to 1024x768 (Don't worry - this is a training case) when loaded. Now I want to center the calendar on the form so that its edges are...
2
by: mobiletornado | last post by:
I am using visual studio .net 2003 enterprize architect. My application test center is version 1.0.536 I am runnign window xp home edition. I have stated a new test. I chose to record a new test...
2
by: forest demon | last post by:
in the VS designer, i can use the Format menu item to align, center in form, etc, etc.... so for example, if i have two or three buttons and some textboxes, i can align, or whatever, using the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.