Oninit® Archive
Results for “onstat -g ses”
Current Role
Thanks Art, We'll have to parse the output from onstat -g ses 0. dk…
CHK REQ times suddenly getting very long
Clive: You should do an IIUG TechTalk about managing that many TS devices in Informix! That aside, here are the mechanics of what's happening, maybe it will help you figure out what changed and how to manage that: When a checkpoint is triggered the engine locks a mutex latch that…
Long transaction message discusses a strange number
Hi Jake, for matching " Aborting Long Transaction: tx: 0x1d298fba8 ..." with onstat -x, simply go by this tx address. The tx_id's use, for the user, mainly is to identify the transaction in onlog output, in combination with LSN info (log unique ID + log position within that log).…
New Informix RFE
Please vote for the new RFE I entered. INFX-I-663 Add a session setting to make an index invisible just for the current session and one to reverse that setting. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdb…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Hello Andreas, SMI tables sysmaster:syssqltrace[_*] show me „the past" and are very useful for history analyses and similar. When I am trying to find reasons why systém is „slow" currently, onstat -g ses [Aa]ctive, onstat -g ses [Rr]unning, onstat -g spf and in 14.10 onstat -g to…
Large memory segment vs smaller ones
Dennis: One segment is better than many, so whenever you see several virtual segments it is best to increase SHMVIRTSIZE to incorporate all of that into a single initial segment unless you know that the increase was caused by an unusual event such as a large session that runs say…
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 ------------------------------…
Find table accessing information
Indika: I'm not sure exactly what you are asking, but if Mike's interpretation is correct, then so is his response. In my case I was the only users at the time so it was easy and I knew what database and what table and there was only one session that I had to examine. In the more…
Empty `onstat -g his`
Dennis: Ahh, that's your problem! V11.70 only supported global and user modes. No support yet for database or session. They came later. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com -------------…
IBM TechXchange Livestream: Keynote Research Session
Don't forget to head on over to the ibm.biz/techxchange today at 1:15 PM PDT to hear the Keynote Research Session: Are You Ready for the New Age of AI and Beyond? Speaker Jason Gartner, General Manager and Chief Technology Officer of IBM Client Engineering, Technical Sales and Sk…
onstat -g ses returns "Changing data structure forced command termination"
IT42548 - onstat -g ses <sessid> throws "Changing data structure forced command termination." Thanks Manesh Informix Support ------------------------------ Maneshkumar Sivalingam ------------------------------…
"Physical Logging while in Critical Section" in online log
SangGyu: These messages are informational only in most cases. Checkpoints cannot begin until all sessions have left their critical code sections. A TRUNCATE on a very large table (especially a table with large object columns) can take a while and be in critical sections of code f…
Memory issue on Informix primary server
Amit: Casey's right, it looks like most of the memory allocated is unused. I had missed that. Here's what I think happened. As I said Solaris is VERY SLOW to allocate shared memory, so when a session needed more memory the engine requested another 3GB segment. It took so long tha…
flags (onstat -g ses)
Hello i have some sessions with status "running" and flags "---P---" , not doing or waiting for anything, other sessions are on "---PR--" (reading) what does "---P---" mean please ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
Blocking Checkpoint?
It means that one session experienced a block that lasted less than 0.5sec during that checkpoint. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
dbexport alternative
Henri: First Sergio is using dbimport, so no opportunity to set NOVALIDATE. There is also a problem with just loading the inconsistent data with NOVALIDATE set in the session. You end up with inconsistent data in your database if it would not load without that setting. The purpos…
Checkpoint duration and TXNS Blocked
Celso: Honestly, is anyone besides you noticing these delays of less than 1/1000th second affecting a handful of sessions every five minutes or so? I personally doubt it. Think of it this way, there are 86,400 seconds in a day, if some process were running for 24 hours and every …
monitoring session memory
Clive When investigating a suspected memory leak, I run something like this... for i in $(onstat -g ses | grep -v informix | awk '{print $8":"$5":"$1}' | sort -nr | head -5) do sessID=$(echo $i | cut -d ":" -f 3) onstat -g ses $sessID done >> /tmp/mySessIDs.txt ...and that gives …
Validate backup : archecker –tdsv and CommVault
Signal 15 is SIGTERM - some other process or session killed the onbar session or the underlying archecker session. The bar_debug file might have more detail. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt…
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
Good idea Alex, but I do not control if the queries are prepared or not the question is: how does onstat -g ses sesnumber do to catch the current query and the last parsed query? The info should be somewhere ???…
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…
IDS not writing to online.log
for tid in $(onstat -g ath | egrep "main=5Floop|onmode=5Fmon" | awk '{print= =20 $1}'); do onstat -g stk $tid done Just in case 'crit' should be in any of these outputs, e.g. wait4critex,=20 check onstat -u for any X flags and proceed from there. 'Weeks' you're saying?? No chec…
SQLERR -25580, ISAM -54
Hi, there is no default timeout for sessions, unless you specify a method of disconnecting idle sessions intenally in IBM Informix. You did not mention what version you are, so we cannot tell you if this feature is available for your box. Errors 25580, 27001 are best related to e…
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)…
onstat -g ses - getting the pid
I am running 11.50.FC7 on Solaris 10 Sparc. I have a couple of tables that are locked. I am trying to see what is locking them. I ran onstat -g sql to determine some ids that were associated with the tables. I then ran onstat -g ses to get the pid of the session. For these par…
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…
Finding users locking the database
Hi, I would like to ask how can I find the locking user using the data below Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 347d61a8 0 (700000019709508) 70000001ca75ba8 HDR+X a00157 88305 K- 1 I Normally, I would just onstat -u | grep owner then find the sessio…
Informix integration with DP
Hello all, DBs: IDS 11.70.FC8GE OS: Microsoft Windows Server 2008 R2 with SP2 Media manager: HP DP A.09.00 Backup-type: whole-system backup We have an environment with onbar integration for HPDP A.09.00. Backups/restores are working fine and the integration was configured as f…
RFE request for session details during virtual shm
Hello. I think this might be a very useful RFE, in order to help us to identify abnormal memory session usage, in OLTP systems of high ammount of concurrent sessions (ad-hoc applications). If anyone like, please vote it... https://www.ibm.com/developerworks/rfe/execute?use_case=…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Connection Manager - Sessions Terminate Abnormally
3 Informix instances setup on a HDR pair w/Connection Manager. When I shutdown Connection Manager, I look at the database online logs and see some of the instances successfully de-registering from Connection Manager; whereas others terminate abnormally. What factors would cause t…
F.E. Version
Can anyone tell me what the F.E. Version number maps to with an onstat -g ses? I'm trying to find anything running old drivers from our daemons and can't seem to find any mapping for this anywhere.…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Re: Sysmaster - Tabelas Temporária
On 20/01/14 17:20, Fernando Nunes wrote: > I'm not absolutely sure I got your requirement correctly... You say: > > "a program that runs once .... keep the session alive": > You cannot keep a session alive without a program running. > > Then you say: > "I need to drop temporary t…
Option for audit logging new sessions
Hello. The easiest way to implement it, locally on the server, is through sysdbopen, accessing sysmaster:syssessions table). But you have to implement that in all databases in the instance (or at least, all that you want to control). Regards. Alexandre Marini IBM Informix Cert…
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.…
Engine blocked - Not allowed connections
Hi Art! I was checking the engine log, and the day 31/07/2013 are these errors: "Wed Jul 31 13:05:37 2013 13:05:37 Environment variable CLNT_PAM_CAPABLE is too long (maximum is -1 characters). 13:05:37 File: \\\\tristarm\\\\oslib\\\\osenv.c, line: 1840, status: -5. 13:05:37 En…
SLA Not Working with Kerberos Enabled Service
Dear All, I am running the Informix IDS 11.70 FC4 at AIX 64-bit OS. I have a connection manager, in which I wanted to configure an SLA which should use the DBSERVERALIAS, which is configured with kerberos authentication. My connection manager and DB server are running on the s…
redundant connection manager configuration using H
I'm looking specifically at a MACH11 cluster. So then, if I was to just make things simple and do this: SLA cm_sla1 DBSERVERS=(RSS,primary,HDR) Then the HQ connection manager would realize that the RSS is high latency and avoid giving it out, and the remote site connection man…
Problem with displaying Spanish names ... please h
My customer queries a table in MSSQL Server Management Studio (Windows) which returns a Spanish name, and it appears OK. But when she runs the same query from dbaccess, part of that Spanish name now shows "special" characters which she cannot read well. What do you do to fix this…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
CDC Through .NET 2.0
I can't believe how terrible the IBM documentation is for this. I have managed to connect to the syscdcv1 database, establish a session, enabled full row logging on the table of choice, start capture and finally activate session. However, at the point where I'm trying to read th…
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…
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 …
Informix process reads a lot of pages
I try onstat -g ses and onstat -g ses <session id> but results was: IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line (Prim) -- Up 8 days…
new feature ? set PDQ with onmode....
Hi Cesar. Onmode command (wf or wm) applies only to the instance configuration (dynamically). If you want to set pdqpriority for a specific session, you must do it inside it´s specific sql command (before and after it´s execution). If you want to set pdqpriority for all sessions …
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…
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.…
Speak at the IBM Information Management Software and Systems Technical Conference - EMEA 2011 - July 6-8 Montpellier, France
Call for Speakers! IBM would be delighted to welcome Customers and Business Partner that have an innovative Information Management solution or project that is delivering real business value or anyone who can offer real expertise in the area of Information Management Software and…
=?ISO-8859-1?Q?Learn_marketing_from_industry_experts_from_Caf=E9_Cof?= =?ISO-8859-1?Q?fee_day=2C_United_Breweries=2C_Reliance=2C_HCL_etc_at_the_Marketin?= =?ISO-8859-1?Q?g_Symposium_=28Fe?=
Hello, Siliconindia is organizing the Marketing Symposium on Feb 4th in Bangalore. This conference will explore major marketing challenges, impact of technology on communication with target audiences – current and prospective, low cost with major results, managing increasingly c…
sysmaster query
Hi, Is there any sysmaster query which is substitute of onstat -g ses <session id> command ?…
out of virtual shared memory
Thanks guys for suggesting the way to get event alarms. Fernando! Your suggestion can help in pure OLTP systems. But don't you think that if we put a max locks limit per session on a hybrid (OLTP+OLAP) systems, it may lead to complex issues and might be it degrade the IDS perform…
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…
sql insert increases the value of nreads in onstat -u
Hi, I have a esql/c program that run this sql (output of onstat -g ses): Insert into cs_nyd_disg_ofi(cod_periodo,grupo_datos,numero_cliente,monto_a_compensar,di ......pond_t_pro_e,di_pond_d_pro_e,nhs) values(?,?,?,?,?,?,?,?,?,?....,?,?,?,?,?,?,?,?,?,?,?,?,?) When I r…
Queries waiting for mutex
Thanks for the reference Frank. I suppose I'm not the only one who got the wrong impression from the Admin Reference documentation on onstat -g lmx stating that the holder column was the "Session ID of the thread holding the mutex". Sounds like the holder column is Thread ID and…
How to identify a run away process in Database
Hi All, I want to identify what are run away process still running in the database. I can do "onstat -g ses <sessionid> and get the pid of the session. However, i can't validate that it is a runaway job. Is there a way that i can select from a database? or onstat, how would i k…
wait for mutex ... IDS hang....
Frank wrote: (4) mutex holder ??? it shows session 88852, but onstat -g ses 88852 shows nothing ( see below) informix@dora $ onstat -g lmx IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 4 days 03:03:29 -- 2120544 Kbytes Locked mutexes: mid addr name holder lkcn…
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…
soctcppoll and soctcplst
Hi, one is the listener thread, listening for new connection requests and subsequently serving them (new session). The other is the poll thread, checking if new data arrived on existing connections and notifying the appropriate session threads (normally called sqlexec threads). …
Temp table - does the temp table already exist?
Informix IDS 11.5 on Linux. We create temp tables using stored procedures(SPL) which are sometimes used by other stored procedures/functionality. The stored procedure can be executed more than once in a session, which means that an error occurs (temp table already exists) when th…
How to check informix DB bottlenecks
Hi All, How to check the informix tables for bottlenecks? i am having problem our database and the user are explaining that it is a DB problem. I verified the logs and there's no valid error on the log file... I've used onstat -g sql, onstat -g ses, onstat -g lmx, onstat -k for…
how to analyze bottleneck in informix db
Hi All, I'm curious about on how to analyze a database which has bottlenecks... On my perpective, i'll do the ff: 1. onstat -u -- to check what user. 2. onstat -g ses -- to check the current session. 3. onstat -g mem -- to check the memory. 4. onstat -k; to check the processes …
RE: onstat -g ses output
Tom. Before the mentioned section you will see the query with some question marks "?". Each line stands for one question mark. They represent the content of the variables of your query in the same order. HTH. Reinhard > -----Original Message----- > From: informix-list-bounces@…
onstat -g ses output
Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I am interested in knbowing what this output section means: Host variables : address type flags value ---------…
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…
Number of pid in output from onstat -g ses
Please, if anybody knows about this question: What do it mean pid = -1 in output from onstat -g ses ? I have an excess of connections from a server, but we can not determine the origin (the application that opens the connections) Furthermore, the tty column shows "-", for examp…
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…
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…
Informix virtual shared memory
> You need to find out where the repeating SQL is coming from by > tracking back the session number to a process using onstat -g ses and > beat the developer up! Hope its not something I wrote many years ago…
Question about the status of the thread
Environment: Informix 7.31 64 bits HP-UX 11i Hi, I see the output of onstat -g ses and I have one question. Please, anybody knows which is the diference between the status "sleeping(Forever)" and "sleeping(secs: 2)" ? When is "forever" and when is "secs: x" ? Thanks in advance.…
RE: Script for determining the number of user lice
Yes, that query is the correct count of the sessions (not threads) established by real users, without counting the page cleaners, etc. that are reported by onstat -u. The counter is sessions, not threads. The counter, as has been noted, is the high-water mark, not the current cou…
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.…
Lock mode
Hi, Yes, there is a way to accomplish the result, but it's not a configuration parameter. Assuming you're on IDS 10.00 or later, use the public sysdbopen() function t o execute the "set lock mode" statement. That avoids having to make any changes to your programs. See the Guide …
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 11.5.FC3 : Tracking new sql sessions
Dick, This works perfrect. Looks like there are lots of changes in xc3 release. Thanks for your help. --- On Tue, 4/21/09, Richard Snoke <dsnoke@us.ibm.com> wrote: From: Richard Snoke <dsnoke@us.ibm.com> Subject: Re: IDS 11.5.FC3 : Tracking new sql sessions [15572] To: ids@ii…
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…
Re: Just to make things interesting... ;-)
Mark Townsend wrote: > >> >> Today's article on The Register mention it... >> But I would expect a bit more knowledge from the analysts... Do they >> go to IOD like conferences? Did they access >> http://ibm.com/software/data and click on Data Management? Do they >> read press re…
RE: Just to make things interesting... ;-)
> > Today's article on The Register mention it... > But I would expect a bit more knowledge from the analysts... Do they go > to IOD like conferences? Did they access http://ibm.com/software/data > and click on Data Management? Do they read press releases? > Again... I would expe…
Determining instance's oninits
red_valsen@yahoo.com wrote: > I have 3 informixservers running on a single host. One of the > instances has experienced an assertion failure and is now > unresponsive, so I'd like to kill its oninit processes and attempt to > restart it. But running onstat -g ses only reports a…
Virtual Memory Segment Filling Up
Hi, try "onstat -g ses" as user informix for a start. To get details on a specific session do "onstat -g ses <session ID>". Further drill down might be done with "onstat -g afr <session ID>" and "onstat -g ffr <session ID>". Info on SQL statements you can also find by issuing "…
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…
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…
View thread info?
Hi All, Thanks for your replies. I managed to identify the process that caused the problem. 1. Use onstat -g act to look at active threads 2. Perform onstat -u | grep <rstcb value of active thread in step 1> -> get session id. 3. Perform onstat -g ses <session number from step…
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.…
Re: those who went to kansas
Andrew Ford wrote: >> Report please. thanks. > > I think the conference was huge success, far exceeding the expectations of > many. > Tuesday morning's keynote was again a full house and given by Arvind > Krishna, Vice President of IBM Data Management, where he announced the > r…
Informix session details
Hi, Sometimes I see huge Reads by one or more informix sessions in onstat -u. I know onstat -g ses <sid> won't show any details of such system sessions. Well, it could be many thing in terms of house keeping by IDS but is there any way to find out more details about such session…
foreach and open descriptor
On Feb 18, 4:20 pm, vomari...@yahoo.com wrote: > hi, > i'm executing routines containing foreach ... end foreach > instructions. it seems that after many execution > onstat -g opn shows a great number of lines and my session hangs. > what's could be the linux kernel parameter tha…
Java Multithreaded application gives -1 as PID
Version: IDS 10 I have a java application that is multithreaded and each thread creates a new DB connection. But when I look at onstat -g ses I see PID as -1. Could somebody tell me if this could be changed to reflect actual PID of the application ?…
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…
Long Transaction
Version: IDS 10 How can I track "tx" in following message: "Aborting Long Transaction: tx 0xc0000001f4b64938". Is "0xc0000001f4b64938" the user address that comes in onstat -u ? I am trying to track which process caused the long transaction. I have a script that runs every 15 mt…
Activate dynamic explain
Hi all, To analyse a user query I tried to activate dynamic explain using onmode -Y <ses> 1. Using onstat -g ses I found that dynamic explain had been activated (on), however I did not find any sqexplain.ses.out file created. When I issue onstat -g iof I see the particular file …
Condition Wait Netnorm
Hi all, am the project manager for an application running on IDS 10. Off late the users complain of the sessions getting stuck. Whenever they try to insert an record it takes a lot of time to insert. At times the session just hangs and then they have to get it killed. From whate…
"Dynamically added new Virtual segment "question
> What do I do? (and don't start me on onmode -F on HP-UX!!!!!!!!!!) > First off is onstat -g seg to find the address of the new segment, no > problem. > But once I've done that, what's the next move? > I'm guessing onstat -g mem and find out what processes have a pool > starting…
Informix Technical Briefings in the UK
Informix Technical Briefings Date: 29 August 2007 and 21 September 2007 Location: Ardenta offices, Sunbury on Thames Duration: 8.30 - 11.15 am Audience: Technical DBAs, IT Managers, Informix Technicians. Designed for customers but also useful to any organisation interested in In…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Identifying ODBC Connections?
IDS 10 Solaris 10 Sun V480 Most of our users only access the database by means of the custom application that manages our business. However, a few users were given special permission to use M$ Access (ODBC) connections. Lately, we have reason to believe that unauthorized Acces…
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
On 30 Mar, 19:59, "mirekb" <mirek...@gmail.com> wrote: > Our clients recently has migrated their system to AIX 5.3. Since the > migration they are having problem with our application. It is a > memory leak reported by Informix command 'onstst -g ses'. The memory > allocated to…
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…
querying sysmaster to get last sql executed
Hi all, Does anyone know how to get current or last sql sentence execute by a session? I know that onstat -g ses <session id> shows it, but I want to get it trough sysmaster. is it possible? Regards…
Assert Failed: pthdrpage:ptaltdescs2:bad alter sl
This is the result of oncheck after reboot. I also did a consistency check on the tables that were beeing loaded when the assert failed. ( onstat -g ses <ses id> ). There were no complaints. What I found out is the since some time the server was complaining about the physicallo…
AW: find session_id, ip, machinename
onstat -g sql shows session id (SID) and database. onstat -g ses shows SID, user, process id (PID) and hostname. Type onstat -g sql SID or onstat -g ses SID to get more info about a single session. -----Ursprüngliche Nachricht----- Von: informix-list-bounces@iiug.org [mailto:in…
Command to tell the age of a lock
This morning was asked "How can I tell how long a lock has been held?" I rifled through onstat -k, onstat -g ses (sesid) and onstat -u, but didn't find anything that told me the "age" of the lock. Is there a command that will do that? DT…
Database consistency with HPL
I am trying to find the fastest way to take a copy of an entire database. Dbexport/dbimport are too slow as is ontape. I am not able to use onbar as we don't have access to a storage manager (third party who handles backups doesn't want to use ISM). I was thinking of using HPL b…
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…
query using cpu
Floyd Wellershaus wrote: > Any idea why a query that does a join of a table on itself, doing a count and a group by, would cause the cpu usage to go drastically up, almost instantly ? Not pdq, just a query, on a non fragged table. > > It is doing multiple sequential scans of the…
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…
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 …
IDUG Conference
I attended and presented. I found the conference even more productive than the one last year - mainly because there was no reason for me to waste time taking in any DB2 sessions this year <grin>. There was a futures session to which about 1/3 of the Informix users attending were …
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?…
Information on Demand Call for Speakers!
The call for speakers for this year's IBM Information On Demand 2006 global conference has begun! This exciting new conference will have more IBM technical and business solutions content in one place than ever before. We have expanded the ways you can participate as a speaker, w…
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: 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!…
IDS Feature Request List (including potential new requests).
Folks, I have updated the IDS Feature Request List a) The is a link from my Website www.smooth1.co.uk now b) Updated peoples email addresses (thanks!) but not managed to get everyone's. c) Added Last Updated Date and Version Number so people can see when it changed and I can …
Informix database filling up rapidly
Run onstat -u and onstat -g ses for each session. There must be an application creating temp tables or doing queries that take a long time and are not using indexes.…
Re: IDS and Server Studio
I've demoed it on my laptop to 2 customers now before now and they seems to both be planning to use it. Something that unskilled people can use to monitor space, sessions and locks. Gotta have a GUI Enterprise Manager like Oracle/SQl Server! I like it as it is simple to setup …
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: Subject: Re: OT: Don't create tables owned by informix -
Write a C program that runs onstat -g ses argv<1> that takes one parameter, makes sure it is up to 8 character long and it is all digits.....easy! Also a seperate replacement for onstat -g sql that does the same validation. Love Dave. PS Was thinking about this today. How…
onstat -g sql equivalent for tbstat
Hi, I am using IDS 5.x on Linux (red hat 7.1) I would like to monitor the sql statements being run by some process I know in IDS 9.x you can do a onstat -g sql, then a onstat -g ses <sesid> However this option is not available with IDS 5, or that informix toolset. Neither does t…
Re: onstat -g wmx
>Query sysmaster directly? What does that show? > >onstat -g ses for each session? > >onstat -g stk all? > >onstat -g con ? > >Let us know what you find.. > Unfortunately it was last Saturday when this came up and it not occurring now and is unlikely to happen again in the near …
Re: IDS 10 erratic run times
1.ok... what does condition bp_cond mean? does anyone have an internals manuals? 2. onstat -g stk is not for the thread I wanted a) onstat -g ses <session id> for the session what is the name of the threads that are running. b) onstat -g stk <thread id> for each session…
Database Crash
When this is really true: - 1700 Userthreads - Maximum server connections 136 you should check your PDQ usage and settings... Search for many RSAM threads (onstat -g ses | sort -nrk 6) and/or sessions with high memory usage (onstat -g ses | sort -nrk 7). Regards, try_and_err PS…
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…
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:…
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…
Hanged INFORMIX connections
Hi all, I realized that client connections to INFORMIX remained open if You accidentally remove network cable; it's just to give an example. Other kind of similar event did same thing. How can you monitor a connection to Informix with this problem? When I reviewed user threads …
Hanged INFORMIX connections
Hi all, I realized that client connections to INFORMIX remained open if You accidentally remove network cable; it's just to give an example. Other kind of similar event did same thing. How can you monitor a connection to Informix with this problem? When I reviewed user threads …
Onstat -g ses only for DBSA?
Hi, I have got a doubt. There are two servers. One of them with an informix server version: IBM Informix Dynamic Server Version 9.30.UC6W4 and the other IBM Informix Dynamic Server Version 9.40.FC5 When I execute the command Onstat -g ses on the first one (version 9.30), it's…
Onstat -g ses only for DBSA?
Hi, I have got a doubt. There are two servers. One of them with an informix server version: IBM Informix Dynamic Server Version 9.30.UC6W4 and the other IBM Informix Dynamic Server Version 9.40.FC5 When I execute the command Onstat -g ses on the first one (version 9.30), it's…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Getting a List of Users Connected to a DB
Hi, try something like a) echo "select distinct(username) from syssessions;" | dbaccess sysmaster - b) onstat -g ses | awk '/^[0-9]/ {print $2}' | sort -u Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management forum.subscriber@iiug.…
Re: Perl script for running OnTape, Someone???
Diveman wrote: > Hi, > > Would be thankful if someone could provide me with a Perlscript for > OnTape, > or explain how to call OnTape from within Perl. > > I try to solve it with a system() call, but get stuck on the question > when OnTape asks for tapedrive,,, > > /Christian Yo…
Perl script for running OnTape, Someone???
Diveman wrote: > Hi, > > Would be thankful if someone could provide me with a Perlscript for > OnTape, > or explain how to call OnTape from within Perl. > > I try to solve it with a system() call, but get stuck on the question > when OnTape asks for tapedrive,,, > > /Christian Yo…
onstat -g ses is truncating the hostname
Hello, I'm running an onstat -g ses as I need to find out the pids on various hosts. But it is truncating the hostname to 8 characters. e.g. session #RSAM total used id user tty pid hostname threads memory memory 33141 simon - 32548 myhost00 1 651264 633984 33106 ben - 22024 my…
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: Lock table overflow
Hi, "onstat -k" shows for which resource (database, table, index, row) the locks are used and who the owner is (the owner column is the address of the user thread). With the latter and the output of "onstat -u" you can determine the session ID of this user thread. Using that ses…
Re: Lock table overflow
Hi, you may want to check the parameter value for LOCKS in your $ONCONFIG file and most likely increase the value. You seem to have a session (application) that makes good use of locks (check for row locks vs. page locks) and the server's running out of the configured number of…
Re: Interpretation of onstat -g ses, hostname column
Did you truncate the lead 0 or did Informix? If its Informix, then its a product defect. Mike Reetz wrote: > Sometimes the hostname is the DNS entry (i.e. human readable). Other > times, when the connecting computer does not have a DNS entry, the > value is in hex (??). How…
What is PID in onstat -g ses
What does PID in onstat -g ses (or in syssessions) represent when connection is network or ODBC connection? If I use that PID in "ps " command I can't find any process with that PID. Nebojsa ------------------------------------ Remove spam block (DELETE_) to reply…
RE: Interpretation of onstat -g ses, hostname column
Colin, You surprise me. I thought that us old wizened practitioners could still remember our hex conversions. Immediately I saw the numbers in hex I was converting them into decimal. And Mike, I thought you would have known better as well. It's all part of the development plo…
RE: Interpretation of onstat -g ses, hostname column
Colin, You surprise me. I thought that us old wizened practitioners could still remember our hex conversions. Immediately I saw the numbers in hex I was converting them into decimal. And Mike, I thought you would have known better as well. It's all part of the development plo…
RE: Interpretation of onstat -g ses, hostname column
Mike Reetz wrote > Sometimes the hostname is the DNS entry (i.e. human readable). Other > times, when the connecting computer does not have a DNS entry, the > value is in hex (??). How can that be changed back to an IP address? > > Example: > > 3 values for hostname from onst…
RE: Interpretation of onstat -g ses, hostname column
Mike Reetz wrote > Sometimes the hostname is the DNS entry (i.e. human readable). Other > times, when the connecting computer does not have a DNS entry, the > value is in hex (??). How can that be changed back to an IP address? > > Example: > > 3 values for hostname from onst…
Re: Interpretation of onstat -g ses, hostname column
the hex number can be converted to the IP. Here is an example a010a1e(a.01.0a.1e) = 10.1.10.30 a = 10 01 = 1 0a = 10 1e = 30 --- Mike Reetz <mreetz@gmail.com> wrote: > Sometimes the hostname is the DNS entry (i.e. human > readable). Other > times, when the connecting comput…
Re: Interpretation of onstat -g ses, hostname column
the hex number can be converted to the IP. Here is an example a010a1e(a.01.0a.1e) = 10.1.10.30 a = 10 01 = 1 0a = 10 1e = 30 --- Mike Reetz <mreetz@gmail.com> wrote: > Sometimes the hostname is the DNS entry (i.e. human > readable). Other > times, when the connecting comput…
Interpretation of onstat -g ses, hostname column
Sometimes the hostname is the DNS entry (i.e. human readable). Other times, when the connecting computer does not have a DNS entry, the value is in hex (??). How can that be changed back to an IP address? Example: 3 values for hostname from onstat -g ses: a010a1e a010d22 a…
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'?…
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: 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…
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…
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.…
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 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,…
pid in onstat -g ses
IDS 9.40.FC3 AIX 5.2 I have one application that always shows up with a pid of -1 in onstat -g ses. It is an EDI application from Inovis. These are all tcp/ip connections to the server. Does anyone know exactly how the server determines the pid if the process is started from an…
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.…
What do session statuses mean?
What does a status of "cond wait(await_MC1)" in onstat -g ses mean? Thanks Andy…
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…
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?…
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.…
[HELP] What my Informix is doing?
On 11 Sep 2003 02:54:04 -0700, steven@steven4u.net (steven) wrote: >My system is SCO OSR5 + Informix Online 7.x with 128M ram. The >database is created w/o loging. > >Is any method here let me know what the Informix is doing? > Try with some "onstats": onstat -p onstat -u ons…
onstat -g ses > negative memory ??
Hi. I'm using 7.31FD3W1 on HP-UX 11.i I found a special case on onstat -g ses comand : Informix Dynamic Server Version 7.31.FD3W1 -- On-Line -- Up 1 days 21:35:34 -- 937056 Kbytes session #RSAM total used id user tty …
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…
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: CKPT REQ - Blocked:CKPT
This means that the instance is waiting on a CHECKPOINT to complete. From the info..it looks like an HDR pair where the Primary is waiting for the Checkpoint to complete. check the onstat -u output and look for flags -X- on any of the sessions, which means this session is in a c…
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…
SQL in onstat -g ses output
Dumb question time: What is the difference between "Current SQL statement" and "Last Parsed SQL statement"? Usually the SQL is identical in both but I've always wondered why sometimes this is not the case. And why might only Last parsed SQL statement be displayed as in the output…
Cause of long transaction?
Hi, you can see from the message that's written to the message log file (online.log), which session caused the LTX (long transaction). With that Session ID you can do "onstat -g ses <ses id>" or "onstat -g sql <ses id>" to find out, what the session is doing at the time, i.e. wh…
SMI-Tables: Performance messaurements - l2datetime convert the Informix internal time to datetime
Hallo, I've 2 questions for useing the SMI/onstat for performance messaurements. 1.) Whar is the unit of the memory usage in onstat -g ses (bytes ??) 2.) How can I convert the Informix internal time in long in a datetime-representation, as is done with the SP l2date create proc…
killing a process
Andrew Hamm wrote in message <3a6e3899@news.iprimus.com.au>... > >Assuming you can identify the process in the onstat -u listing .... > But if you can't directly identify it, you need to work backwards from a ps listing. Get the process number, run onstat -g ses, identify the li…
how to find how many user connected to database a day
Hi all, 'onstat -g ses' show me who is currently connecting to server. Is there a way I can count how many users were connecting to server in a day or so? Any help would be appreciated. Thanh Ngo…
Help with onstat -g ses
When I do an onstat -g ses, I see a -1 in the PID column for some of the connections. What does the -1 mean? -- Scott A Andrews Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
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…
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…
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…
RE: Webdata Blade and session management
From: "Watson, Paul" <Paul.Watson@aggregate.com> > >Nothing Windows does surprises me:-))) But until I know the detection >works I'm stuck as to what a solution might be:-(( I suppose the >decision might be being made by the webserver. > >Now all I need to find is an attractive…
Re: Webdata Blade and session management
From: "Watson, Paul" <Paul.Watson@aggregate.com> > >Under the webadmin area you can set the session to be > >cookie - straightforward >URL - encoded - handy for non-cookie aware sites >Auto - let the webblade decide > >The question is how, in case of Auto, is this decision made? …
RE: Webdata Blade and session management
Nothing Windows does surprises me:-))) But until I know the detection works I'm stuck as to what a solution might be:-(( I suppose the decision might be being made by the webserver. Now all I need to find is an attractive webmaster to help me:-)))) Paul Watson WF Software Ltd…
Webdata Blade and session management
Under the webadmin area you can set the session to be cookie - straightforward URL - encoded - handy for non-cookie aware sites Auto - let the webblade decide The question is how, in case of Auto, is this decision made? Under Win98 and IE5 the blade seems unable to reliable de…
What do you need for database management?
My company, Server Management and Design, is conducting a survey to determine how to best serve the needs of database administrators and their management through the proper applications of database tools. I have been a DBA for fourteen years on various platforms, and feel that I…
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…
Re: Sql statement on onstat -g ses command
Are you executing onstat -g ses <id> -r 1? Try onstat -g ses <id> -r Vinod Bhansali >From: dyrson.alves@telemigcelular.com.br >Reply-To: dyrson.alves@telemigcelular.com.br >To: informix-list@iiug.org >Subject: Sql statement on onstat -g ses command >Date: Wed, 14 Jun 2000 18:36…
Re: Sql statement on onstat -g ses command
Are you executing onstat -g ses <id> -r 1? Vinod Bhansali >From: dyrson.alves@telemigcelular.com.br >Reply-To: dyrson.alves@telemigcelular.com.br >To: informix-list@iiug.org >Subject: Sql statement on onstat -g ses command >Date: Wed, 14 Jun 2000 18:36:39 GMT > >The output belo…
Sql statement on onstat -g ses command
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 termination." Does someone knows what this means? The sele…
Lock mode ...
The lock mode is set at the session level, defaulting (AFAIK) to NOT WAIT. To see the actual settings of connected sessions, run "onstat -g sql". Rudy Arnaud ANDRIEUX wrote: > Hi All ! > > Again a question of lock management !! How can I see which behaviour has > my instance o…
backup doubt
I want to make a backup my data using onbar. But I dont want to backup the logical logs. If I set the LOG_BACKUP_MODE parameter to NONE, I cant backup my data. I got the following message: ERROR: Unable to create a session: The backup manager cannot do any backups or restores w…
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…
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.
Watawinona wrote in message <20000316144727.03156.00002715@ng-fo1.aol.com>... >the conversion functions get slower and slower? > >What is the connection type? shm or soc ? > What are these? >Did you FREE cursors? What does onstat -g ses sessid say? Does the executable >grow in…
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…
RE: Finding CPU hogs
Look at onstat -u and note the user processes that are running. Particularly note the users with large numbers of read and write activity. If you want more, then onstat -g ses {sess-id} to find the sql they are running. If a repeat says the same sql , then you likely have an ap…
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…
Strange user (session)
Hi! I have a problem on IDS 7.31.TC2 , NT 4.0 SP5 . When I check current sessions with onstat -g ses I get a strange User listed (symbols). I have no idea when this happens, but it happens very frequently. Here's example (notice ses 185): ----------------------------------------…
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…
Receiving "Changing data structure forced command termination." from onstat!
Getting a "Changing data structure forced command termination." message when executing onstat (-g ses, -g ath, and others). oninit is running at ~98% of CPU (via "top"), so system is busy, but can things change that fast?!?! What makes me more nervous is that I receive a "Memor…
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: 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…
Memory Fault
We're running Informix Online 7.24. The database is really busy, but whenever we use commands such as oncheck -pe or for that matter any of the oncheck commands we get a Memory fault. When we do other commands like onstat -g ses or onstat -g sql we get a message that essentially …
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…
IECC - no users shown
I have a IDS 7.30 on OS solaris 2.6. When I open the IECC I don`t see the sessions. With onstat -g ses the sessions are shown. I brought the IDS down, and started new. Who can help ?…
iecc - no users
Hi I have a IDS 7.30 on solaris 2.6. When I open the IECC I don`t see the sessions. With onstat -g ses the sessions are shown. Who can help ?…
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…
Strange temp table tblspaces in onstat -g ses
Hi Family, I was monitoring a very active user (holding ~1500 locks) and ran onstat -g ses <sessionid>. At the bottom of the output is a list of the session's temp tables. The following caught my eye: User-created Temp tables : partnum tabname rowsize 500002 t…
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…
onstat -g ses ANd Process ID
HI ,, What does the onstat -g ses does , I observe that when I execute the command it gives me memory information . It says that informix is using like 45MB of memeory where our server and Silicon graphics 6.2 irix has some 2 GB of Memory.How can we tune the servr so as to use m…
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…
informix error 244 and 113
Arvind Sharma wrote: > > Hi, > When I am doing a select on a table it is giving me error -244 and > ISAM error -113. These errors say that the table is locked and it can > not do a physical read on that table. Is there a way by which we can > release the lock? I don't think a…
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…
Memory Used
Hi All: I have a simple question, when you type onstat -g ses command over Unix prompt, you can see both columns total memory and used memory assigned to each session, would you tell me in which measure unit it is? I think that it values are in Kbytes. It is true?…
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…
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: onstat -u / onstat -g ses Problem
Informix Netherlands advised to start the database with the environment variable SINGLESEG_OFF=1. Try it! Regards Hans Bosma Database Administrator NCCW(Netherlands Ing Thoralf Bihlo wrote: > > I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server > 7.30 UC6. >…
REQ: Problem with onstat -u / onstat -g ses
I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server 7.30 UC6. My SHMVIRTSIZE is 32k and onstat -g seg shows that I have just one Segment. When I try an onstat -u or onstat -g ses I get the Error: >Changing data structure forced program termination< during the …
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…
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…
Re: "Guilty locker"
Pierre Ouimet wrote: > > Hi, > > Is it possible in Informix to know which user has locked a table (or a row) Yes. Onstat -k will show locks. Look up the tablespace # and rowid (zero for table lock) and get the owner column value and then run onstat -u and grep for the owner va…
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…
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: matching sessions with databases
If you do an onstat -g sql, there is a column that tells you which database each session is connected to. So you could do an "onstat -g sql | grep <db>" to see which sessions are accessing a particular database. Sean Gilmour wrote in message <3655FF8E.AC274878@css.mot.com>... >…
Re: matching sessions with databases
Hi Nicole, If you run a onstat -g ses # of the session id at the bottom it will tell you the current database for that session id. Nicole Guffey wrote: > Is there a utility, or a piece of code, that identifies which > database (or even dbspace) a session is accessing? > > …
RE: Informix Management Tool?
You can check out Informix Enterprise Command Center. I t allows you to administer servers, databases, spaces, storage, events, sessions, reports, backup/restore, load/unload data, and replication. -----Original Message----- From: Kai Shen [mailto:shen@acer.de] Sent: Friday, No…
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 …
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…
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…
Total memory & used memory in onstat -g ses
The onstat -g ses commands displays total memory and used memory by session. Does anyone know how I can reproduce this display using sysmaster tables? I am trying to determine which host(s) are initiating sessions using larger amounts of memory. This onstat command shows only …
Re: How to determine number of users/sessions?
Bob Gorman wrote: > > How can I query the Informix Dynamic Server inorder to determine the > number of users/sessions connected to a particular database environment? Use 'onstat -g ses' or 'onstat -u' to just look at connected sessions. To see who is connected to what database u…
RE: onstat -g ses hostname info
The sysmaster:syssessions view contains a 16 character hostname column. -----Original Message----- From: Danny Williams [mailto:dummy@email.address] Sent: Tuesday, July 14, 1998 03:16 To: informix-list@iiug.org Subject: onstat -g ses hostname info Hi there! onstat -g ses only …
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: Q:How to find list user sessions with database
]Steve Berg wrote: > > You could also use onstat -g sql instead of onstat -g ses <sessid>. Don't run onstat -g sql on a very busy server it will NEVER return and you will not be able to kill the session it starts! Because of the VERY dnamic nature of this particular table and t…
Re: onstat -g ses hostname info
Thanks - works great!…
Re: Q:How to find list user sessions with database
You could also use onstat -g sql instead of onstat -g ses <sessid>. Steve Berg spb@nb.com On Wed, 15 Jul 1998, CONWAY Graham wrote: > Hi, > > Please excuse me if this is obvious. > > Does anyone have a simple way (sysmaster query or onstat option) of listing > the sessions on …
Re: onstat -g ses hostname info
In article <6ofmge$4db$1@nnrp1.dejanews.com>, jgubler@my-dejanews.com wrote: > In article <35AB2FE4.7485@email.address>, > Danny Williams <dummy@email.address> wrote: > > Hi there! > > > > onstat -g ses only provides 8 characters for the hostname field - even > > when you pro…
onstat -g ses hostname info
Hi there! onstat -g ses only provides 8 characters for the hostname field - even when you provide a session ID. Is there any way to find out the full hostname of the connected host? Danny…
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…
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 ? Pl. explain. TIA Sathish…
IECC
Hi, Just wanted to get some opinions about IECC ( Informix Enterprise Command Center) which comes alongwith IDS 7.3. Personally, I have been using IECC for day-to-day monitoring, and I have found it to be very nice. The reports which are generated through it, are also good. It …
IIUG - Reminder about survey and ATE
Just a quick reminder that the International Informix Users Group (IIUG) is conducting, on its website, several activities that should be of interest to most of you here in this group. These activities include a survey on potential features to be added to the Dynamic Server engi…
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: 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…
IIUG - Ask the Experts at the 1998 IWUC
Have you ever wanted to ask Bob Finocchio or Jean-Yves Dexmier a question about Informix and where it's going? How about to the architects, designers, or coders who actually design and build the products? Well now's your chance. The IIUG has expanded this year's Ask the Expert…
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: +…
Invitation to Participate: TESTING COMPUTER SOFTWARE CONFERENCE
The continuing annual Conference on Testing Computer Software again assembled a formidable group of experts on every phase of testing. The latest developments and discoveries of software testing technologies will be presented and explored, to meet the software development challen…
Re: Waiting on condition problem.
>Here is onstat -g ses for a session which is waiting on condition for >more than >an hour. >How to find out the condition on which this is waiting ? >And how to make it run ? > > >Here is onstat -g ses for a session which is waiting on condition for >more than >an hour. > >1880…
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…
Re: Update Statistics
Robertson Lee NTSE wrote: > > All, > > I have been left a large script by the Informix DBA to run. It does an > update statistics (low, medium and high) on all of the tables in the db. > > Is there any way I can monitor how this is doing as at the moment it is just > sat in dbacc…
Long transaction
I think I have a problem, but I'm not sure. I did an onstat -g ses and it said 'BLOCKED LONGTX' I did an onstat -l and have over 50% free log files available. 1. Is this a critical problem? 2. If so, what do I do about it? Thanks in advance, Joe…
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: multithreaded servers
Peter Weigert wrote: > > hi folks! > > does anybody know wether informix thinks about supporting a > multithreaded applicationserver with one session per thread > (the global sqlca interferes the multithread support). Esql 7.21+ supports multi-threaded applications. A task can …
Re: Who is blocking ?
Rainer Schaub wrote: > > I can tell you the solution for OnLine. > Make a onstat -u and onstat -k. > The one who has a L , at onstat -u at the first position on > flags, is blocked. > You have to take the "wait"-adress of this process and have too look > at onstat -k at ad…
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…
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…
Identifying problem sql's via onstat
Has anyone written a unix or awk script to identify the link between a running unix processes and sql statements which are effecting performance. I can manually run onstat -u to give me the session id and then onstat -g ses sessid to give me that specific sql. But I can't identif…
Informix Database Auditing
Re : Informix Database Auditing Dear Informix Professional PS give me any suggestions of the following issues : 1. When the Informix Trusted facility is turned on, the engine write an audit record to log the update row event with tabid and rowid only. How can I log with …
Assertion Failure dump file
Has anyone had any experience using the dump file created with an assertion failure? I would like to understand what happens during such a failure and how I can pinpoint what is causing the failure. I believe you can use onstat -g ses with the dump file (something like shmem.1…
Re: onstat -g ses
Dagmar Wartenberg wrote: > > Vic Goldberg schrieb in Nachricht <3496BD2C.74BB@cornell.edu>... > >dalink@west.com wrote: > >> > > > >Also, look at PSORT_NPROCS environment variable. Controls number of > >sort threads, and can really speed things up. > > Two weeks ago I participat…
Re: onstat -g ses
Vic Goldberg schrieb in Nachricht <3496BD2C.74BB@cornell.edu>... >dalink@west.com wrote: >> > >Also, look at PSORT_NPROCS environment variable. Controls number of >sort threads, and can really speed things up. Two weeks ago I participated in a training about performance tuning …
memory pools of onstat -g ses
Could Any one Please explain me the memmory Polls section of onstat -g ses 12378 Is this the normal in informix INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 -- 416472 Kbytes session #RSAM total used id us…
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: doubt in onstat -g ses
>Could anyone please explain me the meaning of the following state of >the informix session. This the out put of > >tid name rstcb flags curstk status >16573 sqlexec c042a18 Y--P--- 1872 c042a18 cond wait(netnorm) > > The netnorm wait is simply saying…
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: doubt in onstat -g ses
In article <3497ED19.6482@fmr.com>, bala peddi <bala.peddi@fmr.com> writes >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 through ESQL/C program and >this application …
Re: doubt in onstat -g ses
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 through ESQL/C program and > this application is will not close the informix session , it runs 7 …
doubt in onstat -g ses
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 through ESQL/C program and this application is will not close the informix session , it runs 7 x 365 days. This application …
RE: onstat -g ses
Hmm, just a comparison, I am running a HPUX 10.20 7.23 UC4 box with 1 CPU. I have a table in which I build many indexes. The table has 11 millions rows and takes 30 mins. Scaling up to 63 million rows it would tabke me about 6*.5 or 3 hours! Regards Silvester Valiente Info…
Re: onstat -g ses
} I have been building an index on an integer field for the 36 hrs on a } table with 63 million row which is fragmented round robin on 28 } fragments. The index is fragmented by expression on 28 dbspaces by } expression mod(acct_num,28) = 0.... } } I am trying to monitor its prog…
Re: onstat -g ses
Don't know your specifics, however, we build a unique composite index on a 55 million row fragmented table. The table resides in 8 dbspaces and the index in 8 separate dbspaces. Two suggestions. Set PDQPRIORITY very high when building the index. I actually don't know if this h…
Re: onstat -g ses
dalink@west.com wrote: > > I have been building an index on an integer field for the 36 hrs on a > table with 63 million row which is fragmented round robin on 28 > fragments. The index is fragmented by expression on 28 dbspaces by > expression mod(acct_num,28) = 0.... > > I am t…
onstat -g ses
I have been building an index on an integer field for the 36 hrs on a table with 63 million row which is fragmented round robin on 28 fragments. The index is fragmented by expression on 28 dbspaces by expression mod(acct_num,28) = 0.... I am trying to monitor its progress and ha…
Free data warehouse seminar in Hong Kong, Malaysia, Singapore
After recently announcing its entrance into the Asian market through its Asia Pacific Division, Prism Solutions is now presenting a FREE Educational Seminar Series in Hong Kong, Malaysia and Singapore. The Seminar will be held in the following locations: Hong Kong: 18 Novembe…
Infuse Autumn Conference
Infuse, UK Informix User Group, is holding its Autumn Conference at the London Metropole Hotel on the 19th November. This event is open to everybody, both members and non-members. An outline agenda is detailed below. Agenda�� Welcome Stewart Ashton, INFUSE Chairman Informix …
Re: Archive utilities: autoloaders supported?
Cosmo Lee wrote: > > We would like to be able to use one of the new tape storage solutions > such as the HP DAT 24x6e, which holds multiple 12GB tapes. Do any of > the Online archive utilites support any such autoloaders?? I don't see > any mention in the 7.2 "Archive and Backu…
Documentation on the ouput of onstat -g options
Hi All, Is there any documentation around which explains the output of onstat -g options for example the following is the output of onstat -g ses <session id> tid name rstcb flags curstk status 2326 sqlexec 119b65d4 B--PR-- 2032 119b65d4 sleep…
IIUG - ATE transcript is available
10.8.97 Well it's taken a little time but the transcript of the "Ask the Experts" session at this year's Informix Worldwide Users Confernce is finally available. This session was part of the technical track sponsored by the IIUG. Participants in the session included: Dr. Paul…
Re: Status in onstat -g
>We have Informix 7.10 running on a SCO Box. > >I did an onstat -g ses ## and got a status of "mode wait(netnorm)". Does >anybody have an idea what this means? > > Basically that you are using tcp to communicate with the engine and that the engine is currently waiting on the cl…
Status in onstat -g
We have Informix 7.10 running on a SCO Box. I did an onstat -g ses ## and got a status of "mode wait(netnorm)". Does anybody have an idea what this means? Shannon…
Free Seminar Denver 10/16
Managing the Economics of Information Technology: Critical Issues at the Century Transition October 16, 1997 A free half-day seminar presented by Computer Economics, Inc., Carlsbad, California A seminar to help you: Manage Y2k Projects and Liability Issues Identify IT Spending…
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…
Deferring Triggers, using sub-transactions.
The standard way of managing it is to define AFTER triggers, and use transactions. Those triggers only raise their action at the COMMIT time, when all your update queries are done, but before locks applied for the query are released. You can safely design a transaction in all yo…
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…
IIUG - Ask the Experts at the 1997 Informix Conference
Hello again from the IIUG Board of Directors. A couple of bits of news we would like to share with you. SUBMIT QUESTIONS TO THE EXPERTS The International Informix Users Group (IIUG) has created an e-mail alias for you to submit questions for the IIUG Ask the Experts session at …
US - OR & AZ - Informix Database Support, DBA & Developers needed
Informix personnel needed to design, document and implement back-up/refresh strategies, facilitate DBMS planning sessions including identifying priorities, key tasks and tools to be developed in order to properly manage DBMS, DBMS growth projections, tools and utilities for DBMS …
Re: How do I find out which users are connected to a database
Hi, with Online 6 you can use onstat -u to determine the user thread number of the users. Then use this number as parameter for onstat -g ses to find the SQL-statement currently being executed. This should be sufficient to get the database name. I don't know if this works with O…
Re: find session id
In article <55cfj5$pn8@netnews.csie.nctu.edu.tw>, ccliu <ccliu@csie.nctu.edu.tw> writes >Hi, > When informix has BUS error, it will show: > >18:20:13 Checkpoint Completed: duration was 1 seconds. >18:21:09 Assert Failed: Internal Error - Bus Error >18:21:09 Who:Session(114…
DBA'S
APG-USA An Open Systems and Client Server Integrator with offices in the US and Canada, has permanent employment and/or subcontracting opportunities for DB2/6000 database professionals at multiple client sites. Experience in any of the following: DBA, Data Modeller, DDCS…
active queries/users
Does anyone know of a way to query the system catalogs (SMI tables) to list the active users on online 7.2? Same as onstat -g ses (sql) but only for those users actively running a query. suggestions... -- -------------------------------------------------------------------------…
SUMMARY: RE: REPOST - Session resource usage stats.
My original question is below sig. It seems confirmed that it is not possible to *directly* gain CPU usage information for sessions in 7.x as they are managed through the oninit processes and nothing that I have been able to discover in sysmaster gives you this info. I have bee…
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…
UK Informix User Group Conference - Last chance to book
Book Now for : INFUSE CONFERENCE The 8th INFUSE Conference Commonwealth Institute, London Wednesday 15th May 1996 09.00 Registration and coffee 09.45 Welcome and introduction Jerry Nichols, Logica UK and INFUSE Chairman 10.00 Is Client/Server Dead ? Presentation and Di…
How To: multi threads, Fragmentation in Online 7.1.
Informix Gurus, I have fragmented a few tables in our schema, and have updated statistics on those tables. I set the PSORT_NPROCS variable in the onconfig to the largest level of fragmentation (10). Now when I run queries on the fragmented tables, and monitor them using ons…
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
'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)…
Re: Onstat -g ses Output
cherylk@spamis.jcdc.doleta.gov wrote: : Does anyone know where I can get a explanation of the Onstat -g ses <sessid> : output for Online DS 7.10? Hmmm. Well, the Admin. manual is pretty unspecific, but the training manual from the DSA Sys. Admin. class has the info. If you ha…
Re: Onstat -g ses Output -Reply
Peter could you please fax me the course notes for upgrading to DSA chapter 8, as well as, the part # for the Training Manual. My fax number is 512-393-7296. If that is to much of a problem, just e-mail me the part number of the course training manual. Sound as if it has a lot …
Onstat -g ses Output -Reply
The course notes for upgrading to DSA have some information in chapter 8. A lot of it is pretty esoteric. If you can't get a copy of the pages, let me know and I will precis them to the list. rgds -- -- Peter Tashkoff <tashkop@kiwi.co.nz> Project Consultant/DBA NZ Kiwifruit Ma…
Onstat -g ses Output
Does anyone know where I can get a explanation of the Onstat -g ses <sessid> output for Online DS 7.10? Thanks Cheryl L. Kendricks-DBA cherylk@spamis.jcdc.doleta.gov…
Re: sessid and pid
Hi Lin, Lin-Chuan Lee wrote: > can someone explain the relation between sessid and pid ?? > tbstat -u generates (among other things) unix pid > while onstat -u gives sessid. New to V7 ... The 'pid' that tbstat -u gives is the Unix pid of the sqlturbo *process* that is the engi…
Enterprise Management Summit '95 - Free Exhibits Pass
If you would like to attend Enterprise Management Summit �95, free SummitPlus show floor passes are available by calling 800-340-2111. You can also register by accessing the Summit web site at http://www.summit.micromuse.com. The SummitPlus pass includes access to * Show floor o…
db cockpit
I'm just getting used to 7.1 There is a program called dbcockpit which looks interesting. It is a graphical program but the manual doesn't say how to access it. Is this an X windows program or do I need a windows client. It doesn't seem to run when I try to use it from a telnet s…
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…
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?…
Re: Informix User Conference
The conferences are very informative. Basically, you get to see what direction Informix is heading currently and down the road. With the world moving to GIU it will be interesting to hear what direction NEW ERA will be taking. The conferences will keep you busy most of the day.…
Onstat -g ses in 6.0
Hi everyone, Does anyone know what each of the fields below from the output of onstat -g ses "SESNUMBER" represent: name free used name free used overhead 28 120 scb 0 40 opentable 0 …
Enterprise Management Summit '94 - Summit Week
The Enterprise Management Summit '94 has begun! Here is a summary of the activities for the conference and exhibition which runs November 14-18 at the Santa Clara Convention Center, Santa Clara, California. Exhibit Floor ------------------- Tuesday, 7:00pm - 10:00pm Wednesday, 1…
Summit '94 - Managing Distributed Applications
Enterprise Management Summit '94 November 14-18, 1994 - Database/Distributed Applications Technical Sessions - (Tutorial) Managing Distributed Applications Across the Enterprise - Steven Shaffer and Patrick Gallagher, SSDS, I…
Birds of A Feather Session WWUC
From glo@infmxchi Thu Jul 8 09:31:25 1993 Return-Path: <glo@infmxchi> From: glo@infmxchi (Gloria Schwartz) Message-Id: <9307081627.AA15319@infmxchi.chicago> Subject: Birds of A Feather Session WWUC Date: Thu, 8 Jul 93 11:27:43 CDT All, I will be hosting a special Birds-Of-A-Fe…