Threads from 2014
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Attach fragment from a table in another database
Hi Folks (capitalized! :-) My client just asked me the wildest question: > if there is a fragment associated with one database like dbase_1@my_server, > can that fragment be detached and moved to another table on another database > like dbase_2@myserver? Actually, he asked if…
SQEXPLAIN output
Hi, I have the output of optimizer for the below query: QUERY: ------ select count (distinct cc.cust_id) from subscription s, accounts a, cus_contact cc where A.cust_id=S.cust_id and a.cust_id=cc.cust_id AND (s.term_date < date('03-07-2000') - 2190 units day ) and (a.end_Date < …
onpassword
Hi, I have kind of a dumb question - when we set up a cluster, on the primary I used onpassword to generate $INFORMIXDIR/etc/passwd_file, but then for the other servers, we just copied the passwd_file. So...how does the secondary know what access key to use to read the file? -J…
Faster Dbimport
Hello Forum People! What is the best ONCONFIG configuration file for a dbimport a database that has a size of 60GB flat format ?. The server is an IBM x366 with a quad-core processor, 8GB of RAM, and fiber channel disks 2 Gbits / second. The engine is a Windows TD6 IDS 7.31. …
Trusted context.. error
HI, See the error in log of the newly upgraded . Any comments ? Thanks Frank IBM Informix Dynamic Server Version 12.10.FC4W1X1 -- On-Line -- Up 05:09:12 -- 5592776 Kbytes Message Log File: /dbbackup/online_log/online_pal.log 21:00:01 listener-thread: err = -28021: oserr = 0: er…
Intermittent DNS failures
While this is probably not primarily an Informix question, it is impacting our users' ability to establish a database connection and causing a great deal of 'pain' and I am looking for any help I can get. IDS: 11.1FC3 OS: RHEL 5.11 on VMWARE Our configuration has been in place …
ifxclone
Never used this, but one of my boys suggested it for the establishment of a long-distance RSS where we knew it would take many, many hours, but needed to keep onbar logical log backups running on the Primary. IDS 11.70FC7 and FC8 on SuSE Linux. What are your experiences? What …
query to find partition size in fragmented table
How can we find the size of a partitioned table in term of extents or pages allocated. For non-fragmented tables we can get the results as provided in following link: http://www.informix.com.ua/articles/sysmast/sysmast.htm But these queries do not work for fragmented tables.…
About cdc api and spatial datablade
Hi, forum! I did working ok with cdc api on standard tables. But, I need to access with cdc api (cdc_startcapture) to tables with st_multilinestring columns or similar. When I did execute the cdc_startcapture, I'm receiving the message: CDC API 'cdc_startcapture' Failed at cdcap…
Re: External Table + zipped files..
In my googling on this topic, I ran across this discussion. Since i just got it working, I'll post the key elements: do_system("mknod " . $opath . "/foo.p p"); unless (fork) { do_system("gunzip -c " . $opath . "/" . $tb . ".gz > " . $opath . "/foo.p"); } do_sql($db,"insert i…
Re: Re: Re: Re: Re: 908: Attempt to connect to dat
My suggestion then would be: 1) As the db server goes up then I assume the sqlhosts files on the server is fine. However, check the sqlhosts file on the client......to see if for any strange reason it has some special characters .....so you open it up with vi then you use set li…
Re: Re: Re: Re: 908: Attempt to connect to databas
okay Giles change your sqlhosts *on the server* instead of the service name just specify the port number 15038 (as I have specified below). Then stop the db server and start it up again. Then try to connect. hdbafdba_tcp onsoctcp hmba04 15038 On 17/12/14 11:27, GILLES TCHAPPI …
Re: Re: Re: 908: Attempt to connect to database se
Hello Giles, Yes I understand that. Now, can you please reply this posting just the sqlhosts from the server and the client. is the below the sqlhosts file that you have on the server? hdbafdba onipcshm hmba04 hdbafdba_net1 hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 hdbafdbasr…
Accent Insentitive searches
Hello friends!! Please, how can I setup my instance to work with accent insensitive text search? Something like SQL_Latin1_General_CP1_CI_AI collation on SQL Server. Cheers…
Re: Re: 908: Attempt to connect to database server
Giles I think you missunderstood my comment. I meant to remove the port number in the sqlhosts file and replace with the name that you have in the /etc/services. YOu do not need root privileges to do that. You can do it as informix user. The changes I am talking about are on th…
Re: 908: Attempt to connect to database server (hd
Try replacing the on the client the 15038 with hdbafdba_net1 in the sqlhosts file. It is a bit confusing how you posted the below files. If the above does not work just post sqlhosts, hosts and services from the client and the server. thanks esteban.- On 15/12/14 14:41, GILLES…
908: Attempt to connect to database server (hdbafd
Hi, When trying dbaccess connexion from a Informix CSDK 410FC4DE running on RED HAT 2.6.32-358.6.2.el6.x86_64 to IBM Informix Dynamic Server Version 11.50.FC9 running on AIX 5.3.0.0, I have the following message : informix@PBDDLX03: # dbaccess sysmaster << EOF (suite)> select n…
Windows Authentication for Informix Mapped Users
This is the Part 2 to my earlier question on how to permit Win Active Directory authenticated user to access Informix. I have initial guidance from Fernando Nunes to use the 'Mapped Users' feature available on Informix v11.70.FC7. I also have a high level understanding now of ho…
ODBC 42000 Error
I am trying to connect to an IDS 11.70.FC4 database on SLES 11 via ODBC from a Windows 2012 R2 server. Iâm using the 64-bit 4.10 SDK, but Iâve also tried 3.50 and 3.70. I can connect to the database and execute queries fine. However, I have one vendor provided synchronization…
onmode -b
HI, I want to upgrade ids from 11.70 FC4 to 11.70FC8. I am writing the proposal. Could I use the command 'onmode -b 11.70.xC4' to do the revert. thanks for your time.…
XML functions
Hi community. Do you have experience in using XML functionality in IDS 11.50? There are a sample .NET program and stored procedure later in this topic. The problem is - the program starts 100 parallel threads with test_existsnode functions. As a result existsnode function execut…
Moving BIG smart large objects
Hello, I need recommendation how to move BIG tables with CLOB/BLOB between to physical servers in effective way. We have system where data layout (schemas) will be changed (reason is - to optimize it in respect of current requirements) This source system (current production) ru…
Root db space fills up
We have experienced an unusual problem after a software delivery. The root db space in one of our instances gets full and then goes back to its normal state. This made us believe that it gets filled up by temporary tables used by querys for sorting etc but there is a catch since…
Rename a partition
Greetings. I may let the IBM manual writers off the hook on this one owing to a 12.1 manual when I'm using an 11.5 server. I'm trying to rename a partition within a fragmentation strategy. My practice table, before I try this surgery on the production server, is defined as: cre…
Re: Informix 12.10 snapshot [34292]
Georgi, yes that is possible. I did it for a couple of customers with older informix versions and EMC disk arrays over 10 years ago. You might need to have some considerations depending on your chunks names and other things but it is doable. I am not sure what you meant with y…
Informix 12.10 snapshot
Hi all, I want to ask is it possible to use SAN snapshot functionality to clone my Informix 12.10 server? I want to make clone of my server every night and to have "fresh" copy of the instance in the morning on 2 other instances - one on same host and one to another host for back…
CDR question on big transaction
HI, I config the single direction CDR system. IDS version is 11.50FC7 When the application execute below SQL to delete about 600000 records. delete from japf10 where tdate='20141203' the row size is 688 bytes for single row. onstat -g nif show CDR is in 'RUN,BLOCK' state, an…
ALTER FRAGMENT adding multiple fragments
Hi again. I am trying to decipher the manual pages on how to add fragments to a fragmented table. The syntax that finally worked was two separate ALTER FRAGMENT statements. But that's the cowards way out IMO. Here are some of the syntaxes that failed: ---------------------------…
About CDC api usage
Hi! I'm working in a little project with cdc api. My question is: Is it posible to obtaing the where columns in the delete and update operations? Is it posible to obtaing the rowid of the record deleted or modified? Thanks jorge infante rosario - santa fe - argentina…
ALTER FRAGMENT to a dbspace with a differnt page s
Greetings. My client has a monstrous table fragmented by expression. (half-year intervals but that's not important to the point) Well, this one partition has reached the limit of 16,777,215 pages - the maximum 24-bit page number in a rowid. And his dbload job dies with a "no mor…
Windows Authentication for Informix on UNIX
Is it possible for a user to use his/her Windows Authentication ( Active Directory) to access Informix running on HP-UX. If so, how is this done? We are running Informix 11.70.FC7 on HP_UX B.11.31 U ia64.…
Windows Authentication for Informix on UNIX
Is it possible for a user to use his/her Windows Authentication ( Active Directory) to access Informix running on HP-UX. If so, how is this done? We are running Informix 11.70.FC7 on HP_UX B.11.31 U ia64.…
Last page of first extent in a partition
Is there something special about the last page in the first extent of a partition? It is marked as a full data page in the bitmap (bitmap value of 12), but oncheck -pP shows the page to be free and the raw data looks free (0000 0000 ffff ffff). Thanks, Andrew…
getting the serial value
All, Informix 11.50 I have a colleague who is inserting into a table with a serial column. He uses the value 0 for the serial column. He wants to know what value has been assigned. He is using C++. Can anyone tell me how this can be done? Is it using something like sqlca.sqlerr…
speed up ontape -r
HI, Folks, 11.50 FC8. Our ontape -r( restore a full backup level 0) is taking more than 3 hours to run, any more options to make its running faster ? Thanks Frank --001a1139126c6a26dd05093175c7…
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=…
Long Blocking Checkpoint Duration And IDS 12.1 Msg
Hi, We are suddenly getting very long checkpoint durations. I would like to ask if any of you have encountered this error message ? We are already using the latest build of informix 12.1 Thank you. 15:32:31 Physical Logging during partition extend: Number of bit map pages to…
how to make LockWt utility under Windows 2008
Hi, I want to make lockWt utility working under Windows 2008. any helps please. thanks…
systables data ids 11.50 FC8
accidentally delete data systables, but I have a file with the data in the table, as I can reload them again…
setup LOG_STAGING_DIR
Hello, any one have a idea about setup LOG_STAGING_DIR. can any one explain step by step with rss. in informix 11.70 Thanks…
aus_work_info
HI, Folks, 11.50 FC8, log has , 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -206 The specified table (aus_work_info) is not in the database. 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -111 ISAM error: no record found. Opinions ? Thanks…
Problem with a upgrade 11.7FC7W1
Hello everyone I updated some of my instances : After wards my tempdbs fill up like 40 gigs holy S#$%@ it was th_probe_ffffffffffffffff and th_build_ffffffffffffffff in database HASHTEMP in this instance I got this error from OAT when opening storage : specified table (storagep…
ER time to define a replicate in 11.50 and 12.10
Folks, In 11.50 FC8, it only takes 1 or 2 seconds to run the following to define a replicate in three sites, cdr define replicate --conflict=ignore aip_inv_iasi1c_repl \\\\ "noaa@g_nsofops101:informix.aip_inv_iasi1c" "select * from aip_inv_iasi1c" \\\\ "noaa@g_ncdcops101:info…
ER and TEXT type
Folks, IDS 11.50 and 12. 10 There is a table T1( c1 int, c2 char(10), c3 text), and table T1 is ER replicated. If we update column c1 or c2, will the c3 column ( big TEXT data) be replicated too ? If it will, can we control it? Thanks Frank --001a11c3d284437f7b05089c18da…
HDR - after pri upgrade 12.10.FC2 to 12.10.FC4W1
Hi, OS - HP-Unix B.11.31 Environment primary HDR SDS connection manager Upgrade from 12.10.FC2 to 12.10.FC4W1... Why do I have to rebuild the HDR by restoring the level 0 after I upgrade the informix from 12.10.FC2 to 12.10.FC4W1. I though FC2 to FC4 comes under same major v…
Session Idle Time
Hi, We are running Informix 11.70.FC7 on Solaris. Does anyone have a SQL that will display how long each session has been idle? Thank You, --Dave --001a1134d03428c92a05084c6343…
11.70 data page slot table
Can anyone tell me what I'm looking at and why? 11.70 2K data page, row size is fixed at 155 bytes after in place alter (12 rows per page), previous row size was 151 bytes (13 rows per page), page has been updated after in place alter. last 64 bytes of the 2K data page: 000000…
Windows 7 CSDK install not installing .net provide
This is a bit off-topic of what is usually on this list, but I'm having a problem installing the CSDK on windows 7. Specifically, I'm installing 4.10.TC4DE and 4.10.FC4DE side-by-side. My problem is that the IBM.Data.Informix.dll file doesn't make it into the GAC (neither x85 or …
btrFS
We have just started testing Open Suse 13.2 and perhaps this is the time to start evaluating performance on this filesystem. Has anyone done any testing with this? Any whitepapers out there? I read somewhere that ext3 is quicker than ext4 and ext2 is quicker than ext3. Our curr…
Fwd: Number of bit map pages to be logged in critc
---------- Forwarded message ---------- From: FRANK <yunyaoqu@gmail.com> Date: Sun, Nov 16, 2014 at 6:45 PM Subject: Fwd: Number of bit map pages to be logged in critcal section To: Art Kagel <art.kagel@gmail.com>, Fernando Nunes <domusonline@gmail.com> I believe my following em…
Number of bit map pages to be logged in critcal se
Folks, Build Version: 12.10.FC4W1X1 What does " Physical Logging during partition extend: Number of bit map pages to be logged in critcal section: 222 Remaining Phyical Log: 1659413" mean ? Thanks Frank 04:15:20 CDR Spool transaction queue completed 04:16:41 Logical Log 18192…
unsubscribe me
-- Kind Regards -- Sophia Alikhani…
please unsubscribe me from your group
-- Kind Regards -- Sophia Alikhani…
Logical Log Files are Full
Hi all, We are in the situation. Please take a look to see if you can help. We are running IDS version 11.50.FC8GE in HPUX 11.11. Weve been having issue with backup system and now our logical log files are full now. The backup system is still down and we want to redirect our b…
DBexport -9810 error
Hi All, I've never experienced issues with dbexport before, but this is a doozie! Informix 11.50.FC9 SunOS Solaris 10 The dbexport is kicking back a "-9810 - Smart-large-object error." but with no secondary error message. I believe this error has to do with possible corruption …
where can i find Arts article on san disk write c
Hello I understand Art has written a good article on san disk where can I find it please. Also what are people opinions about have disk write cache enabled on windows servers ?…
Need Count of Data Pages in Database
Hi Folks, IDS 11.70.FC8 O/S AIX 6.1 I need to know how many data pages I have in my database taking into account 3 different page sizes. Does anyone have this sql readily available? IE, how many 4k data pages, how many 8k data pages, & how many 16k datapages I have. I do not wa…
find tables access user
Hello, i have a table call acc_xxx and i want to drop it but it says i has lock. so how can i find particular use who access table?? when i run onstat -g ses | grep table_name the output is like follows select * from acc_xxx ( table name) select * from acc_xxx ( table name) t…
ipcrm behavior
Hi all, I'm looking for some feedback regarding the ipcrm behavior. I haven't used it much since we now include onclean, but I had the feeling that a long long time ago, in a galaxy such as this if we tried to remove a shared memory segment with attached processes it would fail.…
Master daemon died when execute onunload
Hello: Runnig onunload on a production environment get to crash the master daemon with no error in the log. Trying to execute this backup another time gives me the same result, I dont't know how may i sort out? Regards. --001a1140e2c83b420105079867f4…
Can not delete index
IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 11 days 01:23:42 -- 24478656 Kbytes DROP INDEX 773_1045; returns: 201: A syntax error has occurred. We are moving from 11.7 to 12.1; the new servers are up and functioning, replication is online and working; all tha…
best index method for heavy update and read table
Hello, any one have a experience about best index method for table which has heavy updates and read continues and long time. currently table has column by column index for several column but users facing slowness every time so what would be the best way to avoid this issue. Tha…
restore question
Hi all, Is it possible to restore a backup from a 3rd party (Netbackup) into a new FS and get it the data from there using onbar?…
Resolving In Place Alters
11.50xC4 Is there a better way to resolve in place alters than blindly updating every row in a table with pending in place alters? I would like to identify pages with pending in place alters via sysmaster and perform a dummy update for just 1 row that lives on that page if poss…
BAR_MAX_BACKUP
Hi, Good Day we tried increasing the value of BAR_MAX_BACKUP from default (1) to 4 to increase the number of streams when running the backup to speed up the process. My question now is how can I really verify that the value was indeed changed I mean other than backup should be …
query sqlexplain interpretation
Hello: CAn someone helps me to understand why this query takes 35 seconds? Thank you. QUERY: (OPTIMIZATION TIMESTAMP: 11-05-2014 10:32:41) ------ select c.items,b.muestra,b.prueba,b.valor,b.comentario,a.fecha,a.sid,a.pid,a.demo4,a.de mo9 from adatos a,avalor b, pruebas c where…
dbaccess with drsoctcp???
Hi Folks, IDS 11/70.FC8GE Linux 2.6.32-358.el6.x86_64 Is it possible to connect to the database using dbaccess while using a drtsoctcp connection? If so what do I need to do? thanx, dan…
SQLERR in 12.10
Folks, Any comment on the following SQLERR . The instance is just converted from 11.50 FC8 with in-place upgrade. Thanks Frank [informix@nsoopsdba101 etc]$ onstat -version Program Name: onstat Build Version: 12.10.FC4W1X1 Build Number: N028 Build Host: lxvm-l172 Build OS: Linu…
test
test --089e0158b34cd862290506fa04e4…
onbar: imported restore, point in time?
Hi all. I need restore an old backup of my production servers. Let's talk about two servers: - INFORMIXSERVER=idsold, SERVERNUM=10 - INFORMIXSERVER=idsnew, SERVERNUM=20 Both running identical O.S. and IDS releases. Copied these files from idsold to idsnew: - ixbar.10 to ixba…
"cdr define repl"-Problem after migration to 12.10
Hi All, IBM Informix Dynamic Server Version 12.10.UC4W1 (after migration from 11.70.UC7W3) OS: Suse Linux Enterprise Server 11 SP1 We have a Enterprise Replication Environment with 15 Server`s with update anywhere. Our Replicate defintions are inherited from the IDS7.31th-World…
Error Message in online.log file
Hy everyone, I really don't know what is different in my environment now, but I since 3 weeks ago my online.log always get the follow message 07:45:54 Logical Log 91859 Complete, timestamp: 0x6f159f6f.07:45:54 execve() of "/bin/sh /bin/sh -c /informix/IDS/etc/alarmprogram.sh 2 23…
Checkpoint blocked by a previous checkpoint
Hi folks. I have a situation that I suspect but can't get IBM to confirm or deny. Thus, I'm requesting a peer review that my logic is correct and a likely explanation of a blocked checkpoint. Solaris 10 IDS 11.50.FC3X5 This is what I think happened: My client's production box…
IO Wait and PDQ
I have a session running against Informix 11.7 FC7 database. The SQL is running a join against 2 tables, each with 10 fragments a piece. 1 of these tables is stored under cooked chunks due to the sensitivity of contained data. The user specifies SET PDQPRIORITY 4 prior to startin…
PACER Question ...
Does anyone on this list work for the Federal Government on the PACER (electronic court) system? Thanks .. -- Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212 "Never attribute to malice, that which can be adequately explained by stupidity" - Hanlon…
Stuck Transaction with BTS!
Hi All, I am working remotely, so calling IBM is not a solution today. Hoping you all can help instead. Informix 11.50.FC9 running on Solaris 10 I have a transaction that was started over a JDBC connection, doing an update on a column contained in a BTS index. No error was retu…
Re: A bug or "expected behaviour"?
PLease vote on this RFE: http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=37400 Thanks in advance, -Snorri…
Re: Improves - what you need?
I love this sort of initiative... Comments in line: On Mon, Oct 27, 2014 at 6:37 PM, Cesar Martins < cesar.inacio.martins@gmail.com> wrote: > Hi ! > > Few weeks ago I received some updates from IBM RFE (Request for > Enhancement) where some requests was rejected ... > > Featur…
Improves - what you need?
Hi ! Few weeks ago I received some updates from IBM RFE (Request for Enhancement) where some requests was rejected ... Features where I consider very important and huge missing at our beloved Informix... (some of this request are mine :) So , I wrote below a list of request wh…
"IBM Certified Database Associate" Training/Exam
I have a reasonable amount of sys admin and database (primarily Oracle/SQL Server) experience and have been working with Informix for the last couple of years. I set a goal this year to get a certification and thought I'd start out with this IBM Certified Database Associate. From…
Re: HDR with CMs in proxy mode
Nuno, Art: Thanks for your answers. Now I'm trying to persuade my managers to make it the correct way, primary and secondary in the same trusted environment. Hard work!! ;)…
logical logs location
Hi everyone, I'm trying to identify in which DBSPACE current logical logs are located Is there any query or command to identify each one? I guess prior DBA created in several dbspaces. Thanks in advance!…
Bulgarian Locale
Hi, I will install IDS 12.10 or IDS 11.70 on Red Hat Linux and I would like to setup the DB with Bulgarian characters. What locale should I use? Thanks, Vasilis…
onstat -g iof: gfd and chunk number
Greetings. I am *SO* sure I have asked this question before but I can't locate it within the forum so here I go, perhaps again. When I enter the command: onstat -g iof, the first line of each chunk's I/O stats looks something like this: gfd pathname bytes read page reads bytes…
Blob Questions
Hello Folks, O/S AIX 6 IDS 11.70.FC5GE I have some blob questions. I have a table with 4 text columns that keeps running out of pages in the tablespace. Since fragmentation in Growth Edition is not an option, I want to move the blobs from the tablespace to a blobspace. I have 3…
Request for option to disable repeatable read
If others have problems with Repeatable Read Isolation mode getting set and causing problems, I would welcome your vote for Request For Enhancement # 60897 Option to disable Repeatable Read Isolation Mode. http://www.ibm.com/developerworks/rfe/ Description: Some option to disab…
Informix 12 Unicode
Hi, I am trying to get IBM Informix Dynamic Server Version 12.10.FC3E work with DB_LOCALE=fi_fi.utf8 Problem is CHAR type and how informix reports it's size/length. As we know single byte locales eq ISO8859-15 character 'r' size is 1 byte and 'ä' size is 1 byte, but UTF-8 'a' …
unsubscribe
please unsubscribe me -- Kind Regards -- Sophia Alikhani ________________________________________…
SSL configuration
Hi , ifx 11.50FC9X6 and 12.10 FC4 , AIX 6.1 GSKIT 7 and 8 The client side , will access using JDBC I'm trying configure a SSL connection and I not sure what happen here... At my first tests all appear works fine (ifx11.50 + GSKIT 7) and I successfully connect using SSL. But wi…
test
It is a test --001a11c2fbb6af8eb60505da7473…
Cloning an 'ontape' tape
Probably another damn fool question but...what's the best method (if it can be done) of taking a clone copy of a previously-created 'ontape' level-0 tape? Basically we want to copy the contents of a tape to SAN somewhere with the probably future intention of copying it back off t…
Next extent size
The next extent size value as shown from sysptnhdr seems to be the one shown in oncheck MULTIPLIED BY the page size then DIVIDED by 2. eg: TBLspace Report for xxxx Table fragment partition vlatdbs01 in DBspace vlatdbs01 Physical Address 13:40 Creation date 08/21/2012 04:13:1…
HDR with CMs in proxy mode
Good morning. I'm trying to create a read only environment for aplication support group based on a HDR pair. This is an easy task, but the problem comes when I must do it across two connection manager instances, due to a three level security requirements (firewalls between serve…
Informix V12 Fragmentation
In previous versions of Informix IDS - I believe that if you included a 'remainder' clause in a table fragmentation statement, that queries over that table would not have any fragment elimination (assuming that a where clause has filters that matched fragmentation scheme). Is tha…
Connection Manager
Started Connection Manager successfully. It is pointing to 2 servers (Primary/Secondary HDR). I log into the secondary server and run 'onstat -g cmsm'. It shows me the connection manager name/version, cluster name, even failover arbitrator/order/timeout details. It completely lea…
4GL & IDS installed in different directories
I have installed IDS 12.10.FC4 and CSDK 4.10.FC4W1 in $INFORMIXDIR=/home/informix. Informix 4gl 7.51.FC1 in $INFORMIXDIR=/home/informix/TOOLS in a RET HAT Linux machine. When I want to execute engines programs I have to set INFORMXDIR to /home/informix, And when I want to execut…
Cooked VS Raw
Any bold opinions on cooked files vs raw space? I know previously I had been told by many that the raw option was far faster because of HDD speeds. Since most things aren't single drives anymore I assume that this has changed some?…
16 K Page Structure
Hi everyone, I got a ERP Totvs environment that always "create" (using update apps), a table that have a row size bigger than page size. Even if I create a 16 K page size dbspace, I cannot reach that row size (some tables have a 32000 byte of row size). 1 - Does anybody have a be…
Listener Not Started
I just installed Informix 11.70 on a Linux (Centos 7) system. Dbimported an existing database okay and dbaccess works fine. I cannot get into the system from any Windows system we have using ODBC. During DSN setup on the Apply and Test Connection section, I get a message that say…
Finding if table has SRLA (Selective Row Level Aud
Hello, Informix = 11.70FC7 System = RHEL 6.5 Is there a way to write a query to find if a table has or is defined "with audit" ? I have an application DB where a small percentage of tables have SLRA on and would like to be able to identify them with SQL calls, I know I can get …
SQLHOSTS for HDR
What are the benefits to defining groups in sqlhosts for an HDR pair? I have had some issues with multiple instances (each with an HDR secondary on a separate server) where I left the group definitions out and came across some unexpected behavior when dealing with failover. After…
RSS not working
Hello I have an interresting problem I have 2 servers when they I do a level 0 backup on primary. setup the RSS on Primary Send the backup to my secondary run ontape -p. connect the secondary to primary the primary sends this error 12:29:07 RSS Server drcastxliveca - state is n…
IDS Engine not responding
Hi All, IBM Informix Dynamic Server Version 11.70.FC7GE HP-UX B.11.31 I have had three occasions now where it seems like the engine is not responding. I get no response on any commands I try. We have about 600 to 900 users which relates to + - 2000 sessions accessing the databa…
Hide a column
Hi, i am trying the LBAC, and now i've got a problem, i have defined a new column to use the LBAC and now, when my app make a "selec *" the IDSSECURITYLABEL column is shown more or less like that name age label name1 age1 000001 name2 age2 000001 .................. I don't want…
Setup HDR
Informix = IBM Informix Dynamic Server Version 11.70.FC7GE Unix = HP-UX rafdr B.11.31 I am trying to set up HDR between two servers. After I successfully ran the command "onmode -d primary serverA" , I ran the command "onmode -d secondary serverB" I then get the following messag…
A bug or "expected behaviour"?
We are running HDR on 11.70.FC7 with UPDATABLE_SECONDARY. An attempt was made on the primary to update 112 million rows in a table, something like: begin work; lock table mytab in exclusive mode; update mytab set col1="xxx" where 1=1; commit work; No locks were accumulated on t…
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…
Level 0 onbar suddenly slow.
Hi - posted this to CDI but thought I'd double up in case it didn't appear here... IDS9.31HC5, HP-UX11i (PA-RISC) on an HP system container running under Itanium We're getting our level 0 archives slowing down by a factor 4 or so once the container has been running for a few da…
temp table schema
HI EVERYONE, HOW CAN I FIND OUT A TEMP TABLE SCHEMA? THANK'S A LOT.…
New IDS / performance & stability
hello, Informix users for 20 years since version 5, the entire IT infrastructure was built around this powerful and robust product. Based on a set of AIX servers with 8TB databases Informix handle about 10,000 SQL / seconds. The successive inplace upgrades have always gone well …
modify logical log size from 1 MB to 2 MB
Hi, Good Day would like to ask the best way to modify the log size in informix from 1 MB to 2 MB for (IBM Informix Dynamic Server Version 11.70.FC7). What I did so far was to add another log file with the size of 2MB and delete the 1 MB log file although after the deletion scrip…
HDR & Connection Manager
Informix 11.7 FC7, CSDK 3.70 FC7 I have a HDR pair with 3 instances setup with Connection Manager. Primary/HDR run on separate Linux boxes; as well as Connection Manager. I triggered a failover and all 3 instances on the primary were failed over to the HDR server, now the new-Pri…
Informix on HP MoonShot
When HP announced its new ARM32 and ARM64 based Moonshot micro-server yesterday there was only one commercial database that already supported the platform: IBM Informix. Today there still is only one. Imagine running your relational or JSON collection database on a server built …
Fwd: IBM Informix, the only commercially available
Check this out folks! Art Art S. Kagel, President and Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization wi…
dbexport bug?
I have a problem with dbexport command. Not export de table with text an byte fields Some idea why? Thanks -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec -- Este mensaje ha sido analizado por MailScanner en busca de virus …
onstat -T flag 0x40000000
We are seeing this bit value in the third "flgs" column of "onstat -t" or "onstat -T" output for a minority of tables/indexes on IDS 11.70, which is not documented in the Knowledge Center or anywhere else. For example, on two entirely unrelated FC4/FC7 systems, but not some other…
Second instance IDS issue
Hi everyone, My compagny have a SOLARIS 10 (8/11 SPARC 64) server with IDS 11.7 with two database instances at startup. We have an issue when the server boot. The first instance start correctly. But, we have an issue for the second instance with the shared memory. No matter the…
index rebuilds happen when server boots
This is IDS12.10.TC4IE on windows server 2012 R2. What would cause a bunch of indexes to be recreated when the server boots (and IDS starts)? This only happened once. I canât find anything in ph_task on it so Iâm curious why triggered this.…
not trusted
This concerns on IDS12.10.TC4IE on windows server 2012 R2. This was a fresh install. When I run ontape âa I get: 17:09:36 listener-thread: err = -956: oserr = 0: errstr = Administrator@LastDitch.home[LastDitch]: Client host or user Administrator@LastDitch.home[LastDitch] is no…
Explain Plan through JDBC
I need a means to collect explain plans using JDBC on client. Is EXPLAIN_SQL an option here? Are there any better solutions? I'm having issues finding much documentation on the function. We're using CSDK 3.7 on client and 11.7 IDS.…
Desempenho
Bom dia Srs. Hoje efetuei uma verificação com o comando onstat -g ckp e obtive o retorno abaixo: Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block tra…
Rolling Window tables
I=92m trying to get this feature to work. I have a database, original created with RANGE/Interval that I=92ve = ALTERED to ROLLING WINDOW: This is what happened to the fragmentation clause for these tables: fragment by range(callstartdate) interval(interval( 1 = 00:00:00) day(9…
consolidating dbspaces
HP UX B.11.31 U 9000/800 IDS 11.70.FC7GE Good Day, I want to consolidate a number of 2gb chunks into a single chunk. Can anyone advise me on how to do that ? Thanks…
SPL into SELECT statement
Hello y'all! I need of your expertize because I'm trying to do something "impossible". I got an SPL which returns two values per row. Is there a way to use it into a SELECT statement? I know I could use it only if it returns one value but I'm don't know if there is a trick to do…
System Or Internal Error InterruptedIOException
Hi, After upgrading to Informix 12.1, we are encountering this error. It all starts with java.sql.SQLException Connection not established Then we start getting threads with this error: Caused by: java.sql.SQLException: System or internal error java.io.InterruptedIOException …
Informix 12.10 FC4 ON RHEL6
Hi Guys I need to know what's recomendation to use in chunks over RHEL6. Until RHEL5 i was using raw devices. I should use cooked files? Thanks Regards…
dbaccess on 12.10TC2
This concerns on IDS12.10.TC4IE on windows server 2012 R2. When I run dbaccess it insists that I login even though I am logged on to Windows as Informix. This is on the console on the server and *not* remotely. The finderr help file says: âClient client-name or user is not trus…
Informix11.5/RedHat/Ferramenta de monitoramento
Bom dia Srs. Preciso de uma ferramenta eficiente para monitoramento do Informix. Estou com várias reclamaçoes de lentidão e não consigo identificar a causa. Alguém poderia me ajudar?…
IDS 12.10FC4 on RHEL7/CentOS7
Hi, anyone with installation success with a new instance IDS 12.10FC4 on RHEL7/CentOS7 (x86_64) especially on raw devices? Errors in my case are: "Cannot open primary chunk". Chunks are logical volumes (lvm2) with ownership informix.informix and access permission "660". My prod…
Physical Log size 2000 is too small
Hi, Good Day We are receiving an error when initializing the informix instance Physical Log size 2000 is too small. the command onparams -p -s 2000 was ran on the server and when is was restarted the error above was displayed. The problem is that we cannot again issue an onpa…
Informix/Oracle
I've come late to this and there were many other excellent replies, many focussing on the facts and some on more subjective views of vendor culture. I'm a reseller of both products and am neutral really, although I would say that I have a technical preference for Informix, and I…
VERY slow BTS index build
Hi All, First off, thank you all for your assistance so far in helping me get BTS blade setup. I am trying to build a BTS index across 950K rows defined as char(25). create index cp_lnm_bts_idx on char_person (cp_lname bts_char_ops) using bts We ran into issues with running o…
Re: ids Digest, Vol 106, Issue 6
Informix was the technical winner but Oracle won the market share and sales war. They used FUD to effectively win sales, new vendor, product applications, internet applications and startups, promisinyyrythe world delivered late and 1/2 the world. Oracle traded short term product …
Mutex - guard ?
Hi , IFX 11.50 FC9X6 - AIX 6.1 + 1 read only RSS node We are running a bunch of parallel 4GL programs. This programs start and finish very fast... We are getting wait at "guard" mutex ... and I found no information about it . Any tips ? Cesar --20cf303ea812e58d860502525d63…
Informix 11 to 12 Upgrade ... "error"
2 Versions: From: Version 11.70.FC8 To: Version 12.10.FC4 AIX 6 Ok, here goes. Please note that I place "error" in quotes, because I do not believe this is an error. I just want to confirm my theory. We did a test upgrade from version 11 to version 12, and the following state…
Maximum table size in 12.10
Hi, Was wondering if the maximum fragment size in Informix has changed since last versions. I know in the old versions the limit was 32GB which I could verify in the limits of the 11.70 version for 2K spaces (16M pages per fragment). The limitations section does only speak about…
Informix/Oracle
Hi All, I received the following comments from an Oracle Sales person: "Please note the below note to add in your motivation: IBM does not have a road map for Informix, making it a stagnant product and there is a possibility of little to zero support for Informix. High availa…
PAM and implicit connections
I don't do this sort of self-promotion very often, but mainly because PAM is a sort of "pet" for me, I can't resist: People tend to think that PAM is very different from normal/native connections. This is a misconception (and the manual doesn't help fighting that idea...) This a…
DE Edition
Hey all, I need some advice on the Developer's Edition. It says you can only use 8GB for the database. Does that include temp space, logging, etc? Thanks, katedart@bellsouth.net…
Informix Marketing
I just got an email with an ad advocating Informix over Oracle. First one I can remember since right after the acquisition. Interesting. --EEM…
License Trouble - LUS versus ILMT
Hey, iam in trouble with the IBM license model... What i want is to use an Informix Workgroup Edition with LUS(Limited Use Socket) licensing in a sub capacity enviroment. LUS is eligible for subcapacity licensing. So, my IBM Distributor says, i have to install the ILMT(IBM Licen…
Informix 12.10FC4 - Windows Server 2012 - Issues l
I have a client who is having issues connecting to a new Informix 12.10FC4 on Windows Server 2012 with domain users, they are getting -951 errors "Incorrect password or user is not known on the database server". Set the onconfig parameter "CHECKALLDOMAINSFORUSER 1 ", but that di…
Re: HDR error in secondary server
Hi, Well something is a bit odd on the target server storage root chunk. The assertion failure file shows two I/Os - one that caused the bfput error and then one for all the I/O. So, you should get two identical pages back - you don't! page 000000009da71000: 00000000 010046da …
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Re: JSON sql support
Added to the FAQ Regards, David. > On 21 February 2014 at 16:23 Art Kagel <art.kagel@gmail.com> wrote: > > > Unfortunately the documentation for the JSON & BSON data types is not yet > ready for distribution. I know that IBM is working hard to get it out. > First thing I can te…
Re: non in-place alter
Add to the FAQ. FRANK and Marcus Haarmann added to the credits. Regards, David. > On 14 February 2014 at 21:49 Marcus Haarmann <marcus.haarmann@midoco.de> > wrote: > > > Hi, > > maybe you should use a workaround: add a new int8 column, fill it in multiple > transactions > with…
Re: retrieve bigint/bigserial from C++ API
Added to the FAQ. Sathyanesh Krishnan added to the credits! Regards, David. > On 07 February 2014 at 22:00 Sathyanesh Krishnan <satyan@us.ibm.com> wrote: > > > Hi Frank, > > The Informix LIB C++ library has no support for BIGINT/BIGSERIAL. > The BIGINT/BIGSERIAL are relatively…
Re: Very large instances
Added to the FAQ. Regards, David. > On 24 November 2013 at 22:17 Art Kagel <art.kagel@gmail.com> wrote: > > > FYI, no direct help here, but v12.10.xC2 no longer has to keep the buffer > pool in the resident segment, it has been moved into a virtual segment of > its own and can …
Re: onstat -g nif
Added to the FAQ. Regards, David. > On 27 September 2013 at 02:10 Madison Pruet <mpruet@us.ibm.com> wrote: > > > Usually that would mean that you have a very large transaction that the= > > target is trying to apply, and because it is a large transaction it's > blocked the netw…
Re: spin locks
Added to FAQ. Regards, David. > On 23 September 2013 at 22:52 John Miller iii <miller3@us.ibm.com> wrote: > > > The two mutex which are directly effected are sh_stamp and po_lock, but > the VP_MEMORY_CACHE_KB speeds up malloc()/free() functionality > which can have an indirect …
Re: spin locks
Added to FAQ. Regards, David. > On 23 September 2013 at 18:47 John Miller iii <miller3@us.ibm.com> wrote: > > > The output of onstat -g spi is so low, it is really not even worth > worrying about. The po_pool lock > is the hottest mutex which has 118 latch waits in over 9 hours…
Re: spin locks
Added to FAQ. Regards, David. > On 22 September 2013 at 02:20 Art Kagel <art.kagel@gmail.com> wrote: > > > IB that is the memory pool latch. You can probably reduce the activity on > it by enabling VP_MEMORY_CACHE_KB so that each CPU VP holds on to some of > the memory from the…
Re: spin locks
Added to FAQ. Regards, David. > On 21 September 2013 at 11:00 Marco Greco <marco@4glworks.com> wrote: > > > On 20/09/13 21:56, BillHatVerizon wrote: > > This is the output of onstat g spi . > > What is po_lock below? > > Do the numbers look high or is it not possible to answer …
Re: locked mutexes!
Added to the faq as useful to know. Jacques add to the credits list for the FAQ! David. > On 11 September 2013 at 16:08 JACQUES RENAUT <jrenaut@us.ibm.com> wrote: > > > Original post: > > Hi, > > I had some user sessions in locked mutexes > > onstat -g lmx > Locked mutexes: > …
AF when instance starts because plog overflow
Hello I have a 11.70FC4 instance that fails to start because of physical log shortage, here is the extract from online.log : 04:44:38 Logical Recovery has reached the transaction cleanup phase. 04:44:38 Performance Advisory: The physical log is running out of room during checkpoi…
Privilege error question
When running the following as informix: grant sesessionauth on "public" to "informix"; I sometimes get: 8200: User (informix) does not have DBSECADM authority. Why does this happen and how can I fix it. This is migrating a database from one platform to another. Art Art S. K…
Re: The FAQ is back!
Apologies for the late reply, FAQ updated. 4.1.20 Will Informix explode in the year 2000? Kept as people may still be using DBCENTURY 5.11 Is there *really* no "Upper" function!? Removed 8.49 How do I set tables memory resident? People may still be running old versions, updat…
Performance problem during log backup
Hi experts, we were forced to create a new instance for our document storage (originally set up as table with blob column, using a smart blob storage). The new instance is using byte columns (yes I know we cannot use HDR ...). The old instance was stuck because of an undefined …
Data Source ifxoledbc linked server error 7303
Hi, I keep getting this error everytime I try to connect to Informix through SQL. I have checked the following: 1. Host file on both servers 2. services file on the sql server 3. put the server information in the IBM Informix Setnet32 tool 4. checked to make sure the server name …
Re: RSS Feed Formatting
Test Post Test Post Please ignore! Thanks!…
ONLINE.LOG verbosity and logging successful authen
Informix community, Is there is setting in the ONCONFIG file to change verbosity of the ONLINE-LOG? Specifically I'm looking to log successfully authentication with Informix, not just failed authentication attempts like -951 errors. Thank-you in advance for any insight. V/r, …
HDR replication setup on Windows
I know that I have asked a related question a while ago, but I have lost all of my old e-mails. Does anyone know of any great, detailed instructions for installing and setting up HDR replication to a secondary on Windows 2008? IDS 11.70.FC3 I have done this a lot in UNIX and L…
Auditing
Informix 11.7FC7 HP - PA-RISC I want to use the Auditing functionality of IDS to keep track of all changes on a database excluding insert,update and delete events. The Auditing should also include Informix(DBSSA). I have tried the level 7 option but it does not exclude the inser…
NULL values for sysmaster:sysmachineifo columns
Hello, I have an IDS 11.70 version on a SUN-Solaris environment.Columns related to shm (os_shmmax, os_shmin, ...) and sem (os_semmap, os_semids,...) in sysmaster:sysmachineinfo do not show any value. Do I have to set any onconfig or operating system parameter to get the correct a…
Re: onload, onunload
Use dbexport -ss instead. If that's too slow consider using myexport and myimport withe their -E option. It's 2x to 10x faster. Especially if you have the CPU and io bandwidth to add -p and unload/load all tables in parallel. Art Art On Aug 21, 2014 4:42 PM, "LARRY SORENSEN" <l…
Encryption
anyone able to provide a quick breakdown of encryption in versions 11.70 and 12.x ? Our client is looking for complete "table level" encryption; to the best of my knowledge IDS only supports encryption at the column level. Thanks, Mark…
C UDR's on Redhat
Im making my first foray into C UDRs. Im using Informix 12.10 (c1) and using Redhat 6.3. As a test I decided to write a simple C routine that returns an environment variable: #include "dmi/mi.h" #include "stdlib.h" mi_lvarchar *igetenv(mi_lvarchar *str,MI_FPARAM *fparam) { …
C Language UDR on RedHat
Im making my first foray into C UDRs. Im using Informix 12.10 (c1) and using Redhat 6.3. As a test I decided to write a simple C routine that returns an environment variable: #include "dmi/mi.h" #include "stdlib.h" mi_lvarchar *igetenv(mi_lvarchar *str,MI_FPARAM *fparam) { …
PAM Authentication with certificates
Hi experts, We need to set up an JAVA environment which accesses an IDS instance via JDBC/Datasource Pools. (sounds simple, have done that a 100 times ...) Now comes the challenge: The requirement is that the client does not have a clear text password stored in a config file no…
wait for mutex
Folks, Normally I do not see S---- in output of onstat -u, but now I see. Any comments? Thanks Frank RHEL 6 [informix@walter ngdc_er_20140820]$ onstat -u IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:38:50 -- 11847728 Kbytes Userthreads address flags sess…
Tenant Databases and DBImport
Hi All, trying to migrate a development system I encountered a problem with tenent databases and dbimport. My idea was to export 50+ user databases with dbexport, create tenant databases with predefined resourcces for each developer and import table structures and data via dbim…
Error Secondary server HDR
Hello Someone knows. why Did this error happen? 08:35:18 Assert Failed: Page Check Error in bfput 08:35:18 IBM Informix Dynamic Server Version 12.10.FC3WE 08:35:18 Who: Session(29, informix@sermirror, 0, 0x56d90038) Thread(58, xchg_2.0, 56d59fa8, 13) File: rsdebug.c Line: 1172 …
Fast recovery problem
Hi, We did have database which was in nonloggin mode and checkpoint did hang. We shutted down the informix and started it up. When we started the informix, it did perform Fast Recovery. Last checkpoint was 14.8.2014(DMY) 03:00 and this happended 15.8.2014 17:49. So all that day …
BTS & Outer Joins
Hi All, First off, thanks for the assist on showing how wildcards work with BTS indexes. Very helpful! Now, I've run into a bug(?) with the BTS functionality. It doesn't seem to work with queries involving Outer Joins! This query runs fine: select count(*) FROM c1 inner join pn…
Wildcard searches
Hi All, We are running Informix 11.5.FC6. In the midst of redesigning a database system to capture new functionality and improve performance. On user request is for searches begining with a '*' wildcard. The fields to search are all varchar(255). I know that regular indexes won…
IIUG2015 - Start thinking about it.
Hey Everybody, It seems like IIUG2014 just ended, but the Board and the CPC have already kicked off the early planning stages for the 2015 IIUG Informix conference which will be held in TBD. Ok, so we don't know WHERE the conference will be held next year, but we do have a good…
ontape backup and restore
Hi, I'm running online ontape level 0 backup on my dataserver. The ontape begin at 7 PM and lasts 2 hours While this ontape is running, there are transactions running that modify datas in my instance at the same time. At 8 PM one transaction truncated data in a table called my_ta…
ER Target Server Crashed (unto death)
Hi IDS 9.4 on AIX 5.3 as an ER Source to two Targets: IDS 10 on Solaris 5.8 and IDS 11 on RedHat Enterprise. Following a building power issue and some aircon getting turned off the Solaris Server has crashed, been down for two days and is unlikely to be recoverable. As it no lon…
Informix Fantasy (American) Football League
To go slightly offtopic from the normal discussion on this list I wanted to put this out there. Last year we tried a private Informix users fantasy football league that people had a really good time with. Cindy Lichtenauer ended up winning the full thing. This year we want to op…
fragment estimate_compression Partition is not in
Hi, We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version 12.10.FC3E I get lots of this kind of error messages, where could i start finding reason for them? 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243371 15:…
Implicit_PDQ
Is anybody using Implicit_PDQ? How effective is this? Informix 11.7 UC8 on AIX 6.1 Cheers…
Error HDR
Hello There I have the following error in secondary server 16:50:58 Start Logical Recovery - Start Log 9539, End Log ? 16:50:58 Starting Log Position - 9539 0x47832e4 16:51:03 Started processing open transactions on secondary during startup 16:51:03 Finished processing open trans…
HDR
Dear folks For HDR I need de same version of OS & IDS -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que est…
Index creation on compressed table
Hi All, Informix 12.10.FC2 on HP-UX B.11.31 If I have to create a index on a column of a compressed table (Informix Compression) then will it take more time as compared to creating an index on the same column of the same table when it is not compressed? Regards Vikas…
Lock de registros
Boa tarde pessoal. Estou com um problema no ERP Logix (TOTVS). Determinados programas geram locks em registros, o que é normal, porém mesmo após a desconexão da sessão o registro permanece em lock. Alguém sabe uma forma de desalocar esse registro apenas? A TOTVS enviou a inform…
USEOSTIME Performance Degradation ?
The need has arisen for sub second granularity with CURRENT. Question is does turning this on result in any noticeable performance degradation and if so is it more system wide or specific to just the application ? AIX 6.1. Informix 11.70.FC7 Thanks, Mark…
ER errors
HI, 11.70.FC7, RHEL 5,6 Any comments on the following ER errors? Thanks Frank 20:20:48 Maximum server connections 7 20:20:48 Checkpoint Statistics - Avg. Txn Block Time 0.084, # Txns blocked 6, Plog used 423976, Llog used 445026 20:20:53 Logical Log 140817 - Backup Completed …
Differences in RSAM page structure 32 and 64 bit I
Greetings, all. With some delusions of grandeur and other aspirations, I'm more than a little curious: We all (or most of us) are familiar with the 24-byte page header and the (somewhat misnamed) time-stamp at the end of each page in an IDS server. (I'm not certain that latter …
ALTER FRAGMENT with HDR
There are a couple of ways to reduce the number of extents that a table/index is using. I plan to use ALTER FRAGMENT ON TABLE <tablename> INIT IN <dbspacename>. How well does this work with HDR ON in case of large tables? I would have logs backed up continuously on the primary. …
IIUG 2014 Presentations
Hi everybody! Can anybody help me to find the 2014 IIUG presentations? I'm not able to see it at conference downloads page at member area. Regards, Alberto Pessonio.…
Logical log size
What is the downside to increasing the logical log size on IDS 11.50.FC7 running on Solaris? I have been receiving occasional messages telling me that my log size may be too small. This occurs during large batch processing operations. We are also running HDR. Are there any other…
backup error
Folk, Any suggestions on the following error? Thanks Frank [informix@leslie ontape]$ ontape -s -L 0 Please mount tape 1 on /dbbackup/ontape/ontape_ncdcops and press Return to continue ... Archive failed - buc_fe.c : Archive API processing failed at line 257 for rc Program over…
backup error
Folks , any idea on the following backup error? Thanks Frank [informix@leslie ontape]$ ontape -s -L 0 Please mount tape 1 on /dbbackup/ontape/ontape_ncdcops and press Return to continue ... Archive failed - buc_fe.c : Archive API processing failed at line 257 for rc Program ov…
Safe Way to Cancel an Informix (ontape) backup
Hi Guys, I have a large machine doing a backup at the moment, but the engine needs to extend some chunks causing this error: Extend chunk 209 failed. System archive in progress. Try again later. Is there any risk in killing the ontape process to allow this extend complete? IB…
Data warehouse: RedBrick vs IDS
Question for those who may have worked with RedBrick, Would RedBrick make a better data warehouse engine than IDS? and why? I'm not looking for a formal evaluation, even very biased opinions are welcome :) For one thing I know RedBrick is NOT even cheap, so which one you happen…
fast recovery
Aix 6.1 IDS 11.70.fc3 Had a transaction reach the long transaction HWM after running for about 5 hours...I know .. error in the sql statement to switch the table to raw before doing this mass delete .. anyways ... attempted to onmode -z sessionid .. that resulted in the engine g…
Upgrading to a new version of Informix
Going through the document for 12.10 upgrade: http://www.ibm.com/developerworks/data/library/techarticle/dm-1304overview/index .html?ca=dat- I had a question regarding the section on new sql keywords. As with any release the database engine introduces a set of reserved keywords…
Auto Update Statistics
Informix 11.50.FC8 - solaris environment After reading the documentation, it appears that AUS is scheduled to run over the weekend, by default, and all "UPDATE STATISTICS" commands that do not have time to execute are saved. My question is, "How configurable is AUS?". I would l…
Restoring Data from trans logs only
I perfect storm of hardware/personal failures has left me with a database with no Level 0 backup, transaction logs going back for multiple years, and a busted database table that I desperately need to get back. Is there any way to extract the data from the transaction logs using…
Physical Log Size
IDS 11.70.FC8 AIX 1 6 00CC96664C00 I received the following message in the online.log file ..... is it something to be concerned about ? Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoi…