Threads from 2012
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Question of Dummy
Sorry by the following question, but I need to know if there is a table in a SP, and I not remember how it was done. The informix I use is a TD6 7.31.…
Monitoring VP_MEMORY_CACHE_KB effectiveness
Hi folks! Does anybody knows where can I find an official document (or an IIUG presentation) that shows how to set and monitor "onstat -g vpcache" effectiveness?? Thanks in advance, Alberto.…
Obtain query plans on the client (easily)
Hi all, I apologize for the publicity, but this is kind of a FAQ and I believe this can be useful. Since it's and article free of opinion, publicity, marketing etc. I hope you don't mind: http://informix-technology.blogspot.pt/2012/12/execution-plans-on-client-planos- de.html …
Can this be done? Outer join with OR where clause
IDS: 11.10.FC3 O/S: RHEL 5 I have a query in a foreach loop that originally was one table and only returned rows based on a datetime (year to fraction 4) field being greater than a value stored in another table. This query worked fine and returned the expected rows. Now I have …
Informix 12
There was a recent UK event where if we signed an NDA we could find out what is coming in Informix 12. Unfortunately I was not able to attend, does anyone know who I can contact to get this information now? Regards, David.…
Map temp tables to session
Hello, We are running informix 11.50.FC6X5. Is there anyway to map temp tables back to the original session that created those tables? We have reporting users that don't use explicit temp tables (create temp table), though they do have many subqueries and multisets. Most of t…
Map temp tables to session
Hello, We are running informix 11.50.FC6X5. Is there anyway to map temp tables back to the original session that created those tables? We have reporting users that don't use explicit temp tables (create temp table), though they do have many subqueries and multisets. Most of tho…
AUTO: Vacation (returning 01/02/2013)
I am out of the office until 01/02/2013. Note: This is an automated response to your message "unable to update = rows [29130]" sent on 12/26/2012 9:38:58. This is the only notification you will receive while this person is awa= y.=…
unable to update rows
IDS 11.50.fc6 HP-UX 11.31 PA-RISC Users are reporting that they get -271/-136 errors when they try to update an existing row. -271 is "Could not insert new row into the table", and -136 is "ISAM error: no more extents". The table is in one dbspace, which has over 2GB free, and t…
new feature in 11.50 to kill a particular userid,
HAPPY HOLLIDAYS!! The old days, we revoke connect from that userid, the capture all session ids from that user, then run onmode -z, do we now have a new feature or command to do this? Thanks…
boots, boots, boots. it's easy to fall in love with a man you don't trust, but hard live him. real, lasting relationships are built on trust.
boots, boots, boots. it's easy to fall in love with a man you don't trust, but hard live him. real, lasting relationships are built on trust. http://pinterest.com/pin/547539267166050866/…
Season's Greetings
Happy Holidays to all! May the new year bring only joy and prosperity to us all! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflec…
Season's Greetings
Happy Holidays to all! May the new year bring only joy and prosperity to us all! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not refle…
Re: 11.70.FC6 linux load from seems afwully slow.
Ahh, I hadn't noticed that. IO rates under VMWare are attrocious! If you are not using the new hypervisor (vSphere? whatever) IO rates top out at about 60MB/s. In our testing for a client we could only get a bit over 100MB/s with the older hypervisor or none at all. Art Art …
Dirty Read with Coldfusion
Hey, all. We're running ColdFusion 9 against an 11.70.FC7 instance, and it insists on using Committed Read. I set up a sysdbopen() to set it to DIRTY READ, but it doesn't seem to honor that, almost as if CF9 is explicitly executing SET ISOLATION TO COMMITTED READ (or, more like…
Re: 11.70.FC6 linux load from seems afwully slow.
Have you setup FET_BUF_SIZE? Do you see kaio threads? Don't forget that when you're "loading" you're reading ASCII and converting it. It will always be slower. A way to speed it up is to use external tables. This will be the fastest way and will solve your loading times problem.…
11.70.FC6 linux load from seems afwully slow.
Hello ALl, I am trying to optimize a load from ( actually a dbimport) Initially all unlogged and after each test dbspaces are dropped and recreated they are on a ext2 filesystem. Direct IO switched on. Machine is on debian linux vmware 4 cpus 16 GB memory. Configured are 3.000…
replication question
informix 11.70.FCx Sun solaris bla bla bla A silly question as its Christmas. Below is an extract from the IBM website regarding SQL statements permitted to be run when Enterprise Replication is active. I have a requirement to create an index on a replicated table. However a col…
Physical log size
IDS 11.50.fc6 HP-UX 11.31 PA-RISC For one of my instances, the online log file includes the following messages at startup: 19:38:04 Performance Advisory: The physical log size is smaller than the recommended size for a server configured with RTO_SERVER_RESTART. 19:38:04 Results…
onstat -g ntd -- intepretation please!
We have high number of rejections, some say it's because the applications set timeout after a certain period, but I say it's Informix that rejects those connections -- am I wrong? What approach should we take to eliminate this condition? ------------------- Solaris 10 onstat -g …
dostats compile fail
I'm having a problem compiling dostats on AIX: Using the make file (I changed it to use the AIX lines): make INFORMIXC=xlc esql -O -DHAVE_GNU_GETOPT=1 -DHAVE _GETOPT_H=1 -o ul -lc ld: 0711-317 ERROR: Undefined symbol: .main ld: 0711-345 Use the -bloadmap or -bnoquiet option to…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
DB and 4GL roadmap?
Hi , My question below is for someone from IBM please. I'm looking for a timeline , features, new releases roadmap for IBM Informix database and 4GL (+genero?) for the next 2 or 3 years. Something updated in 2012 at least. For anyone who need justify your budget this is indisp…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: 4GL Version 7.50.UC6 date format in form
I am also facing same issue after upgrading. Is there a solution to this? I assume this there is some environment setting that needs to be done. Please let me know if it can be solved. Regards Amith On Monday, August 13, 2012 6:37:46 PM UTC+5:30, sky wrote: > I just upgraded to…
Informix 11.70.FC4 (Innovator-C edition) crash on Linux
Informix 11.70.FC4IE O.S. HP-UX Version B.11.31 The crash happened after 6 months without instance stops. Memory limitation forced to 2 GB (Innovator-C max accepted): RESIDENT 1 SHMBASE 0x0 SHMVIRTSIZE 1041176 SHMADD 32768 EXTSHMADD 32768 SHMTO…
update statistics comparison
Hello, Honestly, although doing update statistics for years :-) , still not in 100% clear on some results comparisons ( the optimizer likes one better than other ....) OK. What are the major possible differences of the following two sets of update statistics jobs for a table? H…
Got Informix skills? Get a job! Check out Informix.jobs
If you are in the market for a new position using your Informix skills, then check out informix.jobs. This new web site brings together skilled Informix professionals with open positions worldwide. Today there are more than 200 positions posted worldwide. Robust search and fil…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
External tables in Win server
Hi! I am testing external tables with IDS 11.70 on a Windows-server, and get the following error: 17.12.2012 12:39 Executing statement: Create external table ext_xyz (col1 integer, col2 char(20)) USING (DATAFILES ("DISK:d:\\\\temp\\\\xyz.unl"), FORMAT "DELIMITED"); Exec Time: 0…
onpladm disable index on multiple load
Hi All, I am performing multiple load into a table using onpladm. I am able to execute the command "onpladm run job jobname -fl". It starts with disabling the constraints and loading works fast. However, at the end of the record being loaded, it is taking much time because it pe…
Re: hussyfan, illegal porn, lolita porn, preteen art, preteen boys!
Am Sonntag, 31. Januar 2010 19:20:01 UTC+1 schrieb Gabrielle Hemphill: > Hi, Mike! Look at this really young as u like http://clck.ru/tmk > > > > > hussyfan > hussyfan bbs > pthc hussyfan > hussyfan forum > hussyfan pthc > hussyfan torrent > bbs hussyfan > hussyfan blog > hussyfa…
DIRECT_IO and flags
Hello All, 11.70 FC7 onstat -d shows: 1591ee1d0 1 1 0 10000000 6942353 PO-B-D /data1/infdev/rootdbs.000 in the manual ( 11.10) it says that flag 5 says if direct i/o is enabled. i see here flag 6 being D which i assume direct io is enabl…
Question on Checkpoint Tuning How To for IBM Infor
Hello Informix gurus, I got 2 questions relating to checkpoint. 1. I've heard long checkpoint is acceptable in a data warehouse environment, but as far as I'm concerned, it's not so ok, it's been affecting the performance. In this environment, we have load jobs going on, then rep…
view query cost explanation
Hello, IDS11.50 FC8 The following is the explanation output of a query on a view: inv_np. Looks the two primary estimated costs are, (1) Estimated Cost: 1143824, For create view (2) Estimated Cost: 3799, For query So, cost of creating the view is lot higher than executing t…
Re: Unused Index Search
Just to clarify a little more. In version 11 for detached indexes you have some additional information. First you have the partitions stats in onstat -g ppf of sysmaster:sysptprof which have the isread, iswrite and isdelete which will be populated for each index item selected, in…
Re: Unused Index Search
The criteria I use to determine if an index is being used is if bfrds it significantly higher than bfwrts then the index is being "read" and not just updated. If bfrds are about the same or bfwrts is higher than bfrds then the index is not being accessed by SELECT, DELETE, or UPD…
Help with nested foreach's
Dear friends of the forum: I have a problem that is driving me crazy and is as follows: I need to cover a table with four Foreach, the principal and three assistants. This is because according to what we throw assessments within foreach auxiliary data in the table must change an…
Unused Index Search
I'm looking at index usage and have a question about onstat -g ppf output. It has both a "Reads" and "Buffer Reads" column. I have some indexes with zero "Reads" but, in a few cases, many thousands (and even millions) of "Buffer Reads". This doesn't make much sense to me if I a…
how to disable a database
there are two database on a instance. How to disable a database and left the other database enabled ? It mean that I won't allow a group of user to access the specified database temporarily.…
RE: Informix 11.50 EOL
Has anyone heard of when Informix 11.50 is scheduled for EOL? Larry…
stored procedure, cursor, and transaction
Forgot the version info: IDS 11.10 FC3 O/S RHEL 5 We have a scenario that I am not sure works by design or not, couldn't find any info on it. We have a stored procedure that acts as a wrapper for several other stored procedures. It uses foreach loop to process those several sto…
stored procedure, cursor, and transaction
We have a scenario that I am not sure works by design or not, couldn't find any info on it. We have a stored procedure that acts as a wrapper for several other stored procedures. It uses foreach loop to process those several stored procedures on a record by record basis. One of …
authenticate a user via ldap
hello, we are looking for the best (and simple...) way to authenticate a user via ldap. In the documentation, it seems possible using pam. Is it the only solution ? configuration : informix 11.70 for windows - active directory is on windows server 2003 Thanks in advance…
Why cant I create a database in a dbspace ?
11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: Downloaded via IIUG link and installed it. I created a custom DSS instance named "server" with a 128GB dbspace named "datadbs". Install wizard created a Windows user "informix". I connected to instance "server", logging in …
Getting CDR NIF ASF SEND failed error
Hi All, This is a two part question. Part 1: I have enterprise replication running on two nodes, both AIX 6.1 machines running IBM Informix Dynamic Server Version 11.70.FC5GE. I see the following errors in the online log on both machines during the same time period: 01:55:38…
Test 000-919: Informix 11.70 System Administrator
Dear All, I am planning to take the IDS 11.70 certification exam. For 11.50 I see there is a test series available consisting of 8 pdfs covering all areas for certifcation however I am not able to find any thing like this ( if it extis) for the 11.70 exam? Please help! Regard…
RE: Informix migration from HPUnix to Linux
Hello Karl. I have migrated from sco unix to linux using dbexport and dbimport utilities, they are slower, as you mentioned. In order to accelerate the dimport I edited the sql script, I cut the alter table primary key statement, specially in larger tables, first the load, and a…
db2 JDBC - connect to informix
Hi, Is possible use db2 JDBC to connect to Informix ? (ifx 11.50) The db2 driver what I download is v10.1fp1_jdbc_sqlj.tar.gz I want to connectto Informix using db2 driver into sql client toolwhat don't have support to Informix, just db2. I don't want use Optim Studio becausei…
sysadmin shrink and pack functions
can this be run on a table during the online day will it lock users out of the table being processed?…
Linked server insert error SQL server to Informix
HPUX 11.31 IDS 11.70.FC4 W2k8r2 SQL Server 2008 r2 CSDK 3.70 FC5DE One of our developers is getting an error on our SQL server that has a linked server connection setup to our Informix DB. The error is: OLE DB provider "Ifxoledbc" for linked server "CX" returned message "E4200…
server migration from windows to linuxu
hello: my doubt is about chunks. can i copy chunk files from windows to linux? can linux manage right chunk files from windows? my doubt is about to export data fully with two informix v11.7 from windows 2008 64b to linux 64b. thank you and regards. --047d7bb04cf2188a3904d02c…
Presentations from IIUG 2012 Conference
Hi, are the presentations from the IIUG 2012 Conference available somewhere (PDF/PP)? Thanks, Lauri ps. sorry if this was posted in wrong forun…
Data movement from Informix to MySQL
Hi All, I have a requirement to transfer data from Informix table(A) to mySQL table(B). Table A column name are different from that of table B. Also selective columns are to extracted from table A and pushed into table B. i would like to know if: 1. such type of data movement is…
Add more logical logs in IDS 9.4
Hi All, I'll be performing adding logical logs into our existing DB. My question are the following: 1. Do the DB needs to be in quiescent state? i believe, there's no need at all. Once i have added the new dbspaces to be used by the logical logs, i will drop the existing ones …
Unable to load locale categories
We recently had an issue with a client that has ODBC drivers on a Windows 2000 machine trying to connect to a server running Informix 9.21. The ODBC driver had been working on the client, but the client machine was shut down abruptly and has had a few issues since. One of those i…
csdk 3.70 xF6 not available
Just a note to IBM , The CSDK , JDBC 3.70 xC6 still not available to download into the "open" download session. The last version available is 3.70 xC5 ..... http://www-01.ibm.com/software/data/informix/downloads.html…
problem in synching a table between 2 informix ins
HI All, We have 2 instances using Informix 11.70.FC6 on linux. The instance on instance A is the source and the instance on instance B is the target; we are using ER to perform the sync. We have 483 tables to sync. - ERKEYs have been added to all of the tables - the replicates…
Re: Backup with Ontape very slow
There was no '-t tapefile' option in 7.xx. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, …
Re: Informix Procedures
Procedures with and external_name column filled in are simply ones written in "C" or Java and not necessarily system procedures. Similarly, any system delivered procedures written in SPL (such as the one you mention) will not have an external_name. Practically the only way to te…
Re: Informix Procedures
On Mon, Dec 3, 2012 at 4:20 AM, ECONOMIDES VASILIS < vasilis.economides@ctl.com> wrote: > I have IDS 10.00.UC6 I trust you are planning your upgrade. > and I would like to know which are the IDS > procedures/routines and which they are the user created procedures. > > I guess …
RE: Backup with Ontape very slow
It works fine - just not officially supported as STDIO didn't arrive 'til V10 AFAIK - no idea if it was back ported Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus Haarmann Sent: Monday, December 03, 2012 8:21 …
RE: Backup with Ontape very slow
Or better still pipe to another server and do the gzip there - you can easily get 100GB per hour Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jack Parker Sent: Monday, December 03, 2012 8:17 AM To: ids@iiug.org Sub…
Hey, I finally found this opportunity
Life can be bright and interesting if you want=20 it.http://lewy7.cba.pl/www.facebook.job.travel.me41.php?peshowtopic=3Dxfry…
Backup with Ontape very slow
Hello People of Forum! I have installed Informix Dynamic Server 7.31 TD6 on a Windows 2000 Server. So last Friday was the backup of it using the BrigthStor ArcServe Backup, but that day I won the same license. I tried to do the backup using ontape but I takes a long, long time. …
Informix Procedures
Hi, I have IDS 10.00.UC6 and I would like to know which are the IDS procedures/routines and which they are the user created procedures. I guess that the IDS procedures/routines are the ones that have the field sysprocedures.externalname defined and the ones that are user create…
HPL unload with a query filter
How can I alter this: onpladm create job $JOB_NAME -d $ARRAY_NAME -D $DATABASE -t $TABLE -fa -n so that I also only select he rows from $TABLE, say customer, where customer_id < 100000 Thanks Mr Lazy…
-952 oddity
We're running 11.70 FC5 on Solaris 10 u10 x86. And we're getting a -952 error (cannot authenticate) for a bunch of new users. During troubleshooting, we noticed some strange behavior. I can access the database with these accounts using a native IDS driver on Linux, but I cannot…
Re: Strange behavior : I4GL , transactions AND reports = Lost data (SOLVED)
Hi all, Like my INFORMIX version is 11.5 and it has "SAVEPOINTS" the solution to the example is easy. #----- Beguin example TEST.4gl---- SOLVED #--------------------------------------------------------- # # Strange behavior I4GL : Transactions and reports # # (c) BASE - Gesti …
Re: Strange behavior : I4GL , transactions AND reports = Lost data
Hi Art and Fernando Thanks for your answers. Now I have a possible solution ----- Missatge Original ----- De: "Art Kagel" <art.kagel@gmail.com> A: "Isidre Pons Roca" <ipons@base.cat> Cc: informix-list@iiug.org Enviat: Divendres, 30 de Novembre 30el 2012 12:25:11 Assumpte: Re: …
Re: Strange behavior : I4GL , transactions AND reports = Lost data
The cursor that's closing is the one the report module uses internally to fetch back sorted data from the temp table it uses when you include an ORDER BY clause. If there is no ORDER BY or it is ORDER BY EXTERNAL then no temp table is created, so no cursor within the report. Ar…
Re: Strange behavior : I4GL , transactions AND reports = Lost data
Not sure if I was clear enough... The ORDER BY requires the use of a temporary table... and that is affected by your rollbacks... Regards. On Fri, Nov 30, 2012 at 11:19 AM, Fernando Nunes <domusonline@gmail.com>wrote: > > > On Fri, Nov 30, 2012 at 9:30 AM, Isidre Pons Roca <ipo…
Re: Strange behavior : I4GL , transactions AND reports = Lost data
On Fri, Nov 30, 2012 at 9:30 AM, Isidre Pons Roca <ipons@base.cat> wrote: > #----- Beguin example TEST.4gl---- > #--------------------------------------------------------- > # > # Strange behavior I4GL : Transactions and reports > # > # (c) BASE - Gesti d'Ingressos > # Is…
Re: Strange behavior : I4GL , transactions AND reports = Lost data
Hi Art, Thanks so much for your quick response. I know that if I open cursors are closed when I do a "commit". But in the example I don't see where I put the cursor. TIA ----- Missatge Original ----- De: "Art Kagel" <art.kagel@gmail.com> A: "Isidre Pons Roca" <ipons@base.cat>…
Re: Strange behavior : I4GL , transactions AND reports = Lost data
COMMIT WORK will close any open cursors that were not declared to be WITH HOLD, maybe that's your problem. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own …
Strange behavior : I4GL , transactions AND reports = Lost data
Hi all, After a long fighting , we could not solve a very weird problem. In a program with I4GL transactions and reports, lost data in the report. (See example below) However, only if the report have an "order by" clause, never witout this clause or "order external by" clause.…
Fwd: SQL convert number into the date
Sent privately only by accident; not paying attention to To and Cc lines... ---------- Forwarded message ---------- From: Jonathan Leffler <jonathan.leffler@gmail.com> Date: Wed, Nov 28, 2012 at 9:40 AM Subject: Re: SQL convert number into the date To: nsimba toni <ntoni.nsimba@…
Re: Arggghhhh!!!!!!
Only for 11.7 and 3.70 stuff I believe... Regards. On Thu, Nov 29, 2012 at 11:25 PM, Art Kagel <art.kagel@gmail.com> wrote: > The IDS installer also has a commandline option to extract the old tarball > so you can do a manual install. I think it is --legacy. DOn't know if the >…
Adding chunks ISAM error 137
Hi! I have a dbspace that is almost full, and when I try to add a new chunk the operation returns an error : ISAM error 137. The explanation for this error is: -137 ISAM error: chunk table overflow. The database system administrator sees this error message. The database server i…
Overview of Technical Sessions at IIUG 2013
Hey Everybody, The Call for Presentations for IIUG 2013 is now closed, but we are still accepting sessions to be used as alternates if a speaker that was selected cannot attend the conference and use their complimentary conference pass. While we don't know exactly which session…
Continuous Logical Log Restore
If a have (stand by) Informix server where periodically do continuous logical log restore (ontape -l -C), and server get down for some reason (power off, Informix crash ...), I wonder can I bring server back from Off-line to "Fast recovery" again, or even "On-line" mode ... onini…
Re: HDR Reconstruction (with ER :-))
On Thursday, November 22, 2012 3:39:21 AM UTC-6, Keith Simmons wrote: > Hi all > > I am going to raise a case for this query but wanted to get some community > > feedback/thoughts. > > Following on from a previous thread, I have an HDR pair acting as the group > > source for a so…
Roles X remote database
Hi , Ifx 11.50 FC9X6 , AIX 6.1 We have two databasesatour system, where we work using ROLEs to manage the users . Today we have a security problem , which is caused by an IBM Security reason (looks like a Paradox...) The problem : We have the user X , databases A, B and the ro…
ER: enterprise replication sync
Hi, We are trying to migrate a database from one instance to another using ER in order to lower the downtime. The source database is on IDS 11.50 and the destination will be on 11.70.FC6 on a different machine; both use LINUX. We decided to first upgrade 11.50 to 11.70 to take…
Update statistics - best practice
Hi, I was wondering if anyone could offer any advice on statistics gathering. I know a lot of people use 'dostats' for this purpose which gathers distributions of varying resolution on all columns. I would like to look at an alternative solution where: 1. No distributions are …
surrogates file on a Windows server
This concerns IDS Version 11.70.TC6IE on Windows Server 2008 R2. I have one server that logs this each time it boots ... 06:34:23 Warning: Unable to open the surrogates file /etc/informix/allowed.surrogates. 06:34:23 DR: DRAUTO is 0 (Off) 06:34:23 Warning: Loading entries from th…
Problem creating an index using large extent size
HI, Did anybody have any problem creating an index using the new extent size clause ? Product version: INFORMIX IDS 11.70.FC6GE on Linux Here is my SQL create index statement: *create unique index "informix".fuel_stat_jour1 on "informix".fuel_stat_jour (scenario_id,date,emet…
Re: Problem creating an index using large extent s
HI Again, Forget abut my post. It was my mistake. There was no large DBSPACETEMP and the rootdbs was only 2 GB in size. It works fine. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Té…
Re: SQL convert number into the date
Probably because the wbzdatum column is an integer not a string. Cast it to a string first: SELECT ar1.artikel, ar2.wbzdatum, MDY(SUBSTR(ar2.wbzdatum::char(6),3,2), SUBSTR(ar2.wbzdatum::char(6),1,2), 2000+SUBSTR(ar2.wbzdatum::char(6),5,2) ) as Test FROM fyar1sta ar1, fyar2sta a…
Re: SQL convert number into the date
Probably the version you're using does not yet have SUBSTR. It should have SUBSTRING(), but the syntax is probably different. Please check the manual. Regards. On Wed, Nov 28, 2012 at 8:54 AM, Ntoni Nsimba <ntoni.nsimba@esw-gmbh.de>wrote: > ** > I added the statement. > my SQl …
Arggghhhh!!!!!!
I am frustrated because: 1. IBM continues to supply its products with Javashite for no good reason 2. I'm sure I've had this issue before but can't recall the solution. ClientSDK 3.50 FC9 on RHEL 5.8. How can I get this installation to work, or even do anything except give obl…
import fails on linux red hat
Linux hvgreyst23 2.6.32-279.14.1.el6.x86_64 #1 SMP Mon Oct 15 13:44:51 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux /IBM Informix Dynamic Server Version 11.50.FC9TL Software Serial Number AAA#B000000 help please import is failing when it hits a line with ^M in it - is this new line T…
Advanced Informix Performance Tuning Training - Dec 3-6 2012 - Only 2 places left!
Folks, We have nnly 2 places left! Advanced Informix Performance Tuning Course Dec 3-6 2012 taught by Lester Knutsen and Art Kagel (attend online or in person). http://www.advancedatatools.com/Training/InformixTraining.html Do you want to learn how to be the FASTEST Informix DB…
Reminder - Deadline to submit to speak at IIUG 201
Hey everybody, Just wanted to post a reminder that the deadline to submit a presentation for IIUG 2013 in San Diego is today. If you wanted to speak at IIUG 2013 and receive a complimentary conference pass, you still have time. At this time we only need your session idea and a …
Re: SQL convert number into the date
Using substr is hard because of the missing lead zero's, but I just posted a method usint to_char() to fill in the missing lead zero which will permit direct casting to a DATE. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.…
Re: SQL convert number into the date
Sorry for previous... I think something like this should work: MDY( substr(column, length(column) -3,2), substr(column,1,length(column) -4), 2000 + substr(column,length(column)-1,2) ) should work... Not pretty... but give or take some error it coul…
Re: SQL convert number into the date
I'd say something like this: MDY ( substr(column, On Tue, Nov 27, 2012 at 11:23 AM, Art Kagel <art.kagel@gmail.com> wrote: > There is no direct conversion or cast from a string containing MMDDYY to a > date or datetime type because you do not have a leading zero for dates with…
SQL convert number into the date
I have a field in a table. This field is ar2.wbzdatum and is of type number. For example 90812. I want to convert this field in date format. the result must be the date 09.08.12. how can I make my SQL statement. What function I have to use. I have written so. SELECT Date(ar2.wbz…
Logical logs backup to Disk
Was looking to eliminate the use of magnetic tape for DB archive and Logical Log backup and the need for human intervention. Back in May 2012, we had the opportunity to store information an an Avamar Backup system with terabytes of available space. It was easy to perform the nigh…
invalid kernel params linux redhat
Linux hvgreyst23 2.6.32-279.14.1.el6.x86_64 #1 SMP Mon Oct 15 13:44:51 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux IBM Informix Dynamic Server Version 11.50.FC9TL Software Serial Number AAA#B000000 Anyone know the reason for error messages below. Our admin reported them while trying…
Re: HDR Reconstruction (with ER :-))
Hello Keith, Maybe RS Secondary is something that could work for you instead of a HDR secondary. Superboer. Am Donnerstag, 22. November 2012 10:39:21 UTC+1 schrieb Keith Simmons: > Hi all > I am going to raise a case for this query but wanted to get some community > feedback/t…
Innovator-C on Windows (code page)
Hi all, I have installed Innovator-C on my Windows machine for local development. Everything is working fine. When I want to import (dbimport) a existing database with French characters, the import stops. The value of DB_LOCALE=EN_US.8859-1 and CLIENT_LOCALE=EN_US.CP1252. What is…
Re: HDR Reconstruction (with ER :-))
Keith, this is exactly the scenario described. As long as the logs on the remaining server have wrapped (ie the newest log on the down/recovered server is still online on the surviving server, then you can make this recovered server the secondary by running the onmode -s primary…
Re: HDR Reconstruction (with ER :-))
Just consider the checkpoints ... they MUST be identical. As soon as they are "independent" HDR will refuse sync up On Thursday, November 22, 2012 9:39:21 AM UTC, Keith Simmons wrote: > Hi all > > I am going to raise a case for this query but wanted to get some community > > fe…
Re: HDR Reconstruction (with ER :-))
Alexandre Thanks for this, but it doesn't cover the situation where the primary fails so secondary becomes primary, 'time passes' with transactions applied and THEN the original primary becomes available and needs to be brought in sync with the current primary before both can be…
RE: HDR Reconstruction (with ER :-))
Hello. It seems this link should answer your doubts (it´s in 11.70 Information Center, but doesn´t matter since you´re already using HDR+ER on your environment). http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.erep.doc/ids_erp_159.htm?resultof=%22%68%64%72%22…
HDR Reconstruction (with ER :-))
Hi all I am going to raise a case for this query but wanted to get some community feedback/thoughts. Following on from a previous thread, I have an HDR pair acting as the group source for a source/target installation of ER (to a different IDS version on a different OS). I can see…
how to extract all the tables in on the informix d
Hi All, How to extract all the tables in informix database not system Thank you very much Regards Baskaran…
onmonitor not working on Linux
help please IBM Informix Dynamic Server Version 11.50.FC9TL Linux hvgreyst23 2.6.32-279.14.1.el6.x86_64 #1 SMP Mon Oct 15 13:44:51 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux onmonitor not working on linux get this Program stopped at "tb4_main.4gl", line number 78. FORMS statement …
upgrade failure
This is 2nd request. Any ideas? This happened on Windows Server 2008 R2 64bit. I attempted to upgrade from IBM Informix Dynamic Server Version 11.70.TC3IE to IBM Informix Dynamic Server Version 11.70.TC6IE I had backed up the Informix folder (and the data) and did the install ove…
Creating Indexes
I have what I hope is a simple question. When creating indexes, If I create an index on a column that has null values, are those values included in the index and is it a good idea to create indexes on columns that contain null values? Listed below are the versions of Informix we…
Re: trigger instead of view
Cesar: This is a case of the old adage "when all you have is a hammer, everything starts to look like a nail." SPL is the wrong tool to solve the problem of being too lazy to hand code alters to multiple table schema as well as an INSTEAD OF trigger for a view over those tables.…
Re: trigger instead of view
Cesar: This is a case of the old adage "when all you have is a hammer, everything starts to look like a nail." SPL is the wrong tool to solve the problem of being too lazy to hand code alters to multiple table schema as well as an INSTEAD OF trigger for a view over those tables…
trigger instead of view
Hi, ifx 11.70 fc6it , Linux Need a little help to solve a situation what I don't found a decent workaround. I'm was executing few tests over the situation bellow , trying "simulate" a fragmentation/partition using view + trigger... Just for fun and as possible solution for a d…
trigger instead of view
Hi, ifx 11.70 fc6it , Linux Need a little help to solve a situation what I don't found a decent workaround. I'm was executing few tests over the situation bellow , trying "simulate" a fragmentation/partition using view + trigger... Just for fun and as possible solution for a d…
help on installing informix on Linux
Help please getting following error while trying to install informix on linux Linux hvgreyst23 2.6.32-279.14.1.el6.x86_64 #1 SMP Mon Oct 15 13:44:51 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux tying to install iif.11.50.FC9TL.linux-x86_64.tar get this root@hvgreyst23 informix]# ./…
Indexes on Null values
For oracle, I have read that nulls are not indexed. How does Informix handle null values on a column that has an index? Thanks…
Index reduction
Hi Just wanted to clarify I am correct in the assumption that it is not possible to create an index that doesn't contain all rows. I am currently compressing data using the informix compression, repack, shrink tools to reduce the size of our SAP database. However, we still end u…
upgrade to 11.70.TC6IE
This concerns Windows Server 2008 R2 64bit. I attempted to upgrade from IBM Informix Dynamic Server Version 11.70.TC3IE to IBM Informix Dynamic Server Version 11.70.TC6IE I had backed up the Informix folder (and the data) and did the install over the top of the old folder. The ID…
How does the @instance affects performance ?
Hello peps, i got in hands some relatively big app that runs in a windows .net context and works agains several ids instances. The solution of the developer was to connect to 1 ids in particular and put in every query: "select some_cod, some_des from some_db{0}:some_table..." an…
CentOS and Informix
Hi, Friends, Any comments , experiences, suggestions .... about combining CentOS and Informix. Thanks, Frank --e89a8f6426de1cfce104cea1d244…
Does anyone have experience with error message "AS
11/01/12 09:03:07 ASF Echo-Thread Server: asfcode = -25587: oserr = 0: errstr = : Network receive failed. We have lots of these, finderr explains it but I don't have a clue. What can we do to eliminate this error? Where can we modify in the onconfig or sqlhost or etc. Thanks in a…
Restore individual dbspace with ontape
Is it possible to restore an individual dbspace with ontape using only a level 0 backup WITHOUT restoring any logical logs? I have tried using ontape -r -D dbspace, and also ontape -p -D dbspace. In both instances the dbspace is restored but left "down" (and I receive messages s…
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,…
Monitor CPU usage by Informix session
We had a situation where an Informix session brought the production Instance down to its knees. We restarted the instance and it happened a second time. Here are the server details: HP-UX uxprod1 B.11.31 U ia64, IBM Informix Dynamic Server Version 11.70.FC5, HDR cluster. The pro…
New Informix home page on IBM.com
Community: IBM has finally revamped the Informix home page at ibm.com. YEAH! It is easier than ever to find things Informix. Especially check out the new pull down navigation menu in the black bar at the top of the page! www.informix.com (or directly to: http://www-01.ibm.com/…
New Informix home page on IBM.com
Community: IBM has finally revamped the Informix home page at ibm.com. YEAH! It is easier than ever to find things Informix. Especially check out the new pull down navigation menu in the black bar at the top of the page! www.informix.com (or directly to: http://www-01.ibm.co…
unload to file include date
I have a IDS 11.70 running in RedHat 5.5 , the following sql is what i do in dbaccess everyday to backup : unload to xyz.unl select * from xyz ; however , I like to backup not just xyz.unl , for example , today is 20121115 , then it would be perfect to xyz20121115.unl , and tom…
Interpreting event alarm messages
we are on 11.7.FC5 on AIX 6.1 seeing many instances of dynamic lock allocation - however, that is the only thing that gets written to the online log and the ph_alert table: "dynamically allocated 1000000 locks" however, the manual states that " if a thread attempts to acquire a …
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
Bufferpool max size in Windows Server 2008 64bit
Hi, I am installing Informix 11.70 for a DW. On my Windows Server 2008 (64bit) I have 64GB memory and I am trying to take advantage of it. I have set the following bufferpool sizes and restarted the engine, but my parameters are not respected and the actual values are much lowe…
Re: Questions about FET_BUF_SIZE
An analysis of what results can be expected from various settings and conditions can be found here: https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/fbs?lang =en_us…
Strange ...
IDS 11.70.fc3xc Aix 6.1.0 USEOSTIME=0 For some reason the time on my system and database are all of a sudden 7 hours off. The OS time is correct, and the database is incorrect... Not sure exactly when this happened, but it's been in the last couple of days. Have to restore my …
SGLHosts
X Posted Hi I've trying to find out the effects/impact of changing the SQLhosts file on a running engine. Background. I have a live running engine on a server and want add a second instance to undertake some testing. Obviously this will need entries in the SQLhosts file, can I m…
SQLHosts File
Hi I've trying to find out the effects/impact of changing the SQLhosts file on a running engine. Background. I have a live running engine on a server and want add a second instance to undertake some testing. Obviously this will need entries in the SQLhosts file, can I make these…
Same server name on the same host
Version : ids 9.4 Can I set up 2 instance which has the same server name ? What if I set 2 different SQLHOSTS files ?…
Error # 40002
Hi, We are running ERP system (written in Visual Basic) on IBM-AIX (P560)[AIX version 6.1] using informix 11.70. To conect to informix database we use DataDirect ODBC (ver 4.10.0030) Lately we are getting (randomly - not everyday) table dropped message Error Number: 40002 Erro…
on External table
Hi, It seems inserting into a external table will overwrite its existing contents, correct? Can we avoid this( i.e., keep existing rows)? Thanks, Frank --14dae934105530a73504ce539628…
RE: Ontape
IDS 11.50.FC5 on Solaris 10 I thought that I heard a while back that ontape can be used to back up an instance, and restore the instance to a different instance on the same server. Am I remembering correctly or not? If not, can a database be restore from an ontape backup to a dif…
Dbschema bug:
Informixers: I just discovered a bug in dbschema. If you have any external tables that are defined as FORMAT "INFORMIX" dbschema will hang permanently after printing out the DDL for the first such table. If you run into this problem before a fix is released by IBM (already repor…
Dbschema bug:
Informixers: I just discovered a bug in dbschema. If you have any external tables that are defined as FORMAT "INFORMIX" dbschema will hang permanently after printing out the DDL for the first such table. If you run into this problem before a fix is released by IBM (already rep…
how to restore a dbspace that is NOT down...
Chunks that associate with the dbspace are NOT down but one of them is in inconsistent state, I tried to restore just the dbspace by: onbar -r dbsname1 but it says 2012-11-09 15:27:45 20223 20215 (-43394) Storage space dbsname1 is not down so it will not be restored. 2012-11-09…
O/S requirements for CLR
Informix 11.50.FC6WE, HP-UX 11.31 PA-RISC We are considering using continuous log restore (CLR) as a low-bandwidth option to keep our off-site disaster recovery system updated. The hardware is similar at both sites. Both have HP-UX 11.31. The question is, how closely do the two …
Develop question
Hello: I don't know where i should post this question, please suggest me. My issue is at linking time. I', trying to develop an example program from c++ use as compiler g++ in Linux without any problem but where I try to compile and link the same sample source code in wind32 us…
SERIAL behavior CDR_SERIAL
OS : AIX Version : Informix 11.7 xC5 Environment : Flexible Grib Rule of replication : Apply all for all server. My client is intended to move their existing DB from XXXX to Informix 11.7(Flexible Grib) environment. There uses lots of auto numbering as their primary key (simila…
Informix migration from HPUnix to Linux
Hi, IDS 11.50.FC8W2 on HP-UX B.11.31 U ia64 We have the following a part of MACH cluster Primary Server 2 SDS nodes HDR We are planning to migrate our Inofrmix databases from HPUnix to one of the Linux flavours. I understand that we need to do an import export (using HPL)of d…
Indexes contain multiple extents after reorg
Informix 11.50.FC6WE, HP-UX 11.31 PA-RISC. I have a process in place that periodically drops and re-creates indexes to consolidate multiple extents into a single extent. For most cases, this works fine, but there are several indexes which end up with exactly the same number of e…
transaction count
Hi, In IDS 11.50.FC8, how can we capture transaction count per interval as hourly or daily? The onstat -x only provide active transactions at the moment. thanks…
ER - How many times a table has been replicated
I'm trying to find out which tables are most active in Enterprise Replication, anyone have any ideas? Am I just missing something really obvious? Thanks, Andrew…
Registration for IIUG 2013 Now Available
Hey Everybody, Just wanted to let you know that registration for IIUG 2013 in San Diego on April 21-25, 2013 is now available. Registering before January 17, 2013 will get you a nice discount of $225 off the regular conference price and registering as an IIUG member will give y…
Packets Betwwen the Application and Database Serve
Hi To ALL, =20 =20 We have IBM Informix Dynamic Server Version 11.50.FC3 on the database server and on the Application server Genero 2.21 . =20 We put the wireshark to trace the packets between the application and the database server. =20 Wireshark =E0 open the iptrace fil…
Tracking down a transaction isolation issue
I am trying to fully understand a scenario in Informix that has been bedeviling me for a long time. To be clear I am sure the error is mine but I want to understand why I am seeing the behavior I'm seeing. In the following scenario I am using an isolation level of "5" (READ LAS…
Re: $70,000+ I4GL/PA in Philly,PA (PT telecommute)
On Monday, April 13, 1998 8:00:00 AM UTC+1, David K. Killough wrote: > please call 609-764-7264 and lease a message - will respond promptly!!! Hello, I'm a Informix 4GL analyst and developer with 5 years of experience. Are you looking for a analyst/developer with knowledge in in…
Sequences & Locks
Hello We hit a table extensively (and with multi threaded) for a next key value to be returned and of course it is running into deadlocks, etc. We are looking to move this to sequences - are there locks involved with sequences in a multi threading scenario? thanks tom…
Need backup advice
I was hoping I could get some advice on choosing between ontape and onbar. I am familiar with the basic differences in the two. What has me concerned is that I've been reading chapter 7 of Carlton Doe's book Administering Informix Dynamic Server where he mentions that "developme…
Looking For a Position
All, Before y'all jump all over me, I know this is not a job board but I am in need of new employment (customer contract was terminatedm - nothing to do w/me). Informix DBA would be the best match. For thosde of you who do not know me, I have an extensive background in Informix …
Informix Performance Tuning Technical Training Day - Next Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. Last chance to register. We have limited space and there are only a few spaces left. Please register at the link below. Date and Time: Thursday, Nove…
Re: Question on Disk errors
Laurie: see below: Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other…
Question on Disk errors
Has anyone seen these type of disk errors with IDS?? this is a new server and it would be great to get things set up as best we can from the beginning. Any feedback is appreciated :) We have IDS11.70 Direct IO = 1 The error I'm seeing is EXT4-fs (dm-13): Unaligned AIO/DIO o…
IDS 10.00.FC11 on Sun 5.10 - Informix audit issue
I am trying to diagnose why we are seeing extra audit log entries for certain remote sessions and have found the following so far: 1) Only some of the sessions from this specific remote server (same user id) generate RDRW log entries, which should not be audited due to audit mas…
Sandy
We were all very sorry to watch the devastation caused by the storm and wish all those living in effected area in US and Canada, a rapid recovery. Mehdi Afshar Querix http://www.querix.com/…
Re: Where are the Informix online manuals?
There are only a few things in terms of work that anoy me more than these glitches of the IBM Website. And yes, this means I think they're too frequent. But in any case extrapolating the glitches to assume an "IBM policy" is going too far... The links are working now and the set …
anal desire assauged
anal desire assauged http://www.google.com/search?hl=en&q=anal+desire+assauged+site:ahoqotapoleryhi.blogspot.com&btnI=I%27m+Feeling+Lucky…
WTB: WE BUY SOFTWARE MICROSOFT, ADOBE, SYMANTEC, & LOTS MORE. WTB: WE BUY SOFTWARE MICROSOFT, ADOBE, SYMANTEC, & LOTS MORE.
WTB: WE BUY SOFTWARE MICROSOFT, ADOBE, SYMANTEC, & LOTS MORE. WTB: WE BUY SOFTWARE MICROSOFT, ADOBE, SYMANTEC, & LOTS MORE. Microsoft Office, Server, Windows & others. Adobe Acrobat and more. Symantec Norton Antivirus and more. I am also buying software listed below as well. I a…
Re: Where are the Informix online manuals?
On Thursday, 24 June 2010 22:08:21 UTC+1, LIGHT SCANS wrote: > I've tried my old links, Google searches, IIUG, and the IBM websites. > The closest thing I can find is the InfoCenter stuff. Where are the > free manuals that I can download to my PC? > > Thanks, > L.S. I found th…
kenza double drilled in stockings
kenza double drilled in stockings http://www.google.com/search?hl=en&q=kenza+double+drilled+in+stockings+site:liljhomtw125.blogspot.com&btnI=I%27m+Feeling+Lucky…
Increased Swap usage by IDS
I am using Informix 11.7 and I had to increase the DB Size. But on increasing the Db Space, I can see swap memory being used on my system (in my environment DB shares memory with many other applications). Earlier there was no limiti on SHMTOTAL but I changed it to 1 GB. But still…
Re: Password encryption
AFAIK Informix always calls the crypt() function, with the provided password to obtain the encrypted version and then checks if it matches with the stored encrypted version. I believe that crypt doesn't follow the alghoritm that was defined. The only workaround I know would be t…
Password encryption
We are running AIX 6.0 TL7 and Informix 11.50 .FC9XA. InfoSec has requested that we change from an MD5 encryption to a SHAH256 to pass audits. We have done this and now we have issues with passwords which are encrypted with SHAH256. When we reset the user to use MD5 it works but …
C4gl link error on new install
I'm installing c4gl on SUSE Linux Enterprise 11.2 This is IDS 11.70.FC5 with the 7.50.FC5 4gl developer. I am getting this error, and I have no idea what it is wanting...and the internet is not any help. Error is: /snc/informix/lib/tools/i4glc2: symbol lookup error: /snc/info…
memory free pct ?
Hi, have found this query for get the IDS free memory, first 2 terms shows ok, but i tried to add the third, i want the PCT (%) of free memory, but shows bad number: SELECT format_units(sum(seg_size)) as ifx_memory_allocated, format_units(sum(seg_blkfree),4) as ifx_memory…
Implementation of Informix on 3 hdd
Hi guys, I'm looking for your view about a physical implementation of Informix. I want to implement Informix 11.50 on 3 hdd for a better performances , but my aim is also to have a crashproof system with solid performances. The goal is to maintain the instance working even if a…
I have a puzzling situation
HPUX 11.31 on BL8709c Integrity server IDS 11.70.FC4 A little over a month ago we upgraded to 11.70 and the developers say that since then some users have been having problems executing procedures that have the SYSTEM command in them. One of the developers has created a test pr…
Re: Fwd: Testing [28650]
Dear Karl, On Thu, Oct 25, 2012 at 2:36 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > For what it's worth I have never had an email regarding any posts I have > placed > on the OAT forum > Taken literally, that's definitely an exaggeration. However, for recent posts, you'r…
anyone using Netapp
HPUX 11.31 on BL870c Integrity server IDS 11.70.FC4 Five years ago when we refreshed our ERP HPUX server due to the limited number of hard drives on the server we moved our Informix DB to a HP EVA4400 SAN on a RAID10 lun. We are starting to look at new refresh and at this time t…
Re: study material on informix 11.5 or 11.7
In addition to Carlton's book and Art's training classes, you can go to my blog, informix-dba.com. I have a couple of pages there devoted to the first time Informix user to help them get the engine installed and do some basic performance tuning. They are targeted for Innovator-C …
Re: study material on informix 11.5 or 11.7
You can download the PDF Informix manuals from: http://www-01.ibm.com/support/docview.wss?uid=swg27019520 Once you are on that page, scroll down to "*Documentation sets to download*" to download the entire documentation set. Start with the Administrators' Guide and Administrator'…
Re: study material on informix 11.5 or 11.7
Well I can recommend a very good book for those new to Informix. It's = called Administering Informix Dynamic Server: Building the Foundation. = You can get it at Amazon here: = http://www.amazon.com/Administering-Informix-Dynamic-Server-Foundation/dp/= 158347076X/ref=3Dsr_1_3?i…
News Software. Get TOP in the mass media and SE.
News Software. Get TOP in the mass media and SE. Multithreaded submitting: over 500 running threads possible! Software can registration and posts message, able to work with lots of different types of resources. Over 200. Automatically fill in the required fields. The powerful bu…
Fwd: Testing [802]
Hmm, I just posted the message below to the OAT forum and I saw it come back into my email account (see below). It seems to be working. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind tha…
Help selecting a subject for the 2013 IIUG Confere
Community: I have already submitted one *new* session for this coming year's IIUG conference, but I was interested in knowing if there is sufficient interest in repeating any of my older sessions. Here's a list. If you are considering attending the conference in San Diego this c…
Help selecting a subject for the 2013 IIUG Conference
Community: I have already submitted one *new* session for this coming year's IIUG conference, but I was interested in knowing if there is sufficient interest in repeating any of my older sessions. Here's a list. If you are considering attending the conference in San Diego this…
onmode -z does not seem to actally terminate the s
Art/Jack/John/Reinhard/everyone else: OK so I did an insert into an external table (350mil rows) -- done beautifully, took 1hr18 min. I, however, did it to "PIPE" instead of "DISK". Using pipe allows me to compress the output file. So my "external table" is little different, I sh…
tribute to wvlovegirls
tribute to wvlovegirls http://www.google.com/search?hl=en&q=tribute+to+wvlovegirls+site:ninelirowaytu.blogspot.com&btnI=I%27m+Feeling+Lucky…
Locks, locks everywhere
Hi people, asking from help again, hope you all doing fine. In 1 of our [data] servers we average more than 1000 users, there are informix 4gl applications, odbc and .net (sqli), the problem is there is some application's concurrency that cause a lot of locks, and you know bette…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
OAT forum - dead ?
Does anyone know if the Open Admin Tool forum is dead now. I see no activity for over a month. The experts that used to contribute dont anymore.…
sysadmin:ph_alert cleanup
HI, IDS 11.50 FC8 Looks IDS does not cleanup ph_alert table automatically (correct? ) and it grows quite bit and takes up disk spaces... Any suggestions on its cleanup job? Thanks, Frank --e89a8f6464eb9aac7804ccad1b31…
Loading tables in XPS
We have a very old server running XPS 8.21.UD2X2. I am currently running a load of three tables from files using the following format: load from <tablename>.unl insert into <tablename> These loads are approaching 48 hours of being run, even though two of the unload files are ar…
Informix Performance Tuning Technical Training Day - Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. We have limited space and there are still few spaces available. Please register at the link below. Date and Time: Thursday, November 8th, 2012, 9:00am …
archecker and BACKUP_FILTER
Please excuse if asked and answered before: My BACKUP_FILTER AND RESTORE_FILTER in $ONCONFIG are set: BACKUP_FILTER /bin/gzip RESTORE_FILTER /bin/gunzip When I wish to do a restore to a "point in time" with archecker, I get the response as set out below. Is this then to say tha…
old fashioned fetish
old fashioned fetish http://www.google.com/search?hl=en&q=old+fashioned+fetish+site:gmquckbor972.blogspot.com&btnI=I%27m+Feeling+Lucky…
Sql cost order by too hight
hello we have and sql to order name and surname but it's too slow. how can i improve it in order to speed up? should i add a huge temp dataspace? this query returns 500k rows and in this table there is 500m rows in a fragment mode. regards --00248c6a6736a08fe004cc6be76b…
Error by Auto Update Statistics
Hallo, IBM Informix Dynamic Server Version 11.70.UC5X4 Linux 2.6.32.59-0.3-default #1 SMP 2012-04-27 11:14:44 +0200 x86_64 x86_64 x86_64 GNU/Linux I see every night this error in the online.log: 01:00:04 SCHAPI: [Auto Update Statistics Evaluation 32-41] Error -1265 Overflow o…
Re: Ask about page size in Informix 7.31
OK, actually 4K on Windows, AIX, and OS/X (Mac) but 7.xx did not support Mac. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect o…
Re: Ask about page size in Informix 7.31
I stand corrected On 19 October 2012 11:36, Art Kagel <art.kagel@gmail.com> wrote: > No. 4K on AIX and Windows, 2K on every other platform. > > Art > > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: P…
execute function estimate compression
Hi I have run compressions on many tables in my database, always running them from the sysadmin database using dbaccess. However, I have a table which is owned by a different user (sapr3), and I cannot get the following to work . EXECUTE FUNCTION task("table estimate_compressio…