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.SQLTABL ES" (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.sqltable s('','ACCTASGN' ,'AUTO_NUMBERS' ,'','');
SQL0443N Routine "SYSIBM.SQLTABL ES" (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 0 2198 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 LAN
When I open the
start>programs>mysql control center>mysql control center
to register the server
|
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 with "Activity center" (Since I'm running the
italian version, I don't know the
english name of this tool, I mean db2tc.bat).
|
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 node (a distant connection ) in order to reach this
distant database but it doesn't seem to work ... The distant database
|
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, making it visible or not. Yep you guessed it,
expanding tree type functionality.
The header has an onclick event onclick='Doexpandcollapse
|
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 DataList exposes and the result is
always null (I've determined the OnItemDataBound event will not find the
footer controls). I understand that I have to navigate the datalist object
tree, but I feel like it is a guessing game and am hesitant to do it...
| |
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 updated to .NET v2 and run Zone
Alarm Internet Sec Suite 2006 for firewall and av.
When I log off/shut down the computer a dialog box appears as follows:
End program-.NET-BroadcastEventWindow .1.0.5...
Shutdown hangs up and I must click End Now...
|
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
equally far from the upper, right, left and bottom borders of the form.
I understand I must use the location property, am I right?
|
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 in the new test wizard.
chosen script language is vbscript.
when pressing start record a new internet explorer window open.
I go to any url adn browse through its pages, hwoever my actions are not
recorded.
please assist, how can i fix the...
|
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 design GUI.
however, if the forms appearance changes (form size, textbox size,
number of buttons, etc),
due to the users experience, how can i easily do things such as center
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |