Skip to Content

IBM IDS Developer Forum

Syndicate content
Updated: 3 years 32 weeks ago

Limitation of error code on exception in stored procedure

Mon, 2013-04-01 15:38
Hi,
I have a stored procedure which is calling a java jar using "SYSTEM" command. This jar is returning an error code on exception using the "exit(errorCode)" command.
If the error code is lower than 256, I can find in the stored procedure the correct error code (in a smallint variable). Otherwise, a random error code is returned. Is there any limitation causing this behavior ?
Thanks.

Re: Possible to obtain version of ESQL client API at runtime?

Mon, 2013-03-18 17:07
Hi Andreas,

I think this only can be used to retrieve the version of the database. I'm interested in the version of the client software. CSDK 3.50 or 3.70, etc...

I don't think any form of SQL will work because the server has no knowledge of which client is connecting to it, right?

Re: Possible to obtain version of ESQL client API at runtime?

Wed, 2013-03-13 11:50
Hi,

no API required for this, you can use simple SQL -> check out dbinfo version call.

HTH,
Andreas

Possible to obtain version of ESQL client API at runtime?

Wed, 2013-03-13 11:39
I have a database driver that connects to different versions of an Informix database using ESQL. This is compiled using version 3.50 of the Informix tools. Is it possible to find out, using the ESQL API, which version is being used at runtime?

Got Informix Skills? Want a new job? Informix.jobs

Wed, 2013-03-06 18:11
www.informix.jobs is an online resource designed to connect skilled Informix technical professionals with open positions.

As of this writing there are nearly 250 open positions worldwide that target the Informix skill set.

Robust filtering capabilities let you narrow job openings by location, job title, specific companies -- and even some combination of these criteria.

Check it out and let me know what you think -- expecially if you get hired.

Check out the DB2 Tech Talk series of technical webcasts: http://www-01.ibm.com/software/data/db2/tech-talk.html

Re: Return lock owner when a lock occurs?

Wed, 2013-03-06 17:22
Raj,

Sure. We're using Informix 10.0.

Re: Return lock owner when a lock occurs?

Wed, 2013-03-06 16:55
Could you please provide some details on the data server (and version) that you are using.

Regards,
Raj

Re: Visual Stuido 2012 & IBM IDS 10.0 & IBM Addon for VS 2012

Wed, 2013-03-06 07:07
If you are using the ODBC driver/API from the Informix-CSDK suite, you would not need to configure IDS for DRDA (I assume you meant DRDA in the below email). Also, cdotnet.sql is needed to be run if you would be using the Informix CSDK.NET provider.

Regards,
Raj

Return lock owner when a lock occurs?

Tue, 2013-03-05 19:46
Is there a way to have a query return the owner of a lock along with the error code? I'm using an ASP.NET application and realize that in some cases a lock is unavoidable, but would like to record both the table and the lock owner, not just the table. The idea is to be able to see where the locks are occurring, and if a particular user is repeatedly at fault address that as either a program or behavior issue.

I was able to locate a command that gets partway there (select owner from sysmaster:syslocks) but this returns a lengthy list rather than the owner of the specific row I was attempting to access. What would be ideal is a query that gets the particular lock and returns the logon (rather than the owner) of the person who has locked it. Any suggestions on how to achieve this?

Re: Visual Stuido 2012 & IBM IDS 10.0 & IBM Addon for VS 2012

Tue, 2013-03-05 13:51
If I use IDS 11.70 over odbc(Informix Driver 3.7 64 bit) do you need to start DRDI,cdotnet.sql on IDS 11.70 ?!

Re: Visual Stuido 2012 & IBM IDS 10.0 & IBM Addon for VS 2012

Mon, 2013-03-04 17:22
Hi,

1) Since you have mentioned IDS 10.0, would like to re-iterate that you would need IDS 11.10 or above to use the DB2.NET provider.
Ref: http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0010471.html

