473,386 Members | 1,734 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,386 software developers and data experts.

SQL0443N Routine "ALTOBJ"


I am trying to use the new functionality to alter a CHAR(8) to CHAR(10)
.... I figure DB2 now does all the steps automatically ... with my first
try I got the error message below ! I then tried the same operation on
a different BD\Server and it worked! Is their someone that has an idea
on my problem is?

It is an DB2 v8 FP8 on AIX 5.2.
SQL0443N Routine "ALTOBJ" (specific name "") has returned an error SQLSTATE
with diagnostic text "SQL1131 Reason code or token:
-2097151964|*|*|*|*||SEMAPHORE ". SQLSTATE=38553
thanks in advance,

Dany
Nov 12 '05 #1
1 2993
The gui works by driving stored procedure calls under the covers, and
for some reason there was a trap, or else the db2fmp could not start
(possible config issue). Can you run fenced stored procedures in general
on the instance? If so, there should be a t<pid>.<node> file in your
diagnostic directory...if you can post it here, I'll have a look...

Dany wrote:

I am trying to use the new functionality to alter a CHAR(8) to CHAR(10)
... I figure DB2 now does all the steps automatically ... with my first
try I got the error message below ! I then tried the same operation on
a different BD\Server and it worked! Is their someone that has an idea
on my problem is?

It is an DB2 v8 FP8 on AIX 5.2.
SQL0443N Routine "ALTOBJ" (specific name "") has returned an error
SQLSTATE
with diagnostic text "SQL1131 Reason code or token:
-2097151964|*|*|*|*||SEMAPHORE ". SQLSTATE=38553
thanks in advance,

Dany

Nov 12 '05 #2

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

Similar topics

2
by: WantedToBeDBA | last post by:
Hi, I have used the command "GET ROUTINE INTO c:\Thiru\Dec31\locktrack.sar FROM PROCEDURE xxxx.locktrack" It worked well. When i try to move the same to another server with the different...
2
by: jafastinger | last post by:
I have just tried to migrate this stored procedure to another instance. on the same server. I have taken the executeable and copied the file to the new database. Done the binds on the file and...
7
by: Morgan | last post by:
I have read much posts on the argument but no one clearly says if this operation is possible or not. Simply I have a routine which reads from a text file some integer arrays (1 or 2D). The...
1
by: everymn | last post by:
Hi, Supposedly the Alter Routine privilege can be granted at the level of a single routine but I haven't been able to get that to work. I've tried it a number of different ways like: GRANT...
4
by: Troels Arvin | last post by:
Hello, DB2 installation: V. 8.1 LUW, fixpak 10. In certain situations, I get strange error messages. Example: I want to add a NOT NULL constraint to a column. Through db2cc, I try to do what...
1
by: dschat | last post by:
Hi all, I am receiving: 'SQL0443N The Routine "SQLSTATISTICS" returned an error' when I try to connect to a DB2/OS390 table over MS Access. I bound the database with db2cli.lst, ddcsmvs.lst and...
7
by: Bob Darlington | last post by:
I'm using the following routine to call UpdateDiary() - below: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo Form_BeforeUpdate_Error Call UpdateDiary(Me!TenantCounter,...
5
by: Railgunner | last post by:
I am looking for a routine that can evaluate boolean expressions like: IF/ELSE-IF (X1=X2 AND (Y=1 OR Z1=Z2)) IF/ELSE-IF (A$='Y' AND B=1) OR (C=1 AND D>E) etc. I can handle...
2
by: pvong | last post by:
I'm a newbie. I'm using VS2008 & VB.net I have a simple site and each page uses the same sub-routine. I copy and paste to each page and that's no big deal but that can get tiresome. I was...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
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,...

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.