Oninit® Archive
Results for “onstat -g stm”
RE: Informix: external optimizer directives not working
Hi, just for your info, we fixed this issue: -. I had used the sql syntax text extracted from onstat -g ses output. It seems this command formats the text and the directive gets created with extra spaces, carriage returns, etc. and when the same SQL gests executed it does not m…
sysrstcb
This is an easier way to identify prepared statements (and session IDs) referencing a particular table, which I expect is what you need: SELECT * FROM sysconblock WHERE LOWER(cbl_stmt) MATCHES '*table-name*' Regards, Doug Lawry…
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
Hello Do you have by chance RALLOC_MODE POOL in the onconfig? This setting changes the allocation of shared memory pools What means you will see additional pools. Normally such memory is allocated in other pools (e.g session pool) So can be that this is high number is not pointin…
Large memory segment vs smaller ones
Hello an Assert Failed are often caused by an internal corruption in the shared memory. Caused by some action (e.g. a select, a need of more shared memory, a cleanup of something, a sort ....). Some time later some other session is hitting the memory corruption and throwing the A…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
C-UDR reusage of prepared statement
The mi_prepare() function does not allocate a new statement descriptor from memory-duration pools On 6/25/2024 4:39 AM, Andreas Legner via IBM TechXchange Community wrote: 010001904ec3ed2d-6aaae585-1e32-482a-b355-42348c759a7c-000000@email.amazonses.com"> Hi Pete…
Memory issue on Informix primary server
Hi, You can either run "onstat -g mem" every few minutes from cron to hope to catch it. Or you can update the case statement in the alarmprogram so that when an extra shared memory segment is added it runs "onstat -g mem" to a file to you can see what is using the memory. You can…
flags (onstat -g ses)
John: So, the smoking gun may be the "PDQ is set to 10%". That may cause sessions to go into a wait state that is not documented by any flags in onstat. The onstat -g mgm report will tell the tale. Here's the thing to remember about PDQ. It controls the percentage of PDQ resource…
monitoring session memory
IDS 11.70FC4 I seem to be having some serious session memory leaks. Sadly it is intermittent. All the clients are using DBD::Informix (perl) to access the database. I have to run onmode -F quite frequently and restart some of the clients so it looks like something is not being cl…
ESQL/C: DESCRIBE, DESCRIBE OUTPUT and DESCRIBE INPUT
Hello, While playing with DESCRIBE INPUT and DESCRIBE OUTPUT, I have discovered some strange memory leak when freeing the sqlda structure allocated by DESCRIBE INPUT... Seems to depend on the order of the FREE statements: This happens when I DECLARE a cursor for a PREPAREd statem…
RE: How to get open cursors by session
Check out the s yssdblock table in sysmaster. The sdb_name column contains the cursor name which you should be able to relate back to the application: > select * from syssdblock; sdb_sessionid 71 sdb_sdbno 0 sdb_iscurrent Y sdb_name slctcur sdb_id…
How to get open cursors by session
Hi, I was investigating about how to get current opened (active) cursors in server. Preferably, getting a SQL query to sysmaster will be the best but also onstat command would work. Reason for this question is to make a quality assurance of a program and we're not sure this progr…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
for sysmaster masters:syssqlstat Vs previous query
Hi Eric. If that app is running prepared statements, you should be probably able to see something in sysconblock. Have you tried? HTH Best regards Alexandre Marini…
ONMODE -Y on the client side
"onmode -Y" turns on SET EXPLAIN for given session. "onmode" isn't distributed with the client software and connects to an instance's shared memory so is strictly server only. Presumably you don't control what the client is doing otherwise the obvious thing to do would be to run…
SHARED MEMORY ALLOCATION
Note that DS_NONPDQ_QUERY_MEM is limited to 25% of DS_TOTAL_MEMORY. Neither DS_TOTAL_MEMORY nor DS_NONPDQ_QUERY_MEM are carved permanently out of SHMVIRTSIZE but are allocated from there as needed and released. I can alleviate Benjamin's fears. The total of DS_NONPDQ_QUERY_MEM u…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Issue with statistics
What does this onstat -g ses show me? I am seeing session id's, total memory, used memory and the 20 or so lines that shows all have dynamic explain = off. Also the onstat -g sql says unable to open input file sql. Not sure what these were for...…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
too many statements in memory
You should run something like: onstat -g stm SID | awk '{for (a=3;a<=NF;a++) {printf "%s ",$a};printf "\\ "}' | sort | uniq -c | sort -nk 1 If you see a lot of repetitions for a single statement (or a few) then the code is wrong and they have to change it. It really won't matte…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
track session of memory segment
Hello, i have informix 11.50FC8GE server in there there are some memory segments so i want to track particulate user session or process for those memory segment. what is the best way to track them. memory segment like follows. IBM Informix Dynamic Server Version 11.50.FC8GE -- …
opentable memory leak
I recently upgraded to 12.10.FC5WE on Linux and appear to be running into IT03031: OPENTABLE MEMORY OF A SESSION CAN GROW AND CAN LEAD TO OVERLY LARGER MEMORY CONSUMPTION AND POSSIBLY TO MEMORY FRAGMENTATION or possibly IT03000 as I've also seen it referenced. onstat -g ses <s…
RFE request for session details during virtual shm
I'm not sure if I completely understand the request. But apparently you want the SID of the session that caused the new memory segment to be added. But this does not necessarily means that that session is the one consuming more memory. Specially in an high activity system. Let's …
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Maximum number of sesions
IDS version = 11.70.FC7GE OS = HP UX 9000/800 11605882 Hi All, We have on average 800 users and 2600 sessions running per day. I would like to know if there is a limit on the number of users/sessions on IDS 11.70.FC7GE ? How can I check that the message portion of the memory a…
Using SQLTRACE
This saves a snapshot of prepared statements from "sysmaster:sysconblock" at specified intervals. It will therefore not show how many times a statement is executed or when, and will miss some statements entirely. It can only show estimated cost and not actual costs or run time. H…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
shared memory full
If one of your sessions allocated too much locks you may have seen a lock table growth. This will consume memory (sometimes a lot) but will leave evidences in online.log Your session may have got a lot of prepared statements that were not freed. Most times bad Java coding is the…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Help on jboss memory usage for persistant sessions
Hello, my friend. Answering your questions: By regular sessions, I mean comparing lower memory usage to the highest memory usage ones: 1) JBOSS regular memory session reports: Total session memory: 77824 (onstat -g ses) onstat -g afr: shows 106 lines of output onstat -g stm: sh…
Temporary tables called th_overflow_ffffff
Ok, that means: a) I could review the queries and create indexes for reduce the amount of hash joins. b) I could increase the size the shared memory (SHMVIRTSIZE) so that the majority of hash joins are running in memory. Please tell me if this statements are correct Thanks in a…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Resident memory size vs. Virtual memory size
more sessions = more work = more locks = which means more memory needed for those locks. look in the msg log and you should see "dynamically allocating more locks " (or similiar) if that is the case. But I have to say that 4 gigs is alot so check $ONCONFIG paramater "shmadd" , t…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
prepare error 410
HI, I modified the application from EXEC SQL update rcpf20 set *=(:rcpf20) where rowid=:rowid" to exec sql prepare s2 from "update rcpf20 set *=(:?) where rowid=?" for (;;) { EXEC sql execute s2 using :rcpf20,:rowid } :rcpf20 is a structure. When I execute the program, i…
how to prepare the fetch SQL?
On Tue, Aug 7, 2012 at 10:20 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > Do anybody know how to prepare the fetch SQL? > You can't prepare a FETCH statement. It is a client-side statement, and only server-side statements can be prepared. You can't prepare CONNECT statements, eit…
Limitations in Developer Edition 11.70.FC5
We are planning to use DE in our development and test environment. I am aware of the limitations to CPU VP's, disk and memory as described in http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/. Is there any other limitations ? I believe that I saw a limitatio…
memory used by a session
it would be nice to see what these two users are currently doing: onstat -g ses {session id} onstat -g ses 17499439 Also to see how many current statements this application is using along with how much memory each SQL statement is taking: onstat -g stm {session id} onstat -g…
Table order in joins for best performance.
Does the order of tables in a join statement make a difference for optimum performance and memory management? I heard that the last join should be the largest table.…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Problem with identifying root cause of continual m
original post: Hi to all, I have a problem with identifying root cause of continual memory consuming by db-sessions. Our OS: AIX Our IDS: 11.70.FC3 Application layer is Weblogic Application server and the interface is JDBC driver. During investigating this issue I was able to i…
how many concurrent users access informix
Hi, AFAIK Innovator C is not limited to a number of sessions or used harddisk space, just by memory (2GB max) and processor cores (and some functionality like PDQ etc.). In reality, the memory limitation might be a user limitation, depending on your buffer sizing (how much memor…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Re: 11.70.tc1IE limits
Thanks, Doug. I will try that Monday. Sorry about this email, but Windows Mail says I don’t have a Simple Mapi-compatible mailer installed, so I cannot just hit “reply all” . Hi Bill. There is more than one issue here, but mostly you need to work out what the memory leak is. C…
ids 11.70.TC1IE limits
Hi Bill. There is more than one issue here, but mostly you need to work out what the memory leak is. Can you watch "onstat -g ses" and "onstat -g mem" to spot which session or shared memory pool is growing? If it's a session, use "onstat -g ses session-id" to find out the detail…
Cannot kill session (onmode -z doesn't work)
We are now running into the same problem again. I tried the "onstat -g stm SID", but it comes back with nothing. mtnx87.mtn.co.za:/ # onstat -g stm 24416 IBM Informix Dynamic Server Version 10.00.FC8XF -- On-Line -- Up 3 days 12:36:09 -- 157286176 Kbytes session 24416 --------…
sqltrace x prepare statements (4GL)
Hi, IFX 11.50 FC8 AIX 6.1 + 4GL 7.32 (with CSDK 3.50 FC8) I have a 4GL program, executing a simple foreach over a table with 1.5mi records code 1) If this foreach running as dummy, without any code inside , take 1 minute to run: declare xyz cursor select ...from xyz foreach x…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Help on dbworker threads (memory not freed)
Hello friends. Informix 11.50.FC6W1X7 on linux_64 redhat based machine. Our machine is running up 52 days, and I have this doubt: our dbscheduller (dbworker) sessions are using too much memory, without running anything right now: onstat -g ath |grep dbWorker 106 1628a5b50 15fb7…
Instance Crashed !!
The resident segment is mostly the buffer cache, so that determines its size. The virtual segments contain the smaller caches like the dictionary cache etc. And working memory for sessions to use. There is no ratio between the two. Art On Jan 21, 2011 11:12 AM, "SHAHZAD SALAM KA…
out of virtual shared memory
We are running IDS 11.5FC6 on Solaris. Today memory consumption started increasing on our production database and within few minutes it reached the shmmax limit. We found message in online log "out of virtual shared memory", so we restarted the database instance. There were a lot…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
SQLException on memory allocation
This generally means the application is not closing the cursor or prepare statement. If the is a java program, please make sure the garbage collector is not responsible for free the cursors/statements. You can automatically force a free on a close, by setting the application env…
Memory Management
"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message news:mailman.491.1283968374.1071.informix-list@iiug.org... Fernando, >> More memory means you can do more things and yes... 2000 concurrent >> sessions could be considered small. ;-) With more memory you can do things l…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Re: Dynamically allocated new virtual shared memory segment repeatdly
hmm long shot.. you could look at onstat -g ses and see who eats memory; then you could do a onstat -g ses <sid> in the past a huge ralloc was most of the time caused by not closeing/ freeing cursors/statements. if i recall correctly you can do a onstat -g stm <sid> which displa…
IDS 10.00 maximum concurrent sessions
Hi Art, Thanks for your quick respose. We are using shared memory connections . Also noted that there is no limit for the concurrent sessions. My issue is i want to control the number of sessions, i.e. maximum number of concurrent sessions. Say for ex i dont want the maximum num…
Statement Cache & Web Logic
On Feb 1, 10:23 am, Tom Lehr <tomc...@gmail.com> wrote: > Hello > A developer is asking about Web Logic and their documentation and how > that relates to informix and the database statement caching. here is > what we have set: > > # Turn the sql caching on > onmode -W STMT_CACHE_…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
SQL -406 Memory allocation failed.
-406 Memory allocation failed. Something in the current statement required the allocation of memory for data storage, but the memory was not available. Several things can cause this error. For example, your application has a memory leak, you are asking for more resources than th…
Recommended Memory per Session
I used to know where to obtain/calculate this .... sadly, I am having problems calculating my own memory requirements nowadays. :) Anyone know where this can be obtained or how it is calculated? Thanks in advance. Clifton ______________________________________________________…
how to check what table is being accessed
Hi, onstat -g ses 0 (the argument 0 requires IDS version 9 or higher) will show all connected sessions with a lot of information, including user name, database name, active SQL/last parsed SQL and others. With onstat -g stm 0 you might see more SQL statements (SQL session cache…
Java prepared statement
Hi, there are two cases Case-1 & Case-2; Case-1: inserts/updates are prepared statements Case-2: inserts/updates are queries without parameter marker Now if STMT_CACHE is enabled then in what case memory usage will be high for a sessions. regards, Kamran…
onstat shows memory held by finished sessions
Hi, I am using IDS 11.50 on HP-UX 11. The onstat -g ses shows the sessions which are complete. For example the program is finished but still the onstat -g ses shows insert session. The session details show it as "current SQL statement". Is the session still holding the memory? I…
How do you determine session age?
Try with 'onstat -g ntt' -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Smaby Sent: viernes, 21 de agosto de 2009 10:38 a.m. To: ids@iiug.org Subject: How do you determine session age? [16764] Good morning, I hope this…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
usage of PREPARE in SPL
Art, Thanks. I worked it out by a different approach. But I'm still trying to figure out what is the value of having a PREPARE statement available in SPL?…
Sessions Memory Usage
Hello, I'm trying to get the amount of memory usage for sessions like "Total Memory" and "Used Memory" from the onstat -g ses command, can I get this information from the sysmaster? Thanks in advance for your help.…
Open SQL Statements
Take a look at onstat -g stm {optional session id} This will show you each prepared statement and how much memory it consu= mes. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) |------------> | From: | |------------>…
trying to free virtual memory
Hi, We are running more than one instance of Informix IDS on single machine. We observed that there are some issues with our application that with the passage of time idle sessions keep on increasing (idle for days doing nothing). The virtual memory also keep on increasing. If we…
Auto monitoring and logging of locks
Below are some details of a lock. There a session found acquiring 69190 locks. Can we found what locks its holding like information about breakdown that how many locks are on table1, table2 etc? Is there a way to log the statements possesing locks on a certain object(row or table…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Virtual Memory Segment Filling Up
Hi Prasun, as Martin already said, start with "onstat -g ses". onstat -g ses | sort -nrk 7 | head This will tell you your top sessions sorted by their memory usage. You probably have prepared statements not closed in those sessions. To check for that pick the top one session I…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Meaning of DS_NONPDQ_QUERY_MEM
Dear All.... http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp I refered to this document of IDS 11.1 , and found the following statements: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is a available for a query that is…
Informix allocating shared segments
How about output from: onstat -g seg ipcs -m (as 'root') -- Bob -------------- Original message -------------- From: "Emiliano Romero" <eromero@sitrack.com> > Sorry for the low info provided. I use IBM Informix Dynamic Server > Version 10.00.FC6 in a Linux box (Gentoo actuall…
Re: Wanna try SolidDB for IDS?
"Ian Michael Gumby" <im_gumby@hotmail.com> wrote: > When you talk about an in-memory database, you are creating a db that > has fairly fast response time. But the risk is that if there is a > power failure, there is going to be data loss. Your statement is misleading, and your …
IDS 7.31.UD8 Running out of memory
Hi everyone, I'm running IDS 7.31.UD8 on AIX 5.1 ML9 and it seems that whenever I reach somewhere around 2600 informix sessions , IDS runs out of memory and can not start any further sesssions. This causes the ERP application to lock up and many orphaned sessions are left in Inf…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Urgent help requested
Just on case somebody is reading the list mail in this moment.... Solaris 9 Sparc... IDS 9.40 FC2 ... One session issue a query that requested huge memory ammounts. Now anybody can't work with the database.. I tried to kill process onmode -z pid, shutdown instance onmode -u, onm…
Do You Use blobspaces?
> It sounds like that you have a very large column in a table and you want to store it as a blob in an effort to shrink the table size. Yes, that part of it. But according to the doc, there are benefits to storing a text/byte column in a blobspace as opposed to a normal dbspace …
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
DYnamic SQL
On Tue, May 20, 2008 at 6:07 PM, Rajan S <srajan2@cox.net> wrote: > Hi guys: > Could anyone have a good working example of a ESQL program that would > dymamically execute a stored procedure using SQLDA with parameters known > only at the run time. > If you have could you please p…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
help ! How can capture the SQL?
Shan, try running this: select tabname, seqscans, npused, seqscans*npused from sysptprof, syspthdr where sysptprof.partnum = syspthdr.partnum and ( seqscans * npused ) > 10000 Obviously the 10000 can be any value you like. It will tell you the names of the tables at least. You…
Virtual segment usage - now I'm confused.....
OK we managed to catch the process that blew up our Virtual portion. It's a remote PHP/javascript application that establishes a connection via jdbc to the database (9.30HC5 on HP/UX 11i). We managed to fire off an onstat -a and having used onstat -g mem to get the sid, found the…
Using STMT_CACHE
Hi These are the advantages of using SQL Statement Cache feature. 1)Reduced memory consumption because query data structures are shared among different users. 2)Faster query processing time because for statements present in the cache, the database server can skip parsing and opti…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Memory leak on AIX 5.3
Reading through this my impression is that this APAR talks about authorization functionality and the msc VP growing in size. What Mirek described looks like Informix session memory is growing rapidly within IDS shared memory - if I don't misinterpret what he's saying about the '…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Informix Prepared Statements
lisa_0801@yahoo.com said: > I'm trying to create the below sp in informix but i'm getting a syntax > error which points to the prepare statement. Please help! > > CREATE PROCEDURE test() > > DEFINE sSQL CHAR (100); > > LET sSQL = "select * from test"; > > PREPARE STATEMENT1 FROM…
Informix Prepared Statements
I'm trying to create the below sp in informix but i'm getting a syntax error which points to the prepare statement. Please help! CREATE PROCEDURE test() DEFINE sSQL CHAR (100); LET sSQL = "select * from test"; PREPARE STATEMENT1 FROM sSQL END PROCEDURE;…
Re: Bizarre sysmaster/IDS 10 problem
Martin Fuerderer wrote: > you can try to run variations of commands "onstat -g ..." commands, > like options "ses [session id]", "mem ...", "afr ...", "ffr ..." and "ufr > ...". > Also see the usage of the onstat utility. The memory usage doesn't show up as associated with any p…
Re: Anybody seen a very fast wild cat out there?
david@smooth1.co.uk wrote: > Finally the ability to limit the amount of memory used by an > individual session would be nice, again with an alarm). If I have a > server with 64Gb of RAM > and a sessions goes rogue I don't want it allocating >60GB of RAM! > This and other limit…
IDS is busy all the time
Hi Bodgan, Yes, I am sure. The session was started at 09:27, last access was 09:33, which mets the crash timepoint. No locks. According to onstat -g sql, the session does nothing. In onstat -g ses, I can see that the session is not connected to any DB, but has two memory pools. …
identify sql process/syntax that consumes biggest
Hi, Execute onstat -g ses and you will see the memory consumption per session. To see the last sql of a session, call onstat -g sql <sessionid>. To identify which sql in particular leads to the memory usage, is not that easy. It depends on Multiple factors, e.g. if large sorts a…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
FROM TABLE(MULTISET( In HDR
Hello Group, Question regarding executing a statement like the following: SELECT ... FROM TABLE(MULTISET(SELECT What, You, Wanted FROM WhereEver)) It does not seem to work on a read-only server participating in HDR. Flavor is 10.0 UC4 Wondering the following: Why does it not…
IFX_FOLDVIEW
<david@smooth1.co.uk> wrote in message news:1148490861.240140.229170@u72g2000cwu.googlegroups.com... > > > What is this "Virtual Processor Memory Cache"?? > > We have gone from machines with 4Gb of memory to machines with 32Gb > memory hence > we have loads of memory to play with…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
onstat -g sql
Jonathan Actually the manual has both documented. Please explain how these work. I have tried the SECURESTATG and as indicated by the manual this should allow users that have DBA to run onstat. However this is not the case. I have tried with both set and SECURESTATG has no effec…
Re: memory release with fetchall_arrayref
i miss > my $sth = $dbh->prepare($sql); > $sth->execute ; $sth->free sorry wild guess am not into this code; however if you prepare a stmt you should free it somewhere.. in informix check onstat -g ses <sid> if ralloc is big then it's likely that you forget to fre…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
RE: Another IDS Feature Request
Everett Mills wrote: > I wrote: > >>All that I'd want would be the ability to suspend an active session, >>disconnect, reconnect and then awaken the suspended session - exec it, >>iow. So that the session, if you like, goes from cond_wait(netnorm) > > to > >>cond_wait(http_norm)…
Re: Another IDS Feature Request
Madison Pruet said >1) I'd like to have a pre-existing statements and declared cursors so that my application can just attach to them. That's me, I said that. You of course mean pre-existing prepared statements, ready to pass values into. I provided actually syntax that would w…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Shared Memory challenge on AIX 5.1
Hi, normally yes. It mainly depends on your application and user behaviour, how the access pattern looks like for IDS's SHM. But without knwoing the details (would have to be investigated), swapping of IDS's memory most probably means that you are not far away from thrashing. W…
Re: IDS Feature Request List (including potential new requests).
Nice. How does Informix treat it on the server side? I think this is another vote for Shared "Named" Prepared statements. ;-)…
RE: ontape brought the IDS instance down
Hi Keith, Thank you for taking your time to reply to my issue. The server didn't produce any dump file shared memory/session when it crashed. That is the other reason. It simply died. Since I have changed the tape block size back to 512. Regards, KP…
Re: Fw: Informix compilation error
Hi, this is a very general error message. It means that at some point the program wants to access memory that it does not own. Usually this happens when a pointer having an invalid memory address is dereferenced and the wrong memory address is then attempted to access. The easi…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: informix - tool like SQL server profiler
Mitja wrote: > Art S. Kagel wrote: > >> Mitja wrote: >> >>> Hello! >>> >>> Does anybody know is there any tool for informix like Microsoft SQL >>> profiler? >>> >>> I would like to catch currently running sql statements. >> >> >> >> Version and platform would be nice. IDS 9.40 a…
Re: informix - tool like SQL server profiler
Check the manuals, but basically onstat -- (double minus) will list all possible commands. onstat -r 'n' is repeat command every 'n' seconds so onstat -r 5 -g sql will list the sql for all processes every 5 seconds Regards Colin There are 10 types of people in the world, those…
informix - tool like SQL server profiler
Art S. Kagel wrote: > Mitja wrote: > >> Hello! >> >> Does anybody know is there any tool for informix like Microsoft SQL >> profiler? >> >> I would like to catch currently running sql statements. > > > Version and platform would be nice. IDS 9.40 and 10.00 have that > feature, f…
RE: Infomrix -710 errors
Are you re-preparing prepared statements in long-running processes and middleware servers after running update statistics? Often the update stats on an active table will invalidate the query plan computed when a statement is PREPAREd. The next time you try to EXECUTE such a sta…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
set session authorization
sshumilov@gmail.com wrote: > hello everyone! > > just wanted to find out one thing ... :-) > > when you do set session authorization... where do all the rights stay??? > in what tables or views??? it should be somewhere ... set session authorization; does not create any new perm…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: PREPAREd statement optimization
malc_p@btinternet.com wrote: > A query. (4GL 7.20UD8 (both RDS & I4GL), IDS 9.30HC5, HP-UX 11i) > Does anyone know the process whereby the optimizer decides on the best > access path for a statement PREPAREd in 4GL? We've a query here in a > 4GL which is prepared with placemarker…
Re: PREPAREd statement optimization
I can't answer your question, but when your are interested in a solution for your problem... We had a something similar problem: Query with program : slow Query with dbaccess: fast The solution was to run an "update statistics medium for <table>". After that the program was also …
Re: PREPAREd statement optimization
malc_p@btinternet.com said: > Hello? Anybody out there? > Anyone have any clues please? Have I missed something blindingly > obvious? I'm sorry -- I have no idea what you're talking about? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule"…
Re: PREPAREd statement optimization
Hello? Anybody out there? Anyone have any clues please? Have I missed something blindingly obvious? Ta Malc…
PREPAREd statement optimization
A query. (4GL 7.20UD8 (both RDS & I4GL), IDS 9.30HC5, HP-UX 11i) Does anyone know the process whereby the optimizer decides on the best access path for a statement PREPAREd in 4GL? We've a query here in a 4GL which is prepared with placemarkers and opened in a logic loop later in…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: SPL using cursor not closed or freed.
> -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Roy Mercer > Sent: Friday, March 25, 2005 2:10 PM > To: informix-list@iiug.org > Subject: SPL using cursor not closed or freed. > > See the output from onstat -g s…
RE: SPL using cursor not closed or freed.
> -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Roy Mercer > Sent: Friday, March 25, 2005 2:10 PM > To: informix-list@iiug.org > Subject: SPL using cursor not closed or freed. > > See the output from onstat -g s…
SPL using cursor not closed or freed.
See the output from onstat -g stm <sesid> below. We have recently upgraded from 7.30 to 9.40.FC5 and using the onstat -g stm command can see all of the users keep adding to the onstat -g stm. The app was developed using PowerBuilder and uses stored procedures. Why don't the…
SPL using cursor not closed or freed.
See the output from onstat -g stm <sesid> below. We have recently upgraded from 7.30 to 9.40.FC5 and using the onstat -g stm command can see all of the users keep adding to the onstat -g stm. The app was developed using PowerBuilder and uses stored procedures. Why don't the…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: sqlcode 37000 preparing statement with
Does matches with "*" has the same result? J. -----Original Message----- From: muqusun@gmail.com To: informix-list@iiug.org Date: 14 Feb 2005 15:07:34 -0800 Subject: sqlcode 37000 preparing statement with "like" Hi, I am coding with esql and try to feed informix with queries …
sqlcode 37000 preparing statement with "like"
Hi, I am coding with esql and try to feed informix with queries read from a file. The problem is when describing a statement like follows: select firstname from users where last like 'Smith%'; where the "%" is at the end of the pattern, sqlcode would be set to 37000 and fail t…
Server is in an incompatible state
Hi, I am geting this message while executing ontape -a : Server is in an incompatible state or user authentication failed. Program over. Even onstat dosent work shared memory not initialized for INFORMIXSERVER 'sysprod' The client dbaccess works fine and all cleint sessions w…
RE: Session's memory
> -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On > Behalf Of rotor > Subject: RE: Session's memory > > > Hi, rotor (Leonid ?) > Yes, I am. :-) [AS] Nice to see You.. > > > onstat -g afr SESSION_ID > Don't understand what I…
RE: Session's memory
> Hi, rotor (Leonid ?) Yes, I am. :-) > onstat -g afr SESSION_ID Don't understand what I can see here. > There is a chance that that the memory leak is caused by > the server bug... Not sure. This is IDS 7.31.TD6 - from my expirience stable enough. > the application doesn't de…
Re: Session's memory
> your "Current statement name" > is indicating this as the number in your [cursor] "name" keeps an > increasing order. Yes, I see. Does the "Current statement name" is cursor name really? -- ���������� �������� ���� ������������ http://webmail.delfi.lv sending to informix-list…
RE: Session's memory
Hi, rotor (Leonid ?) The first thing to do is to investigate the session's memory structure using onstat -g afr SESSION_ID There is a chance that that the memory leak is caused by the server bug... but I'm quite sure that memory leak is caused by the VERY poor application desi…
Re: Session's memory
rotor wrote: > Hi community! > Who knows in which circumstances server allocates memory for a > session? I have 'onstat -g ses 183 -r 1' output during 10 minutes. I > don't see any criminal there. Except one - memory. It grows up to 400 > Mb per 10 min! 20 sessions like this one…
179: ISAM error: no free disk space for sort
When running update statistics on any column that's part of an index e.g. update statistics high for table detlog(genno); on a table of 33 million rows, under AIX 5 IDS 7.31.UD4, I experience the error 179: ISAM error: no free disk space for sort. This machine is a P series RS60…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
finderr code 406
Greetings! I'm running a large report and seem to be getting a 406 error: -406 Memory allocation failed. Something in the current statement required the allocation of memory for data storage, but the memory was not available. Several things can cause this error. For example,…
Length of SQL statement
Demeis, Tony wrote: > I have a user trying to submit a query on a table with a column > qualification containing 5450 possible values. The user gets the following > error: > > -460 Statement length exceeds maximum. > > Is there an Informix variable that can be modified to increas…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: HPL and PDQ
--0__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462 Content-type: multipart/alternative; Boundary="1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462" --1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462 Content-type: text/plain; charset=US-ASCII Content-tran…
HPL and PDQ
IDS 9.40FC3W2 on HP-UX11.11 I'm running an onpload (HPL) run job which is loading 35m rows to a table then enabling the indexes. The index "enable", which I understand to be an ordinary build in a different jacket, is taking much longer than I'd expect. I can see from the marve…
Catching runnig SQLs
Hi I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? Connections are over TCP and shared memor…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Session memory usage
Hi, does someone know how much memory a user session takes on a Informix database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik…
OLEDB connection job is using a TON of page space
Sound like your oledb program does not close cursors/and or free statements... if you have 9.30 or bigger then find the session and run onstat -g stm <sessionid> this will most likely dump out tonnnnsss of statements... if you have a version < 9.30 then run onstat -g ses <sid> …
Re: JDBC-Problem
When running in a loop , ensure that you are not re-preparing the select statement each time before executing it.…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
RE: PDQ memory / non-PDQ memory
Formally, PDQ memory is not 'reserved' when PDQ is not running. It is accessible to other sessions .... This is theory. In fact, this memory can't be allocated to memory-hungry subsystems, such as buffer cache. If other sessions allocate a lot of memory from the same pool (V se…
Informix tool related question
Rob, if your database is IDS 9.40, you can dynamically turn on sqlexplain with onmode -Y, followed by a onstat -g stm <sessid>. I have not done it, i'm not on 9.4 yet, but i hear that's a feature. by doing that, you wouldn't need the source code recompiled to run with "set explai…
Re: query performance tools
"Richard Kofler" <richard.kofler@chello.at> wrote in message news:40C211D6.35DCC9D7@chello.at... > Give onstat -g stm a try! Huh?…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
RE: JDBC and cursors
> -----Original Message----- > From: rkusenet [SMTP:rkusenet@sympatico.ca] > Sent: Tuesday, April 27, 2004 2:05 PM > To: informix-list@iiug.org > Subject: JDBC and cursors > > > I am debugging memory leak. > > IDS 9.21.UC4 > Solaris 2.6 > > Can anyone explain what happens interna…
JDBC and cursors
I am debugging memory leak. IDS 9.21.UC4 Solaris 2.6 Can anyone explain what happens internally at Informix when a JDBC application does the following:- ResultSet.Close() PreparedStatment.Close() If I am right, ResultSet uses a database cursor internally. So closing a result …
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
Re: informix session memory usage problem
"Yasar Akman" <yasarakman@isnet.net.tr> wrote in message news:daa0f8b6.0404062206.46de2f2d@posting.google.com... > Alexey, > Thank you very much for you reply. > > "onstat -g mem" shows that the biggest pool is res-buff. > the details of the pool is: > > E2:/home/opera->onstat -g…
Re: informix session memory usage problem
Alexey, Thank you very much for you reply. "onstat -g mem" shows that the biggest pool is res-buff. the details of the pool is: E2:/home/opera->onstat -g mem res-buff IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line (Prim) -- Up 1 days 13:33:39 -- 4096000 Kbytes Po…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
informix session memory usage problem
Hi, we have recently upgraded our informix from 9.21 to 9.40. After upgrade informix consumes all machine memory. We have to stop and start informix. We notice that informix session starts with 5 Mbyte memory than it gets bigger and bigger. One of the process goes up to 365,260,…
RE: memory leak in sessions
This is your application requesting more connection memory to the Engine. What is your application written in? We have similar issues with long running jobs (fourjs) and simply need to stop and restart the process withing a couple of days. Find out from Tech Support what rallo…
Re: memory leak in sessions
"scottishpoet" <dryburghj@yahoo.com> wrote in message news:81714288.0403131259.47567580@posting.google.com... > 9.21.UC4?? > > Loads of memory leaks in that one!! > > Latest 9.21 is UC7 and has a load of memory leaks fixed, but 9.21 > stops being supported at the end of June. Ur…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
memory leak in sessions
9.21.UC4?? Loads of memory leaks in that one!! Latest 9.21 is UC7 and has a load of memory leaks fixed, but 9.21 stops being supported at the end of June. Have you tried this with 9.40? "rkusenet" <rkusenet@sympatico.ca> wrote in message news:<c2t81m$210p1k$1@ID-75254.news.un…
session memory thru sysmaster
onstat -g ses 303 gives this information:- session #RSAM total used id user tty pid hostname threads memory memory 303 gui - -1 whflxsnp 1 3682304 3588736 is there a way I can…
RE: 9.40 vs 9.21 performance
"Eric Rowell" <erowell@knology.net> wrote in message news:c1i8nc$495$1@terabinaries.xmission.com... > > Are you running Solaris? HP-UX 11.11 > What is your ONCONFIG settings? Well, I attach it below, but the file is identical between 9.21 and 9.40. > What was memory usage at th…
Sessions and Memory
IDS: 9.21.UC6 Solaris: 8 I've about 10(ish) databases all web based, all accessed via the WebBlade, one query in one of the databases is causing the engine to allocate another segment. How can the query be traced? Cheers -- Paul Watson # Oninit Ltd # G…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
SMI and onstat -g stm
Hi All, We are using IDS 9.30.FC2 on HP-UX. Can anyone point me how to get the same result as onstat -g stm using SMI ? Thanks Jia-Chiy…
drop a column
Fire up dbaccess and run the following sql statement: ALTER TABLE <table_name> DROP <column_name> -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On Behalf Of GANESH RAM Sent: Wednesday, December 03, 2003 4:39 AM To: ids@iiug.org Sub…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Lock Table Overflow - user id XXX, session id XXXXXX
Hi It's mean that all you session take more than 500.000 locks. You problem is to find which program take excessive locks or perhaps you configuration is too less Result of this overflow is : 1) extent of lock table 2) You use more Virtual memory because the extent go in this…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: dynamic SPs
Does anyone have insight into _how_ DBAccess does this so efficiently (splitting and executing the individual statements in a large batch)? Can it be reproduced in ESQL? "Kristofer Andersson" <anderssonk75@hotmail.com> wrote in message news:99ef697d.0311040704.419491e2@posting.g…
Re: Is gradually increasing memory in long running session normal? (Resolved)
dthacker@omnihotels.com (Dave Thacker) wrote in message news:<554c618d.0309041255.4b687882@posting.google.com>... > I've been trying to debug a problem with a constantly running > application that is > experiencing a performance degradation over time. Today I set up a > script t…
Re: My Informix Never free up memory!
steven wrote: > Jonathan Leffler <jleffler@earthlink.net> wrote: >>Your buffers are vastly underconfigured - 50000 would be a starting >>point, and go up from there. > > I skimed through the Informix Performance Guide, it said, that the > BUFFERS should be about 20% - 25% of phy…
My Informix Never free up memory!
Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<84U8b.2850$BS5.1636@newsread4.news.pas.earthlink.net>... > Your buffers are vastly underconfigured - 50000 would be a starting > point, and go up from there. > I skimed through the Informix Performance Guide, it s…
Re: Is gradually increasing memory in long running session normal?
Fernando Ortiz wrote: > Hi Roland: > > In our programs we also FREE the cursor > > let query = "select ..." > prepare query_prep from query > declare query_curs cursor for query_prep > ... open query_curs or foreach query_curs > ... > ... free query_curs > free query_prep…
Re: Is gradually increasing memory in long running session normal?
"Roland Wintgen" <rw@evg.de> wrote in message news:3F586828.2010002@evg.de... > Hi Fernando, > > I changed our programs to prepare lots of heavily used statements > instead of redeclaring the cursors. > > At least in one case it took me several months to identify one prepared > s…
Re: Is gradually increasing memory in long running session normal?
Hi Roland: In our programs we also FREE the cursor let query = "select ..." prepare query_prep from query declare query_curs cursor for query_prep ... open query_curs or foreach query_curs ... ... free query_curs free query_prep I use 4GL RDS 7.30UC7, IDS 9.30UC2, On Re…
Re: Is gradually increasing memory in long running session normal?
Hi Dave: Several months ago one of ours 4GL programs made a lot of DECLARE CURSOR/PREPARE without FREEing them, and yes the memory usage was increasing. In my case I use onstat -g stm to locate the statements prepared, fgrep the source to locate the offending code and adding th…
Is gradually increasing memory in long running session normal?
I've been trying to debug a problem with a constantly running application that is experiencing a performance degradation over time. Today I set up a script to run onstat -g ses every 60 seconds and log the results. One of the things that caught my eye is that this session's mem…
Prepare statement bug
Can anyone give me some hints as to what may be going on here. I've got an old java (1.1.8 with Informix JDBC Driver 1.40.JC2) application talking to a old Informix database (Informix Dynamic Server Version 7.31.UC4). It's been running for years without problems. I'm just tryin…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Re: Mapping a session to an allocation of virtual memory
Zev, Onstat does not query any system tables (I assume you are talking of tables in the sysmaster database). It's the other way round. When you query a sysmaster table, online treats this as a special case and returns information directly from the appropriate shared memory struc…
Re: Mapping a session to an allocation of virtual memory
Thank You Michael. That is what I needed. I didn't gather the output last time but now I know what to do. BTW would you know the system table(s) onstat -g mem is querying? Thank You, Zev Berezin IBM Informix DBA On 30 Jul 2003, at 8:40, Michael Mueller wrote: > Use "onstat -g …
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Re: Mapping a session to an allocation of virtual memory
Use "onstat -g mem" when it happens again. It should show some very large pool. If the pool name in column 1 is a number than this is the session number (use onstat -g ses <num>). But it's possible that the memory was not allocated for a particular session. If you can send me the…
Mapping a session to an allocation of virtual memory
<color><param>0100,0100,0100</param>Hi All, Version: IDS 7.31.UD5 - Tools 7.30.UC5 - Solaris 2.6 Yesterday a process dynamically allocated as much virtual memory as allowed by SHMTOTAL - 48 new allocations in less than a minute! I ran onmode -F and it worked as advert…
Informix profiling / debugging - speed of sql statements ?
"Guido Stepken" <g.stepken@t-online.de> wrote in message news:beonn4$dtp$01$1@news.t-online.com... > Hi out there ! > > After my bad experiences with informix on linux (no KAIO, SMP not > runnning with 9.30) i tried to improve speed on a complex database > . > onstat -u shows all…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
RE: Do I need to monitor unused memory by each session !
Hi, I wouldn't worry too much about the individual sessions. You will soon enough find out if you have a memory leak, ie. your memory doesn't get released and you start running out of memory. Other than that, you can look at the output of "onstat -g seg" to see how many virtua…
Do I need to monitor unused memory by each session !
Hi All, I am a newbie here. We use IDS 7.30 on Tandem C52 ( a UNIX variant ) . Do I need to monitor unused memory ( Total - used ) in each of the sessions. Our software is supposed to run continuously for months. Thanks in advance. Vishwajit.…
RE: Trouble with JDBC/PreparedStatements
To extend Jonathan's answer ... You don't need to keep it in StringBuffer all the time - convert to String for store until after you've actually prepare'd it. initialise() { String prep_statement[ n ] = StringBuffer_prep_statement.toString(); } use_prep_statement( int n ) { …
Trouble with JDBC/PreparedStatements
Frederik Ramm wrote: > I'm using IDS2000 9.21.UC2 for Linux and the Informix JDBC driver. > My program creates 9 "PreparedStatements" upon startup, for later use. > I've noted strange behaviour when using these - a prepared SELECT > that returns only 3 rows when there are 5 in th…
Re: Prepare statement in SPL (thanks)
Hi > http://www.iiug.org/software/index_ORDBMS.html > > The Exec_SQL_UDR() is what you need. absolutely! even much nicer than PREPARE :-) thanks *-pike *----------pike-------------* Instructions for Life in the new millennium (2001>) from the Dalai Lama: * Take into accou…
Re: Prepare statement in SPL
At 11:35 01/01/15 +0100, Pike wrote: I'm sorry very much. It seems to be able to use the Prepare sentence only with ESQL/C. Hereafter, it is an excerpt of the manual. PREPARE Use the PREPARE statement to parse, validate, and generate an execution plan for SQL statements at runti…
Re: Prepare statement in SPL
Hello thanks for responding .. >How about this ? >in SPL > let mytable = "mytable"; > let str = "select max(blah) from " || mytable; > prepare myquery from str; nope, the parser just barfs at the word "prepare". Syntax error (-201). below is the full proc…
Re: Prepare statement in SPL
At 03:06 01/01/15 +0100, Pike wrote: Hi Pike. How about this ? in SPL define str char(256); define mytable char(256); mytable = "mytable" str = "select max(blah) from " || mytable; prepare myquery from str; Regards. >Hi > >If I get it right, below is a valid ESQL statement…
Prepare statement in SPL
Hi If I get it right, below is a valid ESQL statement PREPARE myquery FROM " select max(blah) from ? " ; And a way to use it would be EXECUTE myquery USING "mytable" into :myresults ; The manuals only described it only in ESQL-C, I'm trying to do this in SPL, and some parser …
Shared Memory
Tham Huei Hwan wrote: > > Hi all, > > I need help on how to identify what process and users trying to > allocate more shared memory segments (onstat -g seg) ? I assume you are trying to identify database sessions that are being "virtual memory hogs" (and forcing the server to c…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
-710 trying to alter just-created tables
In article <3A26B483.C2BC85C2@cs.umass.edu>, Matthew Cornell <cornell@cs.umass.edu> wrote: > Hi Folks, > > We're using IDS.2000 9.20.UC1 on RedHat Linux 6.2 from a Java program > and Informix's JDBC driver version 2.11. The program creates a database > (via a connection to the …
RE: How to use more than 2GB share memory in Informix?
Under Solaris 2.6 you can go to 3.75. IDS even supports it (undocumented). With XPS, there is no meaningful memory limitation. You can always attach another coserver to use more memory. I'm using 10+GB for my instance here. cheers j. > -----Original Message----- > From: hann…
Re: How to use more than 2GB share memory in Informix?
From: hanna_shaw@my-deja.com > >I know that there is a limit for share memory in Informix. Our project >just launched recently. We have 400 user sessions right now. They eat >up about 1GB virtual memory. Including 400,000 buffers, the total used >share memory almost gets to the 2…
How to use more than 2GB share memory in Informix?
Hi, I know that there is a limit for share memory in Informix. Our project just launched recently. We have 400 user sessions right now. They eat up about 1GB virtual memory. Including 400,000 buffers, the total used share memory almost gets to the 2GB limit. We will have about 2…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Performance dive over time
This sort of behaviour can occur if there is a memory leak in your application. Additionally, your application would be one that remains connected to the database. Examine the memory used by the sessions, using "onstat -g ses". See if it changes over time. Also examine the memo…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Memory Leak 4GL Debugger 7.30.HC4?
Does anyone know how I can test for memory leak in 4GL debugger? I have 10 modules all of which compile ok. 9 of the modules also work ok with the debugger but 1 module gives a 410 error the first time it is run with the debugger and just hangs the second time. (This worked fin…
pooled connections and prepared statements
I am building an application which will use pooled jdbc connections (either our own pooling or vendor pooling). A question arises about prepared statements in this regard - especially with Informix. One wants to use prepared statements to avoid the overhead of repeatedly running …
Re: Dynamic Server 2000 crash
"smooth1" <smooth1@iclway.co.uk> wrote in message news:399c6620_3@news1.vip.uk.com... > > Check kernel parameters > I am not sure you can have more than 10 shared memory segments > under Linux. Increase SHMVIRtSIZE in your ONCONFIG file. > > Also check the kernel parameters for s…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Sql statement on onstat -g ses command
dyrson.alves@telemigcelular.com.br wrote: > The output below is from a onstat -g ses <id> command. > Note that in the last line the there aren't the > Current SQL statement and the Last parsed SQL statement. > The output just shows > "Changing data structure forced command termi…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
prepares in 9.2
cstefanick@koz.com wrote: > I recently went from 7.22 to 9.2 (big change, I know). In 9.2 > statement cache is used so that similar query plans are shared. Does > this mean that preparing statements is no longer needed in 9.2? > > Sent via Deja.com http://www.deja.com/ > Befor…
RE: LET statement in 4GL
another way is to use report (output report in ....) and format your report not very elegant, but it's work fine Pierre Delandre -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, May 09, 2000 10:43 AM To: informix-list@iiug.org Subject: …
LET statement in 4GL
"Art S. Kagel" wrote: > DarkEmperor wrote: > > > > I want to prepare an SQL statement from > > the following LET: > > LET selstmt = "UNLOAD TO ", DELETE_DIR CLIPPED, gr_item.isn USING > > "<<<<<<<<<<", "dp", " SELECT * FROM process WHERE process.isn = ", > > gr_item.isn > > The …
Insert rows vs. dbload
Freelancer wrote: > Yes, I did the test for PreparedStatement yesterday. But I came up a problem > due to HP-UX 10.20, with Java 1.1.7 (only HP-UX 11.x support Java 1.2.x). > There is a table column is Timestamp data type. In my Java program I > > sql = "INSERT INTO aTable (time…
stored procedure vs. prepared statement
This is a multi-part message in MIME format. ------=_NextPart_000_003C_01BFA865.97F8EE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We're running INFORMIX-OnLine Version 7.12.UC1. We're using Informix as a back-end to our web si…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
Memory problems? Please help.
In article <8aqo1d$4gn$1@newsg1.svr.pol.co.uk>, "Vincent Kennedy" <vkennedy@torex.co.uk> wrote: > I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > > They used to be executed during a shell script containing abotu 30 programs. > However, this was poor for…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Informix SPL
In Informix stored procedures,I want to prepare a sql statement and execute it.I do not want to use ESQL/C.Using Store procedure language, can I do this?…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
linux execute prepared statement
We are trying to use Informix RDS on redhat 6.0. We have versions: rds 7.30uc1 on linux 2.2.5 (rh6.0) against IDS 7.30UC7-1 on the same machine, The problem is that the runner dumps core whenever we attempt to execute a prepared statement. Programs that do not execute prepared s…
Memory leak?
Can anyone out there shed some light on what is going on here? IDS 7.30.UC2 SCO UNIX The applications that we right to connect to the database are connected for weeks to months at a time (they would be connected longer if we were not having the problem I'm about to explain). O…
esql question/tuning?
Dirk Hellmann wrote: > we want to tune our esql-Application. What we have is an codefragment > that build > up an select statement every time (DECLARE/PREPARE/OPEN) because every > select goes on in an different table. But - and this is the idea - what > if we could > 'save' the…
PREPARED inserts?
I would guess that you won't get much performance benefit from preparing insert statements; however there are other benefits to preparing your statements. The biggest benefit is that when you prepare statements, the engine parses and deals with the SQL. When you don't prepare t…
MEMORY & TEMP tables & Stored Procedures
Is there any method to know 1) temp tables (part or full) reside in memory ? 2) how many Stored Procedures are cached in memory for each session ? 3) What other objects reside in memory ? Another problem I have is a session, that connects from VB, does a simple SELECT coun…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: shared memory
Look with "ipcs" (as root) for Shared Memory segments. there will some segments be left from your last session. You have to delete them with "ipcrm -m 1234", where "1234" is the id of the shared memory segment. Klaus Baumgart schrieb: > Beim Start mit oninit erscheint folgende…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Informix w/MS Access97 - Lock Mode
Informix w/MS Access97 - Lock Mode This problem is killin me. SET LOCK MODE TO WAIT; SELECT * FROM item; This query works great in dbaccess, but fails when I run a MS Access97 Pass-through Query. I get an error #555 ___________________________________________________________ …
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Prepare Statement failed- Informix 7.23
Hello, Platform : NT 4.0 Informxi 7.23 Tc-13 When I execute any select or DDL statement from the sqleditor window, I get Error -410. sql statement not prepared or error. What could be the reason? thanks, Mitesh Shah DBA Princeton Softech mshah@princetonsoftech.com…
Prepared statement vs Exec sql insert/update/select
Anytime a statement will be opened repeatedly, as in a loop, the optimizer overhead can be minimized by PREPARING the statement. Since the cost of developing a query plan is spent only once rather than hundreds of times there is a definite savings at runtime. Statements that ar…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
How many memory is a session used ?
Dear ALL : Is there a way to monitor the memory usage of every session ? I mean, how can I determine which session used the maximum amount memory ? Thank for any answer and suggestion. I use Informix Online Dynamic Server 7.22UC3 on HP-UX 10.20. Jung-Hui Cheng cheng@dbtel.com.t…
Error when executing PREPARE statement
This is a multi-part message in MIME format. ------=_NextPart_000_0154_01BEEB28.CA55C370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Consider the following SQL (I already have a temp table created) INSERT INTO t_temp_tab…
May connections share same prepared statement?
Hi, (Sorry if this posting has appeared already.) With ESQL/C in Client SDK 2.20, can I prepare a statement once, and then use it in other connections? In other words, is it possible to prepare a statement with one connection active, and then execute the statement with another co…
Dynamically allocated new shared memory segment ???!!!
Thanks for your reply about this question. But I still do not know how to find WHICH process or session cause this problem. Jung-Hui Cheng cheng@dbtel.com.tw jingker cheng wrote: > Dear ALL : > > Our system appear the following messages in seconds : > > 09:11:02 dynamically a…
esqlc prepared stmt for multiple connections?
Per Frykenvall wrote: > With ESQL/C in Client SDK 2.20, can I prepare a statement once, > and then use it in other connections? In other words, is it > possible to prepare a statement with one connection active, > and then execute the statement with another connection active? No…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Engine behaving strangely
Ok, I think I've fixed the problem, <embarrassing blushes> It was a small validation table which has grown unexpectedly and didn't have the right indexes on it (can you say DOH!) However if anyone could answer my more general questions about BUFFERS and shared memory I w…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Re: running out of Unix Shared memory segments
Adam Richards wrote: > > Here is an interesting problem we encountered. (IDS 7.24) > > I tried to use 'update statistics MEDIUM or HIGN for table(col)' > > Informix said this would help.... but this statement ran on all my table cols > with > indexes caused the engine to go out a…
SQL performance
I have a query regarding something we have noticed using New Era and wondered whether it a bug in New Era or is related to the database. In New Era we have been preparing SQL Select statements with ? placeholders so that we could use the same prepared statement over and over aga…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Memory Used
The values displayed by 'onstat -g ses' for memory used and total memory are just bytes, not Kbytes. You can check that by performing a 'dbaccess sysmaster -', which just opens a connection to the database. onstat -g ses should show about 32000 for the columns total memory and u…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Informix tools - Peculiar problem
Hi guys, We recently moved from I-4GL 7.20 UD4 to 7.20 UE1. Database was moved from 7.22 to 7.31 UC2. We have a subsystem which accepts data on Radio Display Terminals and sends the data to the Informix database through a base station (spread spectrum antenna). We have writt…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: Cursors in Stored Procedures ?
You cannot dynamically prepare a statement within a stored procedure. Harinath Venkata Svenska Handelsbanken New York.…
CLI cannot handle SQL statements bigger than 32k?
It appears that CLI cannot handle an SQL statement bigger than 32k. When trying an ExecDirect, the driver comes back with a 'memory allocation failure (-11061)'. When trying with Execute, the program just disappears without a trace. Is this is known limitation of CLI? Client …
Re: ZERO Impact Performance Monitor for Informix BETA program
> C.1 The functionality for the monitoring of a SHARED MEMORY CONNECTION > when the SQL was issued across the network (e.g. telnet session) will be > available next week. Okay, but wouldn't this also work for a network connection for a telnet session also? What relevance does …
Re: Tracing ALL sql queries - is it possible?
> Your statement of the capabilities of the Sql Power SniFFFer product line > is not quite correct regarding shared memory connections or IPC > connections to an Informix database server. Actually, it was one of your people who verified that it doesn't work for shared memory, st…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Prepared Statements lifespan
Can anyone tell me the lifespan of a prepared statement within an informix database? Reading the 'Freeing Prepared Statements' section of the online docs seems to imply that they'll be resident until explicitly 'freed', (not per connection for example) but can anyone confirm this…
How to get DB Server Date and TIme ?
Frank wrote: > select CURRENT from <tablename> This kinda programming could lead you into trouble if you do this on a big table: The statement goes through every row. (Yeah, done it myself...) ;) As Dennis Pimple wrote, SELECT CURRENT FROM systables WHERE tabid=1; would be the …
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Performance tuning
Does anyone know of a simple way of getting specific information about jobs that are currently running against Informix? I'm looking for something besides onstat (i.e. querying sysmaster,) that will show me the specific sql statements being executed, and something like an sqexpla…
RE: Memory Leak
Rekaish Bhardwaj wrote: > I've encountered this problem before. > I've logged a call with informix who have so far been unable to > reproduce the problem. > > In my case we tracked the leak to cursors declared within our 4ge's. > After each cursor had been used, the free statemen…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Leaky Collections?!
Hi Anyone had problems with memory leaks on collection data? I have a table with a LIST(REAL NOT NULL) and each collection is about 90 numbers. If I do... select a from t ; where a is the collection my session memory usage just rockets! For 5000 rows it goes up to nearly 8 M…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: Calling Stored Proceedures in 4GL
Jackson Thompson wrote: > > pardon a newbie question, > > once I've created a stored procedure that returns a single value, how do > I call it from within 4gl You have to prepare a statement executing the stored procedure and the execute the prepared statement with an INTO claus…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Re: Posting from the Informix-list
About all I can think of to try is checking if there's enough physical memory on the box, and also checking the value of SHMMAX at the engine level. Miguel Angel Zupo Aguirre wrote in message <71sv8g$3gg$1@news.xmission.com>... > >My aplication have an error in one module, after…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: ODS 7.23 on HP-UX - SYSTEM HANG - URGENT
mperrior@my-dejanews.com wrote: > > We are running 3 ODS 7.23 instance on an HP-UX 10.20 2-processor system and > recently we are getting system hangs. The load average shoots up inexorably > whilst the CPU idle times show > 90%! No processes are showing a CPU usage > figure of >…
Order of creation
My notes in the performance tuning manual from class says to create chunks in order to optimize the ways the cleaners clean, but since I am not always building databases, I have forgot the true meaning of this statement. Can someone please refresh my memory? I am on AIX, 7.24, …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Dynamically adding shared memory segs
June Tong schrieb: > > Martin Berns wrote: > > > Mark D. Stock schrieb: > > > > > > Martin Berns wrote: > > > > > > > > Run 'onstat -g ses' and have a look at the 'total memory' column. This may indicate who is using > > > > the additional memory. Remember, sessions don't free me…
Re: Dynamically adding shared memory segs
Bill Weaver schrieb: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? …
Re: Dynamic SQL and Informix Online
Jonathan Leffler wrote: > Tim Friest wrote: > > > > I need to do a bunch of dynamic sql procedures... In the section > > on the prepare statement in the Informix Guide to SQL Syntax book > > there is a paragraph which states: > > <snip> > > > > What kind of memory is this? …
Re: Dynamic SQL and Informix Online
Tim Friest wrote: > > I need to do a bunch of dynamic sql procedures... In the section > on the prepare statement in the Informix Guide to SQL Syntax book > there is a paragraph which states: > > The number of prepared objects in a single program is limited by > the available me…
Dynamic SQL and Informix Online
I need to do a bunch of dynamic sql procedures... In the section on the prepare statement in the Informix Guide to SQL Syntax book there is a paragraph which states: The number of prepared objects in a single program is limited by the available memory. This includes bo…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: memory allocation failed - error 406
Maria Wilson wrote: > > I am trying to load a large (around a gig) msaccess database into an > informix db on a Solaris 2.5 machine with Informix 9.x engine on it. I > am getting this error (406) after several hours of loading. The sql is > not doing anything other than loading…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: onstat -g ses
The configuration file specifies the size of new segments(SHMADD) that'll be allocated in quantums for sessions. A session not necessarily uses up all of it, so you see the two pieces of info. For example, if SHMADD = 8192 (i.e. 8 KB at a time), and your session only used 3K of…
Re: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
RE: execute SPL in 4gl
On Thu, 2 Jul 1998, Sharath Muppala wrote: > Your example is working. I am having Informix 4GL 7.2. I tried it in > the other way using "EXECUTE PROCEDURE ... INTO" . It is giving run time > error with error code 201 pointing the prepare statement line. As it should. > Is…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: ESQL/C vs. SQLDA
Art S. Kagel wrote: > > Stefan Weideneder wrote: > > > > steve53@earthlink.net wrote: > > >[SNIPPED] > > > be carefull when using the old fashioned DESCRIBE method. There > > is no need to do another DESCRIBE after a PREPARE. But Informix > > tells you, that you must free the mem…
Re: ESQL/C vs. SQLDA
Stefan Weideneder wrote: > > steve53@earthlink.net wrote: > >[SNIPPED] > be carefull when using the old fashioned DESCRIBE method. There > is no need to do another DESCRIBE after a PREPARE. But Informix > tells you, that you must free the memory by yourself. So never True. But …
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: ESQLC prepare/execute/free causes memory leak on server
Nick Rumble wrote: > Is anyone aware of problems with ESQL/C (7.?) causing a memory leak in > Online (7.12 -> 7.23) by not freeing memory off following a calling to > $FREE. A typical scenario might be: > > $CHAR col2val[10]; > > for (i = 0; i < 1000; i++) > { > $PREPARE p1 FROM…
Re: ESQLC prepare/execute/free causes memory leak on server
In article <893752477.1758.0.nnrp-04.c2d9cf02@news.demon.co.uk>, rumbln@tetraworld.com says... >I thought that freeing the prepared statement used to declare the cursor, >implicitely freed the cursor ? The manuals, typically, aren't crystal-clear. I have seen code that uses cu…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: -710 repeated
Some follow-up on this issue...I did some deja-news searches, and found the post listed below: -Peter ---------------------------------------------------- Subject: Re: DR cause error -710, help! From: Darshan Joshi <darshan@informix.com> Date: 1996/09/23 Mess…
Re: Prepare a Statement that uses a temporary table?
Georg Winkens wrote: > > Is there a way in ESQL/C to prepare a Statement that uses a temporary > table (e.g. "Select * from Temp_Table ...") if this temporary table is > not already created at prepare time? No there is not. The purpose of preparing a statement is to save the co…
Prepare a Statement that uses a temporary table?
Is there a way in ESQL/C to prepare a Statement that uses a temporary table (e.g. "Select * from Temp_Table ...") if this temporary table is not already created at prepare time? Thanks for your help, Georg…
Re: A question on shared memory usage
In article <34DF0E07.32C6@bloomberg.com>, Art S. Kagel <kagel@bloomberg.com> writes >com@netinfo.moldova.net wrote: >> >> Hello, >> >> In article <34dcff94.500279443@10.209.30.200>, >> jharris@westpac.com.au wrote: >> > >> > Octav, >> > >> > Once Infomrix allocates a shared mem…
Re: A question on shared memory usage
com@netinfo.moldova.net wrote: > > Hello, > > In article <34dcff94.500279443@10.209.30.200>, > jharris@westpac.com.au wrote: > > > > Octav, > > > > Once Infomrix allocates a shared memory segment it is not > > automatically freed when no longer needed. > > > > To make online fr…
ESQL/C System-Descriptor-Area
Hi Informix-Gurus! Does anyone know, whether System-Descriptor-Areas, created by ALLOCATE DESCRIPTOR ... DESCRIBE ... are thread-safe like Cursors and prepared statements, or not? It seems, that they are not thread-safe. Thanks in advance Markus Bschorer mb@alphatron.de…
Re: Problem with prepare
Pretty basic stuff ... If you're going to use the column more than once in a select, you need to assign it an alias. Ex: PREPARE queryXYZ FROM 'select columnA, columnB, columnA newcolumn from testtable' Where newcolumn is the alias for columnA. Now all further references need …
Problem with prepare
Hello, I have a problem with a select-statement in ESQL-C and SE which only appears together with a prepare-Statement. It�s very simple : I have to select a column two times in one select-Statement, as usual. PREPARE queryXYZ FROM 'select columnA, columnB, columnA from testtable…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
free sqlda on Windows NT
Hi all, does anybody have experience using $describe X into my_sqlda ... free(my_sqlda) on Windows NT 4.0 and ESQL/C Version 7.20 with Microsoft MSVC 2.2 or 4.X. The above statements work fine on UNIX-OS, but on NT it crashes in the free-Routine. It seems to me that ESQL alloc…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
4GL Database Feature Question
We have a 4GL application that has been growing in size over the last 6 years, and have a question about fragmentation aware SQL from within the application. Many SQL statements in the 4GL application make reference to program variables in order to return data from the database.…
Re: Session memory grows a lot
We have also a memory 'problem' on solaris Online 7.23.UC1 with the same constellation ( a lot stored procedures, temp tables). I made some tests and came to following conclusion: Whenever a stored procedure is executed the first time the memory grows. Just execute onstat -g op…
Re: Session memory grows a lot
ivan.lopes@rio.rsl.com.br (Ivan Lopes) wrote: >Hi, >I am having serious problems because the session memory grows too much. >Some sessions at the end of the day have 20 Mb!!!! >We use a lot stored procedures, cursors and temp tables, but I don't think this could cause >this HU…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Session memory grows a lot
There is a know memory problem with the Intersolv ODBC driver that ships with Informix. The memory allocated for BLOBS is not freed correctly, and can cause a huge leak. (Much worse if you are using MFC). This problem is under investigation, and will apparently be fixed early …
Re: Session memory grows a lot
This kind of memory allocation can be caused by a "feature" in the INET driver (in a C/S environment). Use of ODBC and INET 5.01.WG1 or higher can cause problems. Try using INET 5.01.WF2 as a possible sol'n. The "feature" was explained to my by an I'fx engineer as a change in …
Re: doubt in onstat -g ses
In article <34983772.6D85@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >bala peddi wrote: >> >> Could anyone please explain me the meaning of the following state of >> the informix session. This the out put of >> >> One of the client application is connecting throu…
Re: Session memory grows a lot
In article <67bm64$og9@cssun.mathcs.emory.edu>, Ivan Lopes <ivan.lopes@rio.rsl.com.br> writes >Hi, > >I am having serious problems because the session memory grows too much. >Some sessions at the end of the day have 20 Mb!!!! > >We use a lot stored procedures, cursors and temp ta…
Re: Session memory grows a lot
Are you closing your cursors and freeing your queries? Also, if you're using stored procedures from within I4GL programs, there's a known memory leak, that I don't think is fixed in 7.23. We had similar problems when accessing via Netscape LiveWire. Make sure that your program…
Session memory grows a lot
Hi, I am having serious problems because the session memory grows too much. Some sessions at the end of the day have 20 Mb!!!! We use a lot stored procedures, cursors and temp tables, but I don't think this could cause this HUGE memory allocation.( Informix 7.23 on DEC Unix 4.0…
Re: Re[2]: Debugging Informix Online Crashes
>I've had it work on HP. You should be able to do onstat -a shmem.xxxxx or >any onstat command against the shmem file. I have. > > Sorry --- Should have been more specific. It *may* not work on H.P. In order for this to work, the address that a shared memory segment attaches …
Re: memory release
You wouldn't by any chance be talking about a "client" connection from a PC would you? There is a known "feature" that affects clients connecting with INET drivers release 5.01.WG1 or higher that prevents the "free cursor" statement from being passed to the engine. The fix is t…
Re: Ready Queue
John, What are your PDQ settings? If they are set too high one session could be consuming all system resources. jim ______________________________ Reply Separator _________________________________ Subject: Ready Queue Author: "John M. Shoemaker" <John_S…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: 4GL error -408
> >Eliott. > Try preparing the select(s) statement first. -Peter…
4GL and Stored Procedures
Is there a simple way to execute a stored procedure with parameters that returns values from a 4GL program. I can prepare a statement with parameters, execute it with. EXECUTE prepare statement USING parameters But cannot obtain the return values. Alternatively I can prepare a …
Re: FREE (cursor)
The normal sequence of statements when using cursors with prepared statements is as follows: PREPARE statement_id (using an sql statement) DECLARE cursor_id FOR statment_id OPEN cursor_id LOOP FETCH cursor_id END LOOP CLOSE cursor_id FREE cursor_id FREE stateent_id When you cl…
Re: FREE (cursor)
The shared memory that is being used is on the server side. This is the issue with later INET drivers. The default behavior is to NOT free up memory. If you program is not going to hang around very long, then it is not an issue. -d At 12:39 AM 8/19/97 +0000, SaTriGuy wrote: …
Re: FREE (cursor)
>Could someone explain the advantages/disadvantages of issuing a CLOSE >cursor statement and then issuing a FREE cursor statement?. IF the cursor >has been prepared, will the FREE statement require it to be prepared >again? > > Basically, the Free statement will free up the "en…
FREE (cursor)
Hello, Could someone explain the advantages/disadvantages of issuing a CLOSE cursor statement and then issuing a FREE cursor statement?. IF the cursor has been prepared, will the FREE statement require it to be prepared again? Thanks for any help! Keith Howard…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
OWS 7.12 (One with SuiteSpot) - Prob with cursors in Stored Proc
SPL DOESN'T ALLOW PREPARE OR DECLARE CURSOR AS FAR AS 7.11 OF INFORMIX OL DYNAMIC SERVER. HAVE A LOOK AT FOREACH STATEMENT IN SPL. HARINATH VENKATA…
Re: PREPARE statement
>Is it possible to 'prepare' a connect statement >(e.g. EXEC SQL PREPARE from 'CONNECT TO stores7') >Our Informix Database (7.11) returns always SQL: -201: I kinda doubt it. The main purpose of the "prepare" is to get the statement into the engine and to save it there. To prep…
Re: PREPARE statement
>From: plassmann.pad@sni.de (Johannes Plassmann) >Date: 24 Jun 1997 10:33:25 GMT >X-Informix-List-Id: <news.39586> > >Is it possible to 'prepare' a connect statement >(e.g. EXEC SQL PREPARE from 'CONNECT TO stores7') >Our Informix Database (7.11) returns always SQL: -201: Syntax …
PREPARE statement
Is it possible to 'prepare' a connect statement (e.g. EXEC SQL PREPARE from 'CONNECT TO stores7') Our Informix Database (7.11) returns always SQL: -201: Syntax error occured also the documentation (Informix Guide to SQL V7.1, Syntax) says in description of command prepare: CONNEC…
Re: Set explain utility
David Williams wrote: > > In article <33A6397D.3519@west.co.za>, "Mark D. Stock" > <marks@west.co.za> writes > > > >If you do not use PREPARE, your statement is parsed and optimised by > >the OPEN. > > > >If you use PREPARE, your statement is parsed by the PREPARE, and > >optimis…
disconnect database
Is it a recommended practice if the sql has connect to the database, and upon completion an explicit disconnect should be issued? We are informed by Informix that if programs are killed off by kill -9 then, resources are not free up (session, connection, memory not clear). And s…
Shared Virtual Memory Usage Question
We have a nice, simple two tier application, with a Powerbuilder based client connecting to a V7.13 engine. New connections start out using very little memory (virtual pool I think) as reported by "onstat -g ses". Then over time it increases, some getting as high at 20+ megab…
Re: session total memory
In article <5m33ov$pj1@cssun.mathcs.emory.edu>, Oscar Goldes <ogolde@impsat1.com.ar> writes >Hello, >With onstat -g ses I find that several processes keep eating up more and >more memory, which seems to be never freed up. They start with several tens >of Kbytes, and keep growing,…
session total memory
Hello, With onstat -g ses I find that several processes keep eating up more and more memory, which seems to be never freed up. They start with several tens of Kbytes, and keep growing, up to 10-15 megabytes as shown in the "total memory and =FCsed memory columns. The only way to…
Re: Memory not getting freedup when the sessions are open
In article <3365459D.1749@mail.tammany.com>, Andrew Simpson <guides@mail.tammany.com> writes > >Reddy Duggempudi wrote: >> >> Hi: >> >> We are running 1.02UC2 newera & Online 7.14UD2 on AIX 4.1.4. >> We have about 30-50 users. Each session sometimes uses upto >> 20MB of memory (s…
Re: Memory not getting freedup when the sessions are open
Carlos Costa e Silva wrote in article ... : :Right now, as our programs have to run both in v5 and v7, we have: : :close wcurs :if version_number >= "7" then : free wcurs :end if :free wsel : : Doing a little correction, when I looked at the code what I have is: close wcurs …
Re: Memory not getting freedup when the sessions are open
Carlos Costa e Silva wrote in article ... : :Right now, as our programs have to run both in v5 and v7, we have: : :close wcurs :if version_number >= "7" then : free wcurs :end if :free wsel : : Doing a little correction, when I looked at the code what I have is: close wcurs …
Re: Memory not getting freedup when the sessions are open
Reddy Duggempudi wrote in article <5k3gd8$g54$1@news13.gte.net>... :Hi: : :We are running 1.02UC2 newera & Online 7.14UD2 on AIX 4.1.4. :We have about 30-50 users. Each session sometimes uses upto :20MB of memory (shown in onstat -g ses). This memory is not :getting freed up. We…
Re: Memory not getting freedup when the sessions are open
Reddy Duggempudi wrote: > > Hi: > > We are running 1.02UC2 newera & Online 7.14UD2 on AIX 4.1.4. > We have about 30-50 users. Each session sometimes uses upto > 20MB of memory (shown in onstat -g ses). This memory is not > getting freed up. We tried onmode -F. But this did not do…
Memory not getting freedup when the sessions are open
Hi: We are running 1.02UC2 newera & Online 7.14UD2 on AIX 4.1.4. We have about 30-50 users. Each session sometimes uses upto 20MB of memory (shown in onstat -g ses). This memory is not getting freed up. We tried onmode -F. But this did not do any good. I heard that Informix kee…
Re: Memory Leak
Venky9970@aol.com wrote: > > Hi, > > We are currently using Informix-Online DSA 7.11 UC1 on Unisys SVR4 1.4 > and are planning to migrate to Online DSA 7.20 UC2. Currently we are > bringing database down and up in our daily batch due to shared memory leak > in previous versions. …
Re: Preparing statements in a stored procedure...
SaTriGuy (satriguy@aol.com) wrote: : The best solution that I can come up with is to create a string variable : in the stored procedure containing the "create table ........" stuff. And : then used the system command to do somthing like: : system echo string_variable_containing…
Re: Preparing statements in a stored procedure...
The best solution that I can come up with is to create a string variable in the stored procedure containing the "create table ........" stuff. And then used the system command to do somthing like: system echo string_variable_containing_create_statement | dbaccess database_name …
Re: Preparing statements in a stored procedure...
Dan Michaelis wrote: > The bottom line is that I need to be able to do this, preferably in a stored procedure. The dynamic naming of the third table table name and > column name is where the problem lies. I'm willing to entertain anything at this point... > > Thanks in advance,…
Preparing statements in a stored procedure...
Folks, let me start this by saying I know I'm trying to do something that I'm not supposed to be able to do. I'm trying to create a table based on table names and column names stored in a data table within my legacy 4GL application. The table that contains the names is in the f…
Re: multi-statement prepare
In article <332c13f3.4090551@gate.idg.no>, Nils Myklebust <Nils.Myklebust@idg.no> writes >Douglas Wilson <dgwilson@gte.net> wrote: > >:I recieved a syntax error on something similar to >:the following sort of prepare: > >Check sqlca.sqlerrd[5] for the character position of the sy…
Re: multi-statement prepare
I stand corrected ------ Subject: Re: multi-statement prepare From: satriguy@aol.com (SaTriGuy) Date: 15 Mar 1997 20:34:49 GMT Message-ID: <19970315203400.PAA26973@ladder01.news.aol.com> I don't think this is a legal syntax. When dbaccess or any other front-end tool gets a "do…
Re: multi-statement prepare
SaTriGuy wrote: > > I don't think this is a legal syntax. The syntax is basically legal. If I remove either the first or the second update statement, then it runs ok. But all three together give a syntax error. Douglas Wilson > let sql_stmt= > "update tbl1 set (col1, col2)= ",…
Re: multi-statement prepare
Douglas Wilson <dgwilson@gte.net> wrote: :I recieved a syntax error on something similar to :the following sort of prepare: Check sqlca.sqlerrd[5] for the character position of the syntax error. That's allways the basis for further analysis. :let sql_stmt= :"update tbl1 set (c…
Re: multi-statement prepare
Douglas Wilson <dgwilson@gte.net> wrote: :I recieved a syntax error on something similar to :the following sort of prepare: Check sqlca.sqlerrd[5] for the character position of the syntax error. That's allways the basis for further analysis. :let sql_stmt= :"update tbl1 set (c…
Re: multi-statement prepare
I don't think this is a legal syntax. When dbaccess or any other front-end tool gets a "double statement" command, it actually generates two dynamic queries. The order of items within the statement is "order independent" in that the optimizer will re-order the "where" clauses u…
multi-statement prepare
I recieved a syntax error on something similar to the following sort of prepare: let sql_stmt= "update tbl1 set (col1, col2)= ", "(col1+1, (col3/col4)*100) ", "where col2=? and col4!=0; ", "update tbl1 set (col1, col2)= ", "(col1+1, (col3/20)*100) ", "where col2=? and (col4=0 or…
Re: 4GL Prepare vs Stored Procedure ?
>Suppose I 4GL prepare an insert, or select say. > >Suppose I have a stored procedure which does the same thing. ( The >execution of which I realise I need to Prepare ). > >Is it faster, slower, the same, to use the 4GL prepared insert or call the >stored procedure? The prepared…
Re: 4GL Prepare vs Stored Procedure ?
>Suppose I 4GL prepare an insert, or select say. > >Suppose I have a stored procedure which does the same thing. ( The >execution of which I realise I need to Prepare ). > >Is it faster, slower, the same, to use the 4GL prepared insert or call the >stored procedure? The prepared…
Re: 4GL Prepare vs Stored Procedure ?
>Suppose I 4GL prepare an insert, or select say. > >Suppose I have a stored procedure which does the same thing. ( The >execution of which I realise I need to Prepare ). > >Is it faster, slower, the same, to use the 4GL prepared insert or call the >stored procedure? The prepared…
Re: isqlperl/stored procedures (fwd)
> I don't know, but... > > If the stored procedure does not return values, you should be able to > treat it as just another statement to be executed (prepare & execute). > If it does return rows, then treat it as a SELECT statement (prepare, > declare, open, fetch, close, etc). >…
Re: Prepare, Free statement id's
Jonathan Leffler wrote: > If the original question was 4.1x I4GL running against 5.0x Engine, then > the pre-5 rules do indeed apply. However, since the question mentions the > Version 6 SQL Reference Manual (see the first line of Douglas' text), I > think the post-5 rules appl…
Re: Prepare, Free statement id's
Jonathan Leffler wrote: > If the original question was 4.1x I4GL running against 5.0x Engine, then > the pre-5 rules do indeed apply. However, since the question mentions the > Version 6 SQL Reference Manual (see the first line of Douglas' text), I > think the post-5 rules appl…
Re: Prepare, Free statement id's
}Date: Sat, 25 Jan 97 11:51:03 MET }From: Marco Greco <marcog@linux.ctonline.it> }Subject: Re: Prepare, Free statement id's }To: informix-list@rmy.emory.edu, johnl@informix.com } }Now I am confused. } }The whole point here is that prior to rel 5.0x a "free prepared-statement-id" …
Re: Prepare, Free statement id's
Now I am confused. The whole point here is that prior to rel 5.0x a "free prepared-statement-id" freed both engine and application resources, whereas following that you need both a free cursor (to free engine resources) and a free prepared-statement-id (to free tool/application …
Re: Prepare, Free statement id's
>From: Douglas Wilson <dgwilson@gte.net> >Date: Wed, 22 Jan 1997 22:54:36 -0800 >X-Informix-List-Id: <news.32903> > >In the V.6 Sql Reference manual, under the description of the "FREE" >command, it says (among other things) that after you free a prepared >statement id, you can't…
Prepare, Free statement id's
In the V.6 Sql Reference manual, under the description of the "FREE" command, it says (among other things) that after you free a prepared statement id, you can't open a cursor that was prepared with that statement id. I've just run across some code (while looking for some myster…
Re: 4gl Quesions (EASY, I hope...)
You cannot prepare a 'LOAD' or 'UNLOAD' statement in a program, correct me if I am wrong.. piyush > > LOAD is an INFORMIX SQL STATEMENT That can be used in dbaccess as well as > prepared in a 4gl program. I have used load to take a flat file and LOAD > it into a TEMP table then…
Re: 4GL err -257: System limit on maximum number of statements exceeded
There is a performance benefeit by having a statement prepared only once and reused. Beside that cursors and statements must be uniquely declared within one program module. So you could have reused id's in different modules. Mariusz Malogrosz Performance Analyst TECSYS Inc. An…
4GL err -257: System limit on maximum number of statements exceeded
Hi, I am trying to keep compatibility with V 5.0 OnLine server in 4GL app, by keeping the limit on prepare & declare stmts., but reducing number of declare stmts. alone did not helped. If I�m not missing something, it should (?) Finderr: -257 System limit on maximum number of…
4GL err -257: System limit on maximum number of statements exceeded
Hi, I am trying to keep compatibility with V 5.0 OnLine server in 4GL app, by keeping the limit on prepare & declare stmts., but reducing number of declare stmts. alone did not helped. If I�m not missing something, it should (?) Finderr: -257 System limit on maximum number of…
Re: HELP I'm in crisis
You need to avoid dynamic shared memory segments on HP at all costs. If your SHMVERTSIZE is 60000, I would suspect that would be enough. However, if your application is leaving a lot of open statements (i.e. not issueing a FREE on a prepared statement or CURSOR) then each user t…
Re: Informix 7.13 "eating" memory
In article <32844747.22509345@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes > >What I know is, that Informix has two different memory management >routines in the OnLine Server. The one which manages the virtual >portion ( 8KB blocks ) and another one for…
Re: Informix 7.13 "eating" memory
Paul Leskinen wrote: > > I was hoping that someone out there has encountered this problem: > > We have an online transaction-processing application that stays resident > and processes financial transactions using Informix. The problem is that > Informix Online keeps allocating m…
Re: PREPAREd statement
Are you sure that the GLOBALS statement is present in the 4GL module where this statement exists? I certainly use this technique in some of my programs and it works. > > First, sorry about my very poor english. > > I have the following problem: > > I need to EXECUTE a PREPAREd …
Re: PREPAREd statement
Note that the second example is more useful than the first if you will be using it more than once in a program. You can prepare it once and execute many times after changing the values in myrec. When a statement is prepared, the server parses the statement to check for syntax a…
Re: PREPAREd statement
Ramiro Rela (rrela@dc.uba.ar) wrote: > I need to EXECUTE a PREPAREd statement from a string like > "UPDATE mytable > SET (first, second, third, fourth) = (myrec.first, myrec.second, > myrec.third, myrec.fourth) > Beeing 'myrec' a p…
Re: PREPAREd statement
In <32540EED.61C7@luminous-chao.com> Christopher Sharrer <chris@luminous-chao.com> writes: >Ramiro Rela wrote: >> >> First, sorry about my very poor english. At least you have a second language. In Australia, most of us are barely able to speak just the one. >> >> I have the f…
Re: PREPAREd statement
Ramiro Rela wrote: > > First, sorry about my very poor english. > > I have the following problem: > > I need to EXECUTE a PREPAREd statement from a string like > > "UPDATE mytable > SET (first, second, third, fourth) = (myrec.first, myrec.second, > …
PREPAREd statement
First, sorry about my very poor english. I have the following problem: I need to EXECUTE a PREPAREd statement from a string like "UPDATE mytable SET (first, second, third, fourth) = (myrec.first, myrec.second, myrec.third, myrec.fo…
Re: LOAD statement in ESQL
Frank660 (frank660@aol.com) wrote: > >Is there any special syntax for a LOAD statement in ESQL? I am using the > >exact ISQL LOAD statement from within an ESQL program and I get a syntax > >error. > I could be outdated on this, but last time I checked there was no LOAD > statem…
Informix-CLI 5.0/5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix-CLI 5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix-CLI 5.0/5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix-CLI 5.0/5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
4GL err -257: System limit on maximum number of statements exceeded
Hi, I am trying to keep compatibility with V 5.0 OnLine server in 4GL app, by keeping the limit on prepare & declare stmts., but reducing number of declare stmts. alone did not helped. If I�m not missing something, it should (?) Finderr: -257 System limit on maximum number of…
Calling C function from 4GL
I would like to have my C function resident in memory instead of the "RUN" command. As a result, I am unfamiliar how to construct a "CALL" statement from 4GL to refer to the function along with its arguments. If I my current 4GL statement is: RUN "network /export/C10755627 17…
Re: Preparing an unload statement
Apostolos Varnas (tvarnas@compulink.gr) wrote: : Craig Ostrom wrote: : > : > As Online 5 does not have a table-level backup facility, I am writing one in : > 4gl. Problem is, I get a syntax error when trying to prepare the unload : > statement for subsequent execution. The stat…
Re: Preparing an unload statement
costrom@solair1.inter.NL.net (Craig Ostrom) wrote: >As Online 5 does not have a table-level backup facility, I am writing one in >4gl. Problem is, I get a syntax error when trying to prepare the unload >statement for subsequent execution. The statement is: > unload to "ae.unl"…
Re: Preparing an unload statement
Craig Ostrom wrote: > > As Online 5 does not have a table-level backup facility, I am writing one in > 4gl. Problem is, I get a syntax error when trying to prepare the unload > statement for subsequent execution. The statement is: > unload to "ae.unl" select * from ae; …
Re: Preparing an unload statement
Craig Ostrom (costrom@solair1.inter.NL.net) wrote: : As Online 5 does not have a table-level backup facility, I am writing one in : 4gl. Problem is, I get a syntax error when trying to prepare the unload : statement for subsequent execution. The statement is: : unload to "ae.u…
Preparing an unload statement
As Online 5 does not have a table-level backup facility, I am writing one in 4gl. Problem is, I get a syntax error when trying to prepare the unload statement for subsequent execution. The statement is: unload to "ae.unl" select * from ae; This works in isql but not in 4gl. D…
Re: Prepared SQL Statements and Performance
In article <4fptn2$1kh@spectator.cris.com> Dbauer@cris.com "Danni Bauer" writes: > brent@hypercom.co.nz (Brent Jackson) wrote: > > >Sally Woolrich <Sally@excelsis.demon.co.uk> wrote: > > >>I have often seen code where cursors are declared within loops so > >>the same cursor is d…
Re: Prepared SQL Statements and Performance
brent@hypercom.co.nz (Brent Jackson) wrote: >Sally Woolrich <Sally@excelsis.demon.co.uk> wrote: >>I have often seen code where cursors are declared within loops so >>the same cursor is declared each time the loop executes. This certainly >>is *highly* inefficient as it should …
Re: Prepared SQL Statements and Performance
Sally Woolrich <Sally@excelsis.demon.co.uk> wrote: >I have often seen code where cursors are declared within loops so >the same cursor is declared each time the loop executes. This certainly >is *highly* inefficient as it should almost *always* be possible to >declare the curso…
Re: Prepared SQL Statements and Performance
In article <4f089t$8b5@vixc> "Michael D. Mabin" <culbin@vixa.voyager.net> writes: >From: "Michael D. Mabin" <culbin@vixa.voyager.net> >Subject: Prepared SQL Statements and Performance >Date: 3 Feb 1996 18:07:57 GMT >The Informix SQL reference manuals state that using a prepared …
Re: Prepared SQL Statements and Performance
In article <4f089t$8b5@vixc> culbin@vixa.voyager.net "Michael D. Mabin" writes: > The Informix SQL reference manuals state that using a prepared SQL statement > together with an > Execute statement makes the SQL more efficient. If this is true, then which > example is more > …
Re: Prepared SQL Statements and Performance
In answer to : "The Informix SQL reference manuals state that using a prepared SQL statement together with an Execute statement makes the SQL more efficient. If this is true, then which example is more efficient: declare cursor1 cursor for select col1, col2, col3 from tab…
Prepared SQL Statements and Performance
The Informix SQL reference manuals state that using a prepared SQL statement together with an Execute statement makes the SQL more efficient. If this is true, then which example is more efficient: declare cursor1 cursor for select col1, col2, col3 from tablea where col1 …
Re: 'ralloc' in onstat -g output
Manoj Samel (manoj@green.baan.nl) wrote: : What does the component 'ralloc' indicates in onstat -g ses < session id > output ? : For what purpose is this memory used ? : This is Informix-Online 7.20 : Thanks for any help : Manoj : (manoj@baan.nl) It's the name of a memory poo…
'ralloc' in onstat -g output
What does the component 'ralloc' indicates in onstat -g ses < session id > output ? For what purpose is this memory used ? This is Informix-Online 7.20 Thanks for any help Manoj (manoj@baan.nl)…
Informix 7.1 on SCO Open Server 5.0
Hi, I tried to install Informix Dynamic Online Server on a system that runs under SCO OpenServer 5.0. The startup of informix ends up in an error due to shared memory allocation. In the logfile there is a statement like a statement like: << shared memory base illegal >> Can som…
Re: Question about Prepared statements.
Great question. Glad you asked. It depends... Please give version information when asking such questions; see the version dependent information in this answer. You may then be able to work out what is going on! Kerry: this material is likely to be the basis for another bit o…
Question about Prepared statements.
How are prepared statement id's defined in ESQL/C? Are they defined as global variables, as local variables, or as global within a source file? I haven't seen anything in the documentation, but I could have sworn that an Informix instructor said that they are global. I have two…
Question about Prepared statements.
How are prepared statement id's defined in ESQL/C? Are they defined as global variables, as local variables, or as global within a source file? I haven't seen anything in the documentation, but I could have sworn that an Informix instructor said that they are global. I have two…
Re: HOW TO PREPARE A LOAD STATEMENT
> Article: 21391 of comp.databases.informix > Path: > cix.compulink.co.uk!news.compulink.co.uk!btnet!newsfeed.internetmci.com! > swrinde!cssun.mathcs.emory.edu!cssun.mathcs.emory.edu!not-for-mail > From: dil@psi.ernet.in (dilip kumar biswal) > Newsgroups: comp.databases.informix …
Re: Still some Memory leaks using Informix SE 5.0
Roger Flattin wrote: > But we still have a remaining memory leak of 64 bytes > struct SQLDA *q_desc; [...] > EXEC SQL describe sqlobj into q_desc; > if(sqlca.sqlcode<0) my_handle_error(); The problem is the describe statement. It allocates memory for the column inform…
Re: HOW TO PREPARE A LOAD STATEMENT
The Load/Unload command have an implied prepare that gets triggered whenever there is a variable in the statement database dbname main define f_txtfile char(10), f_sel char(50) let f_txtfile = "filename.txt" let f_sel = "select * from tabname" unload to f_txtfi…
HOW TO PREPARE A LOAD STATEMENT
Dilip, As mentioned here the LOAD and UNLOAD statements are NOT prepareable A few interesting suggestions though. Here is one more that MAY help Use a shell script and pass in the file names as a parameter {Code segment begins} #!/bin/sh ################################### #…
Re: HOW TO PREPARE A LOAD STATEMENT
U cannot prepare the LOAD statment. Write a 4gl program with a big case statement matching table name and calling the appropriate function. ------------ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. White Plains, NY 226 Westchester Ave | Office…
HOW TO PREPARE A LOAD STATEMENT -Reply
This works let gv_load_string = "Myfile.unl" let fv_tablename = "Mytable" let fv_insert_stmt = "insert into ", fv_tablename load from gv_load_string fv_insert_stmt rgds…
Re: HOW TO PREPARE A LOAD STATEMENT
dilip kumar biswal (dil@psi.ernet.in) wrote: : ATTEMPT : : PREPARE load_stmt FROM "LOAD FROM ? INSERT INTO ?" : RESULT : : Error no 201 encountered. : The mannual also says that it is impossible to prepare a LOAD stmt. That's true. But you can pass a string to the LOAD …
Re: HOW TO PREPARE A LOAD STATEMENT
Oops ... sorry about the aborted message. No, as you demonstrated, and as the manual documented, the LOAD and UNLOAD statements are not preparable. As to work-arounds, you have a variety of options. FUNCTION loadtable(file, table) DEFINE file char(30), table char(18) C…
Re: HOW TO PREPARE A LOAD STATEMENT
No, as you demonstrated, and as the manual documented, the LOAD and UNLOAD statements are not preparable. As to work-arounds, you have a variety of options. FUNCTION loadtable(file char(30), table char(18)) IF table = "table1" THEN LOAD FROM file INSERT INTO Table1…
HOW TO PREPARE A LOAD STATEMENT
Hi Informixusers, May I know from you whether a load/unload statement can be prepared ? ATTEMPT : PREPARE load_stmt FROM "LOAD FROM ? INSERT INTO ?" RESULT : Error no 201 encountered. The mannual also says that it is impossible to prepare a LOAD stmt. The requi…
Static memory Help
Hi all, I've a little question for informix gurus. I would like to know how informix handle the memory for variables. The proble that I have is that I need to use in one of my modules some array of 9999 elements. I declared this arrays after the declaration of globals variable:…
Re: Preparing UPDATE statement in ESQL/C
In article <9510250922.AA16837@dpx.dpx.courier.kiev.ua> bal@dpx.dpx.courier.kiev.ua (Bespaly Alex) writes: >From: bal@dpx.dpx.courier.kiev.ua (Bespaly Alex) >Subject: Preparing UPDATE statement in ESQL/C >Date: 25 Oct 1995 12:46:55 +0200 > Hi, all! > Is there any way…
Preparing UPDATE statement in ESQL/C
Hi, all! Is there any way in ESQL/C after $PREPAREing an UPDATE statement like: "update table1 set (field1,...) = (?,...,?) where <condition>" to find out the next info: - how many columns are being updated; - sqlvar entries for each of them; that is fully …
Re: Cursors without Declare?
=Date: Thu, 5 Oct 1995 10:49:00 -0700 (PDT) =From: Alan Goodman <alan@dssmktg.com> = =>From Jonathan Leffler: => =>One of the weirder parts of the pre-5.00 ESQL/C implementation is that =>there was barely any distinction between cursors and statements. This is =>one of the reaso…
Re: Prepared SQL in 4GL
>Is it quicker to declare the cursor directly >from embedded SQL or by using a prepared SQL statment? If you plan to execute the statement more than once, it is quicker to prepare the statement than not. You'll want to be sure that the statement is organized within your code s…
Preparing Execute Procedure ??
I know that any SQL statement to executed more than once or twice, benefits from having the statement prepared first. Does this also apply to "execute procedure <sp_name>". Are there any benefits or reasons not to prepare an execute procedure statement?? TIA Jon ================…
Informix 4GL for DOS help
I have been having problems with the compiled version of 4GL for DOS. (My client is requiring the use of this package.) I am getting an error -208 (Memory allocation failed during query processing) at different places in my program. It is not very consistent. I even get them …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
Problems with dynamic SQL statements in ESQL/C
Hi, i've some strange problems with dynamic SQL statements in an ESQL/C module. I've files with first line contains table name and table columns, the following lines contains the data rows. I'm reading the first line, create the INSERT statement from the first line, prepare a (…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
New release causes -410
Hi, I recently got version 5.0.5 Informix for my SCO system. I recompiled all my 'C' code now I'm getting a database error -410. The PREPARE statement is okay e.g. $prepare xxx for "update tab1 set tab_name = ? where tab_key = ?"; The DECLARE statement worked e.g. $declare xx…
Re: Difference between CLOSE CURSOR, FREE CURSOR
>|> In ESQL/C for Windows 5.01.WC1 >|> >|> What exactly is the difference between >|> >|> EXEC SQL CLOSE CURSOR :CursorName; >|> >|> and >|> >|> EXEC SQL FREE CURSOR :CursorName; >|> >|> What are the actions taken on client side and as well as on server >|> from the point of res…
Re: setting database at runtime with 4gl
>From: karla@duke.group1.COM (Karla Leibowitz) >Date: Thu, 09 Feb 1995 22:27:45 GMT >X-Informix-List-Id: <news.11428> > >[...] > >Since you cannot prepare a database statement the possibilities have to >be hardcoded. An otherwise excellent answer was marred by this piece of misi…
Re: CLOSE and FREE
> FREE clears the program memory resources as well as engine resources; > you can OPEN a cursor that was previously CLOSEd, but you have to > DECLARE the cursor again if you FREE it. If you FREE a cursor does it FREE the associated prepared statement? And vice versa? What rele…
Does CLOSE DATABASE free all prepared statements?
Hi netters, Does CLOSE DATABASE statement (I use 4GL RDS) free all prepared statements? The reason for the question above is the following: I have a 4GL program that works properly: MAIN -- good version PREPARE creat1 FROM "CREATE DATABASE bt1" EXECUTE creat1 FREE creat1 …
Re: Q:Informix-4GL
>From: "Vadim G. Park" <pivot@taxpol.krasnoyarsk.su> >Subject: Q:Informix-4GL >Date: Thu, 5 Jan 1995 14:14:13 GMT >X-Informix-List-Id: <news.10577> >Is there a trick to PREPARE or something like this Informix-4GL statements >(e.g. LET)? I'm not clear what you are asking. If yo…
Re: Q:Informix-4GL
In article <yGrw_2l8Q1@taxpol>, "Vadim G. Park" <pivot@taxpol.krasnoyarsk.su> says: > >Is there a trick to PREPARE or something like this Informix-4GL statements (e.g. LET)? > Do you want to create dynamic code or what ? Only Database-Statements can be used with PREPARE. See man…
Re: Which is faster? Cursors or Prepared statements?
In article <39cgok$gfd@hudson.lm.com>, Albert E. Whale <aewhale@emi.lm.com> wrote: } 2. I would like to implement the UPDATE cursor (if it's not in the } original SELECT cursor) in either a DECLARED CURSOR FOR UPDATE, } or by EXECUTING a PREPARED SQL statement. } An UPDATE …
Which is faster? Cursors or Prepared statements?
I'm in the midst of reviewing an application which runs slowly and currently does not implement any locking (frustration sets in very quickly!). I want to accomplish two things: 1. Implement either COMMITTED READ isolation or CURSOR STABILITY in the main foreach loop FOR HOL…
Re: -410 Prepare statement failed... BUT NO PREPARE!
}From: kerry@kcbbs.gen.nz (Kerry Sainsbury) }Subject: Re: -410 Prepare statement failed... BUT NO PREPARE! }Date: 7 Oct 94 00:37:39 GMT }X-Informix-List-Id: <news.9131> } }Kerry Sainsbury (kerry@kcbbs.gen.nz) wrote: }: My 4GL-RDS (4.10.UC1) program, running against a SE 4.10.UG1 …
Re: -410 Prepare statement failed... BUT NO PREPARE!
Kerry Sainsbury (kerry@kcbbs.gen.nz) wrote: : My 4GL-RDS (4.10.UC1) program, running against a SE 4.10.UG1 database, : told me today: : "SQL Statement Error -410, Prepare statement failed or was not executed" : The line it barfed on did NOT have a PREPARE statement, only an INS…
-410 Prepare statement failed... BUT NO PREPARE!
My 4GL-RDS (4.10.UC1) program, running against a SE 4.10.UG1 database, told me today: "SQL Statement Error -410, Prepare statement failed or was not executed" The line it barfed on did NOT have a PREPARE statement, only an INSERT. I actually encountered this problem about a ye…
Prepared Stmts Or Sp
I need to optimize some applications already done using ESQL/COBOL and SE 5.0. Most of these applications have a big loop (executed the whole day) with a lot of SQL statements inside. The systems we are using (MX 300 Siemens) have a small amount of memory and suffer of memory con…
Problems when opening cursor for prepared statement twice
Hi all, i've the following problem: I declared a cursor for a prepared select (sums about two field, divided into groups over 4 fields). This cursor is used in function in the following way: OPEN q_cursor USING a,b,c,d,e,f,g FETCH q_cursor INTO x,y,z WHILE STATUS <> NOTFOUND…
Re: Memory fault/Segmention fault executing a SELECT statement
Joerg Spilker (Joerg_Spilker@daolin.fido.de) wrote: : Hi, : i've some serious problems with the following SELECT : SELECT a,b,c,d,e,f FROM t1, t2, t3 : WHERE : joining conditions : INTO TEMP t_tmp WITH NO LOG If you prepare the statement then declare a cursor, …
Memory fault/Segmention fault executing a SELECT statement
Hi, i've some serious problems with the following SELECT SELECT a,b,c,d,e,f FROM t1, t2, t3 WHERE joining conditions INTO TEMP t_tmp WITH NO LOG Fields a-f have a size of about 50 Bytes and according to the joining condition the SELECT should retrieve about 120…
Re: Not calling CLOSE when finished.
ben@syd.au.swissbank.com (Ben Kelley (good guy)) writes: >Informix also told us that we should FREE the cursor after closing >it. I'm not sure how this, or the CLOSEing (or not) of cursors >affects performance. Any ideas anyone? > - Ben Kelley Ben, When a curasor is decla…
Re: limitations on string-spec used in PREPARE
johnl@informix.com (Jonathan Leffler) writes: >Yes, you can prepare statements up to 32k - 1 characters long. If you're >sure you know what you're up to, you can have more than one SQL statement >in the string you prepare, with statements separated by semi-colons. In >general,…
Re: limitations on string-spec used in PREPARE
}From: fthes@sad.hp.com (Francis Small) }Subject: limitations on string-spec used in PREPARE }Date: Mon, 25 Apr 1994 19:48:52 GMT }X-Informix-List-Id: <news.6482> } }When PREPAREing a statement (specifically, a SELECT statement) using a CHAR }variable as the string specification,…
Freeing memory used by sqlda in ESQL/C
When using an sqlda structure in Informix ESQL/C, what is the proper way to free the memory after use? We are using a DESCRIBE statement, which causes Informix to create an sqlda struct with a pointer to an sqlvar_struct array. We allocate a buffer and assign sqldata to point t…
re: Could not write to temp file error
In article <1994Jan25.102415.13827@bilpin.co.uk>, ron@bilpin.co.uk writes: |> >(4GL= -264, ISAM= -107) |> >Could not write to a temporary file. |> >ISAM error: record is locked. |> Thanks for those who responded, but surely 'LOCATE blob_name IN MEMORY' |> means just that, locate …
prepared insert into a synonym
I have a question about preparing an insert into a synonym. I have created a synonym to a table in another database on another platform. When I prepare an insert statement into that synonym I get a "table not found in database" error. The error message contains garbage charact…
Re: [ESQL/C] Segmentation Fault on Prepare
From article <CF7DL3.Erz@walter.bellcore.com>, by johnd@leis.bellcore.com (John Droggitis): > This problem is driving me crazy! I'm getting a segmentation fault > on a prepare statement, for no apparent reason. Any help is greatly > appreciated. > > Platform: Sun IPX, ESQL/C 4…
[ESQL/C] Segmentation Fault on Prepare
This problem is driving me crazy! I'm getting a segmentation fault on a prepare statement, for no apparent reason. Any help is greatly appreciated. Platform: Sun IPX, ESQL/C 4.10.UE1, informix online 5.01.UC1. The code: A vanilla prepare statement, illustrated below (simplif…
Re: SQL syntax checker
In article <27l6d1INNj5f@emory.mathcs.emory.edu> das@trac3000.ueci.com (David Snyder) writes: >Is there any way I can check the syntax of an SQL statement without actually >executing it? Is there some un-documented option to isql that can do this? Either PREPARE or DESCRIBE cou…
Re: SQL syntax checker
There isn't any such option in ISQL, but of course it can be done in ESQL/C or I4GL by preparing a statement but never executing it. Yours, Jonathan Leffler (johnl@godzilla)…
Re: Memory leaks in ESQL/C
This is bug #15191 and is fixed now.The upcoming maintenance release(5.02) will include this bug fix. ram. In article <CBLxon.A4H@world.std.com> smayo@world.std.com (Scott A Mayo) writes: >Does anyone have a definitive list of memory leaks >caused when using ESQL/C? I've writte…
Memory leaks in ESQL/C
Does anyone have a definitive list of memory leaks caused when using ESQL/C? I've written a database server that does lots of prepares and things, and it comes down after a few days because of these leaks. My customer is going to be hopping mad; he wants 24x7xForever runtimes. I…
Re: Help: Memory leak in Deallocate Descriptor
The bug# is 14199. Apparently, the declare and describe statements allocate space which is not de-allocated by the free statement. The problem is in both 4.0 and 5.0. It is a minor problem in 4.X where cursors are static structures declared in the user's code, but an aggravate…
Re: ESQL Memory Leak
The bug# is 14199. Apparently, the declare and describe statements allocate space which is not de-allocated by the free statement. The problem is in both 4.0 and 5.0. It is a minor problem in 4.X where cursors are static structures declared in the user's code, but an aggravate…
Executing .sql files from within 4GL
I am fairly new to Informix 4GL. Reading about the PREPARE statement, which is preprocesses an SQL statement from a string, I wonder if there is a way to preprocess a .sql file, too.…
Informix ESQL/C 'Free' Command
Hello Informix-netters! I have just been perusing the Informix ESQL/C "Programmer's Manual", looking up information on the 'prepare' statement. I then followed a reference from 'execute' to 'free'; I have a question concerning the use of 'free', as the manual is not very explic…
RE: Prepare statement in 4gl
> > > >uunet!bjudev!dwooster, in your mail you wrote: > > [ sample code left out... ] > >> > >> ***** Here is the error I get when I run this ***** > >> > >> Program stopped at "listdb.4gl", line number 17. > >> SQL statement error number -201. > >> A syntax error has occurred. …
RE: Prepare statement in 4gl
>uunet!bjudev!dwooster, in your mail you wrote: > [ sample code left out... ] >> >> ***** Here is the error I get when I run this ***** >> >> Program stopped at "listdb.4gl", line number 17. >> SQL statement error number -201. >> A syntax error has occurred. >> >> ***** Does any…
Re: How to deal with variable table names in 4gl
> From what I understand, this is not easily doable. Case statements in the > code are not acceptable, as the table names will be generated by the > program. Actually, it's probably not too bad. What you need to do is to build the statement in a string, and then use prepare and…