2) You might also want to read thru more information on this @ http://www.ibm.com/developerworks/data/library/techarticle/dm-1007dsnetids/index.html
However, please note that going forward it is recommended to use the DB2.NET provider only. The Common IDS.NET provider is deprecated.
Ref: http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/i0060894.html

Let us know if you need any further help/guidance.

Regards,
Raj

Visual Stuido 2012 & IBM IDS 10.0 & IBM Addon for VS 2012

Mon, 2013-03-04 10:50
When i try create database connection in Server Explorer in VS 2012 and push Test Connection
Viusal Studio says :
"ERROR 08001 IBM SQL30081N A communication error has been detected. Communic ation protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.154.128". Communication functio n detecting the error: "recv". Protocol specific error code(s): "", "", "0". SQLSTATE=08001"
anybody resolve this problem ?!

Add dbspace to a Table

Tue, 2013-02-26 14:18
Hi, I have a table that create by this statement:

CREATE TABLE informix.order_bulk (
orderdate DATE NOT NULL,
ordernumber INTEGER NOT NULL
)
FRAGMENT BY RANGE(orderdate) interval(1 units year) store in (orderdbs03, orderdbs04)
partition prv_partition
values < date('2010-01-01') in orderdbs03
EXTENT SIZE 4194219 NEXT SIZE 4194219
LOCK MODE ROW;

The question is, if I want to add another dbspace to the table, how do I do it?

Thanks.

Re: Performance Issues w/ IDS 10.00 Running On VMWare Guest

Fri, 2013-02-22 19:45
Scott,

I'm curious if you were able to resolve the performance issue w/IDS 10 & 11 running on a VMware guest?

We seem to be running into a similar issue, although it only occurs with our backups.

Thanks,

John

Re: "Object reference not set to an instance of an object." with reference.

Mon, 2013-02-18 23:01
I'm not sure why this resolved the issue, but I tried installing the 32bit version (the OS is Server 2008 R2 64bit). The web site worked fine with the dll from the 32bit installation. I'll continue to use this as I'd tried for a couple of days to find a way to make the 64bit version work, but had no luck at all.

"Object reference not set to an instance of an object." with reference.

Mon, 2013-02-18 17:16
I'm having trouble with the 2.90 Informix Client SDK dll with a ASP.NET 2.0 application. I'm getting abandoned mutex errors and the connection intermittently hangs until application pool recycles. I read that this was an issue with that version of the DLL (info here: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.relnotes.doc/tc6_r1/defects.html) and decided to upgrade to 3.50. Unfortunately I'm having trouble adding the new dll to the project.
...

Migrating Informix external routines to DB2

Mon, 2013-02-18 15:11
We have Informix external routines such as alter_java_path, blobexport, etc., that are called by Informix stored procedures.

When considering migration to DB2, does DB2 provide such external routines to match with Informix?

Thanks in advance.

Re: Informix Logical Log

Thu, 2013-02-14 15:57
Hello Ahmed,

try this, as informix:

touch /tmp/ltape_file
chmod 660 /tmp/ltape_file

in onconfig point LTAPEDEV to /tmp/ltape_file

ontape -a

Cheers,
Andreas

Informix Logical Log

Thu, 2013-02-14 15:26
Dear All,

I have a problem with my tape drive and i want to free the logical log file.
In tape parameter the information is as below, please advise me how to take the logical log without tape:

Tape Device [/dev/rStp0 ]

Block Size 20 Kbytes Tape Size 2000000 Kbytes

Log Tape Device [/dev/rStp0 ]

Block Size 20 Kbytes Tape Size 2000000 Kbytes

Regards,
Ahmed
UAE

Re: OS couldn't allocate first resident segment at SHMBASE...

Mon, 2013-02-04 09:40
Pozdrav Mirsad :)
Can you attach here this stuff:
onconfig, sqlhosts, environment (variables), ls -l $INFORMIXDIR/bin, ipcs, /etc/sqlhosts
Regards,
Hrvoje
Copyright