Threads from 2016
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
IDS on Mac
Hey, I am trying to install IDS on a new Mac - no previous installation of Informix. When i start the UI wizard, it stopped without saying anything after asking me for an an administrative password, which is correct... Is there some install log I could look at? Do I need to cre…
shrink repack defragment
Is there anything I should be aware of when unsing this functions? http://www.ibm.com/developerworks/data/library/techarticle/dm-1011informixdefrag menter/ Im not asking about limitations, I'm asking about "Make sure you have enough space here" or "Better do it in the night wit…
Using Indian languages in IDS
Hi, I am from India. We use Informix database in our organization. But nowadays we require that in addition to English data that is inserted in database, we should be able to insert data in Hindi atleast in our database. But we are not getting much help regarding Indic languages.…
12.10 Virtual Appliance
HI, Where is the link to download Informix 12.10 Virtual Appliance ? Thanks Frank --001a113cdadacb1d300544d38f29…
Cluster project
Hi, I have one customer that request a project to replicate 15 instances over two servers on HDR. Is that possible? How can I do it? Thanks for any help. SP sergio.peres@airc.pt…
Informix Best Practices for DBAs - New Webcast Ser
Folks, Happy New Year! We are pleased to share our Webcast series for Informix DBAs - Informix Best Practices. We will discuss configuration, disk layout, backups, performance tuning, and high availability disaster recovery implementation. Our Informix Best Practices are based …
Informix Database crash cause select whith between
Hi, today I have a select wich cause crash of my informix database, this select has just a between criteria on a field date which is launched on a partionned table (175 million rows), the problem is the other fields work welle and for this field only the criteria between two date…
Removning Log staging in RSS server
Hi, since a problem today with Primary server wich are propagated to RSS server, I decide to apply the DELAY_APPKLY on my RSS server, I put for the test perpuse 5S, but the problem is the logs in the staging directory are not removed after apply those logs, is there any way to re…
Packages in IDS 12.10 Developer Edition
Greetings, Fam. I just downloaded IDS 12.10 Developer Edition for my Linux-Min (Rel 18) on a 64-bit OS. The machine notes say I need these packages installed: The following package have to be installed on your Linux system: libaio-0.3.106 libgcc-4.1.2 libstdc++-4.1.2 ncurses…
ids from 11.50 to 11.70
Hi everybody In a develop server I have two installations of ids: 11.70 and 11.50 Now, the instance is running in 11.50 ¿ can I upgrade to 11.70 just shutting down the 11.50 instance, adjust the environment variables and starting the 11.70 ? ¿ do I need to do something else ?…
When was the last time a database was used
Hi everybody Does enybody knows if there is a way to know when was the last time a database was used Thanks…
Creating a dbspace with a non-default page size
Hi, My environment : IDS 12.10 FC6 with HP-UX 11.31 I'm creating a new instance for a datawarehouse and I want to use the option -k pagesize of the command "onspaces". I want to use the non-default size only for data dbspaces, not for root, logical, physical or temporary dbspac…
Informix 4gl working with one compiler, but not wi
Solaris 10 IDS 11.50.FC6 i4gl 7.32.FC3 We have been using the Solaris Sun Studio compiler in the SUNWspro package bundle. It has been working just fine. We are working on moving to a new server, and are running into issues. Everything on the new server appears to be the same e…
sysdbopen problem
Hi, I doing some tests with one procedure table to register all access to my informix instance, even for informix user. I am using the code from planetids to use sysdbopen and sysdbclose: http://planetids.com/content/how-track-resources-used-database-users Every thing works fine…
onsmsync -g 15
IDS: 12.10.fc6 OS: Aix 7.1.0 TSM: 7.17 We recently migrated a system from IDS 9.4 and as part of the backup script a 'onsmsync -g 15' is being execute. Previously this would keep 15 generations of the level 0 backups, so in our case 15 days worth of backups. On the new server, t…
Lots of SCHAPI errors
Hi everybody, We had some interruptions at a moment and when I checked the logs I saw lots of SCHAPI errors and couldn't figure it out if it's because of sort memory, bad tables or maybe bad queries. Onceck shows no errors. I uploaded some filtered logs. The instance is stable n…
Re: Installer error - Innovator-C
Hi, I know it's late, but you should've checked the install log. Happened to a friend once, it was a java issue.…
Copying INFORMIXDIR to another like server
Solaris 10 IDS 11.50.FC5WE i4gl 7.32.FC3 I have Informix and 4GL installed on one server. Should I just be able to copy the $INFORMIXDIR over to another similar server, or does 4gl do weird things and install libraries in other places? Larry…
Chunk symbolic links
Hi, I have a question about creating chunks with simbolic links: I can't figure it out how it's done. Let's assume that my chunks are on a separate storage. I did ln -s for all chunks to $INFORMIXDIR/storage/chunks but Informx doesn't start after I set the rootpath to $INFORMIXD…
New release of myexport
Folks: There is an updated release of my dbexport/dbimport replacement utility package myexport available for download from my web site ( http://www.askdbmgt.com/my-utilities.html). This release includes several small bug fixes and improvements and includes a new option: -n enab…
Updates to utils2_ak
Folks: I have uploaded an update to my utils2_ak package with support for new v12.10.xC8 features and a bug fix to my web site: http://www.askdbmgt.com/my-utilities.html Enjoy. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog…
Clon installation
Hi everybody I have a IDS 11.50.FC9 installation, and i need pass it to an other solaris server with the same versión Can I copy the install directory from one to the other in order to avoid do all the installation process ?…
Informix 11.50 FC9 and 11.50 FC7 in the same serve
Hi everybody I have a 11.50 FC7 instance running in a server, and I have to install an other 11.50 FC9 in this same machine. I used to dba informmix several years before, so I´m a little cold. ¿ where can I download Informix 11.50 FC9 for solaris. I have a valid user and accoun…
Index on long Varchar
Hi, we have a table that contains 250.000 Rows (PK id serial, key varchar(27), ...). An index is on the field "key". The varchar ist exactly filled with 27 chars (a generated number). If i filter by this field (key) by one value, the SQL is running 0.3 seconds, and the SQLEXPL…
SPL debug
Hi, I am having some problems with one procedure and I need to debug it. Can anybody help me how to do it? Thanks, SP…
Re: IDS Memory leak with tcp connections under hig
Hi all. I'm sorry for revive this old thread, but I'm having the same issue on IDS 7.31 over Solaris 11. (I know, nest solution would be update to IDS 12, but it's not possible, client won't do it). Any idea/suggestion? Thanks.…
Long lasting dostats
Hi all Informix 12.10.FC4W1XB, Solaris 10 I'm running dostats on a very big table. It seems it won't come to an end. Runs now since Monday, the 5th of December. Table myschema: CREATE TABLE "informix".xxxxxxxxxxxxx ( pe_id SERIAL8(15712838227) NOT NULL, pe_re INTEGER, pe_r…
Clone using LUN Copy
Hi All, We have IDS - Informix Dynamic Server Version 12.10.FC5W1XZ, configure with SDS Node. We need to do Clone of the both node to Staging Environment. IBM Support Executive has configured some LUN Copy Cloning Method, which is not working Currently. I need some help around. …
12.10 xC8 Defects Fixed and Known Defects
From the machine notes (For Linux x86_64, but I've checked other platforms), I've been trying to access the 'Known Defects' and 'Defects Fixed' links. These both seem to be broken. The Know Defects link results in a 404 error and the Defects Fixed link results in the list for 12.…
IO performance issues
I'm opening this thread because of some IO performance issues that I have now and need to be sure of what I must do. This is my db profile counts:Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 22906487 87848814 34363980245 99.93 332057743 398328761…
Restore a Informix 11.50 FC2 backup in 11.70.FC8
Greetings I need to copy a database from a production server with 11.50 FC2 to a develop server with 11.70.FC8- I already have a ontape backup file from the production server in the develop server. I had match the dbspaces and chunk structure in both server for all the instance…
Recompiled ESQL/C code using CSDK 3.70
Greetings, We recently recompiled some application binaries using CSDK 3.70.UC7. I was looking for a way to validate the recompiled code used the newer CSDK 3.70 version versus the CSDK 2.90.UC4 version we had been using. I tried using the strings command but did not find any ou…
Re: Public execute on filetoclob and other fun....
Jesus Christ. Mac email mangles stuff nearly as badly as Notes! > On 5 Dec 2016, at 08:09, Spokey Wheeler <spokey.wheeler@gmail.com> wrote: > > If you regard FILETOCLOB as a UDR, then you can see the rules for UDR = > security here: = > http://www.ibm.com/support/knowledgecenter…
Public execute on filetoclob and other functions
Informix 11.7FC8 Our auditors did an audit on our Informix databases using the SQuirrel tool. Following is the finding and solution recommended by this tool. " database sysmaster - Public can execute the filetoclob function. It is suggested that a role called FileAccess be crea…
Temp log files in rootdbs during warm restore
Greetings, Family. I recently had a misadventure and would like to gain further insight into the issues of concern. My client is on IDS 11.5 (despite 3 years of bugs and nagging to upgrade already! But that's another story.) My client DBA inadvertently blew away a chunk, realiz…
More Smart Large Object Problems
Informix 12.10 Solaris 10 Until recently, I have not been too involved with sblobs. Now that I have to deal with them, I am finding continual problems-- both theoretical and administrative/management (as in "lack of")-- with these things. Basic violations of fundamental Relation…
utils2_ak downloads
Folks: If you downloaded an updated copy of utils2_ak from my web site over the past two days you may have downloaded an interim version of the package due to a problem at my web site host. In addition the version that is online now contains another update that includes a fix to…
java.sql.SQLException: cannot create user thread
Hello, I am running a jdbc 3.70.JC8 application on a windows 7 64 bits version. Informix 12.10.FC7DE server is running on a Linux x86 64 bit os. I'm facing the following error: Caused by: java.sql.SQLException: Imposible crear thread de usu. Comprobar nomb. de usu. en NT y grupo…
Update to utils2_ak
Folks: I have uploaded a new releae of utils2_ak onto my web site ( www.askdbmgt.com/my-utilities.html See the site for a description of the latest features. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-m…
Re: Centos 7 XFS and IDS 11.7
On a server which is used to back up (using virtsync) VM images to a volume running XFS, we encountered a problematic error: kernel: XFS: possible memory allocation deadlock in kmem_alloc This appears to be related to block size and fragmentation. Using the xfs_fsr utility to '…
Dynamic Explain (onmode -Y 1)
11.50.FC8 When I set up dynamic explain for a particular session id for a particular long running job , the output is not quite what I expect. Only a few of the sql statements have their query plans listed along with their respective query statistics in the output file; the res…
Help with PHP
Hi, I am trying to develop a program to connect several informix servers with PHP, but I am having some problems on using the version 5 PDO with version 7 of PHP. I have searched for information how to compile without success, can anybody help me on compiling a PDO, or where can…
Mails don't appear in the list
Hi all, my mails don't appear in the mailing list. Didn't send much recently. Ealier the mails appeared in the list short after sending. TIA, Reinhard.…
onbar restore problem
Hi, I use onbar to do the redirect restore. and I see below message twice, why? thanks for your time . Clearing the physical and logical logs has started Cleared 263968 MB of the physical and logical logs in 392 seconds 1) run "onbar -r -rename -f ./list.txt -t "2016-10-09 23…
Dead lock detected
Hi, Since about 3 weeks a go, there had been an increment of dead locks in the database server and the users say the system is more slow than before. What can I do to reduce the dead locks and increase the system response ? Thanks in advance. --Apple-Mail-112EA2CF-C317-4221-9E31-…
Shared Disk Secondary
Hi, my environment. Informix Server 12.10, Solaris 10 Is it possible not to shut down and restart a SDS-Server automatically, triggered by the shutdown and restart of a primary? Background: We have to restart the primary to stop all sessions during maintenance periods but we d…
onbar -r -l -X problem
Hi, When I execute the onbar -r -l -X to stop the logical log restore, Do I need set LTAPEDEV to /dev/null? I see below messages in the online.log. logical file not found and IDS don't change quiescent mode. thanks for your time.…
Smart Large Objects Mystery?
Informix 12.10 Solaris 10 I have been dealing with these things a lot, recently, and there is a lot about them I don't understand. However, I would ask about one thing in this post. Situation: I had an sbspace that was nearly full. With some guidance from this forum and Inform…
Preferred order to apply Solaris patches
Current env: SunOS adagio 5.10 Generic_150400-40 sun4u sparc SUNW,SPARC-Enterprise IBM Informix Dynamic Server Version 11.50.FC6W2 DB instances: prod, hdr secondary, rss What is the preferred order to apply Solaris patches? Does it matter? We've applied the Solaris patches to…
Usable space available in an sbspace?
Informix 12.10 Solaris 10 I'm finding it challenging to be working with sblobs and sbspaces. Even the terminology is a bit confusing to me. For example, A BYTE type is a blob, but a BLOB type is not a blob but a smart blob. Or maybe I have that wrong. But, that's a rabbit trail.…
Replace sbspace with larger?
Informix 12.10 Solaris 10 I have an sbspace consisting of one chunk (symbolic link). I would like to replace that drive and make a much larger sbspace (still only one chunk). Will the following work for replacing the sbspace (a "last checkpoint" restore is acceptable): 1) Do a …
Avoiding duplication of large object storage?
I have mentioned this issue as part of a previous thread whose main purpose was to inquire about backing up Informix databases, but let me focus on it here, as a separate issue. As I understand things (or not), large objects are referenced by large object handles. Thus, if the s…
ER replication with WHERE clause
Hi, IDS12.10 FC4, Linux http://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.erep.doc/ids_er p_023.htm ============== WHERE-clause column updates If a replicate includes a WHERE clause in its data selection, the WHERE clause imposes selection criteria for rows in …
What log size is too large?
We have a system with logs sized at 200MB. We are rolling through 6 or more of those every hour. We are considering go to 500MB. Does anyone have logs that large out there? -- Will chat again soon, Kate katedarts@gmail.com --001a114b10f4b1d3e20540e50899…
IDS 12.10 - Query Slow
Hi, We do migration from IDS 11.10 to IDS 12.10. But some query performance slow when compare with old version. It's not impact to all program but just a few program. I noticed when we used temp table on our program, SQL very slow especially during insert value to temp table. S…
Issue in transactions with informix using DRDA
Hi, My environment: Informix 11.70 FC8W1 in HPUX 11iv3 64 bits. Anybody knows how to use a distributed transaction in Informix with DRDA. For example: Instance 1, database db1: create table "informix".rviweb ( a integer ); Instance 2, database db2: create table "informix".…
IDS 7.xx on Windows 2008/2012
Dear Friends: Do any of you have an IDS 7.xx engine running on Windows 2012 or Windows 2008? I would be grateful if you would comment on your experiences. Thank you very much! Gustavo Echenique…
sbspace size insufficient after dbexport/dbimport
Solaris 10 Informix 12.10 I am trying to dbexport a database, and then dbimport it into an Informix instance on another machine. The database currently has a sbspace that is 8GB. I do the dbexport successfully. I dbimport it into the new instance, said instance having an sbspa…
onmode -b option not listed
I am testing a fix to the issue (my previous post today) we find in our production install of informix 12.10.FC6. I have installed 12.10.FC7W1WE on a test HP-UX ia box. How do I revert this instance to 12.10.FC6 in order to restore with a production archive. My options with onmod…
Performance on Informix 12.10.FC6
Last weekend we upgraded our Primary and Secondary HDR servers from 11.70.FC7 to 12.10.FC6. There have been a couple of performance drops noticed so for and am looking for some general guidance here. The config. param values we have in version 11 have been retained in v12. The sl…
sysattrtypes Growing Fast
Hi, We are running Informix 11.70.FC7W2 on Solaris. I noticed there is a system table in our DB called sysattrtypes that has been growing fast and currently has over 26 million records. The table recently starting growing by over 1.7 million records each week. According to the …
Informix Enterprise Gateway
Hi, We are doing a PoC to validate our goals using Informix Enterprise Gateway. Executing together with IBM BP, since it's a trial release. After a few days testing it, we identified a few defects and some lack of resources. Our BP is having difficults to get some answers from …
Compacting a dbspace through onunload and onload
Solaris 10 IDS 11.50.FC5 I have a test instance that is spread out across all of my dbspace chunks in my test instance, some chunks just havin27 pages used, some having 31 used, etc. I have recently deleted a couple of databases, and now I would like to consolidate my test inst…
Informix in the world, need info
Yesterday in my work they where choosing bbdd for a new program. I wasn't there, but they told me than when Informix came they said its a great database but they don't know if IBM will try to kill it in favour of DB2. I need straight facts that shows that is not true, links to I…
CDC vs ER
Hi, our customer wants replicate data to oracle and informix server. For oracle wants use CDC and for informix too. Do you have somebody experience with replication over CDC ? 1.informix to oracle and other database system 2.informix to informix. I'm interested also to compare p…
why logical backup not automatically triggered
Hi, Just want to ask why the ontape is not automatically triggered? IDS 12.10 Linux 2.6.32-642.1.1.el6.x86_64 alarmprogram.sh BACKUPLOGS=Y ALARMADMIN=3 ALARMPAGER=4 ADMINEMAIL=test@user.com PAGEREMAIL=test@user.com MAILUTILITY=/bin/mail # ###################################…
packing a database to take less room
Solaris 10 IDS 11.50.FC5 Is there an easy way to pack an Informix database? I have several mostly empty dbspaces and I would like to reclaim the space. Thanks…
Re: upgrade and onbar
Hi Art the file pointed by BAR_BSALIB_PATH (ibsad001_64.so) in onconfig file exists but i have the error message when running /opt/IBM/informix/bin/onbar_d -b -p -w (-43231) An unexpected error occurred: 0509-022 Impossible to load the module /opt/IBM/informix/lib/ibsad001_64.o.…
Max number of instances per server
Hey all, I am looking into the feasibility of using HDR from 2000 sites to a central server. Is it possible for a single server to hold 2000 instances, and has anyone else out there done that? Any details you have on how you run queries against that as well would be great info. …
storage pool doubt
Hi and thanks beforehand. Is there a way to split between raws or chunks in the storagepool new chunks added for a dbspace? I dont want all chunks added to be from same disk.…
Taps....
IBM Informix Dynamic Server Version 11.50.UC3 -- On-Line -- Up 1217 days 23:02:28 -- 3061196 Kbytes Proactively bounced this engine tonight. I know you could have gone on for 3 more years without fail, little fella, but we all have to get restarted sometime. https://www.youtube…
Re: Deleting records from a table
Larry: All the following assumes a logged database: If the delete was performed in dbaccess in MENU mode (rather than from the command line mode) then there was an explicit BEGIN WORK; issued by dbaccess before running the SQL in the editor window, so it would have rolled back …
Create chr function in informix 11.50
Hi everyone. I'm new in the forum and also with informix. I am facing a problem with text fields that have line break. When I unload the information for a .txt file, everything is out of position. Looking on the internet i found the chr () function, but I'm using informix versio…
Re: Deleting records from a table
But if I understood correctly the "bad" DELETE had no WHERE condition... I don't know the size of the table, but considering that if it succeeded you would have only records on the table which were inserted AFTER the DELETE.... Can't you be sure just by looking at the table conte…
Deleting records from a table
IDS 11.50.FC8 Solaris 10 If I have a user that logged into Informix and connected to a database via dbaccess....... A user was deleting records from a table using SQL. She forgot to put a "WHERE" clause in, ran the command, but she hit delete before the command completed becau…
Re: Restore a specific table from a ontape backup
Solaris 10 IDS 11.50.FC7 I need to restore one table from an ontape backup to a different location or table name so that I can compare a current table to what it was last night. What is the process for doing this? Thank you. Larry…
How to find CDC enabled tables
Hi iiug, Just want to ask how to find the cdc enabled tables? can't use the oncheck -pT, it uses locks which affects the application. Is there any table how to check which table is in Full Row logging and Snooped? IDC 11.7/12.10 Thanks, R…
sds transactions
I don't understand sds secondary isolation in transactions I'm making some test and I'm a bit confused, perhaps something is not well set: --Primary create table kk(k char(1)); begin work; insert into kk values (2); --Secondary select * from kk --> 2 --- --dirty read?; I keep …
Failed to recover the logs after restore
Hi Gurus, I have a DB that i want to do some log replay. startup --- oninit -PHYv ## This looks good and shows in fast recovery mode. When i do "ontape -l -C", it showed that all my dbspaces are "Online" but the the itself is in fast recovery. 0/11/16 08:59:51 Started 1 B-tre…
Table and Index Positions.
In OAT / Profiled Fields / ISAM, there is an entry called "TABLE AND INDEX PSOSITONS". Can anyone tell me what this actually means? I have an 11.50 sever that runs perfectly well for about 90 days and then users report ever increasing slowness. A reboot solves the problem. I sus…
dbimport don't use all available dbspace
Hi all, On Linux Centos, with Informix 10.00.FC6 I've this dbspace situation [informix@test64-001 dev]$ onstat -d IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up 4 days 00:03:36 -- 37900 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name…
RedHat 7.2 Health Advisor mail command and systemd
I'm reviewing Informix 12.10FC7W1 on Red Hat 7.2 (x86-64) and have come across a few items I though might be valuable to share with the group. First off, is anyone else running on this platform? I've created a systemd unit file to start and stop OAT, depending on another system…
When will OAT move away from flash
When will OAT move away from flash? It has many security issues and adobe has recommended moving away from it. All the major browsers are beginning to block it and have plans to remove support in future versions. https://www.cvedetails.com/vulnerability-list/vendor_id-53/product…
Internal error in routine sqoptim
Hi, We get this error after do informix migration from 11.10 to 12.10fc6. program stop at line 2057 sql statement error number -768 internal error in routine sqoptim: no valid query plan generated. When i check line 2057. "select distinct prm_basic from prm_sch_hdr" It means…
SQL 212/ISAM 131 Errors in dbimport
I am attempting to do a dbimport into a newly created Informix instance. It fails with an SQL Code 212 "Cannot add index", and an ISAM Code 131 "ISAM error: no free disk space". There are only two dbspaces (rootdbs and tempdbs) and two sbspaces (blobsbs and erqsbs) in this insta…
CONNECTING ALFRESCO TO INFORMIX
Hello, I have a customer who wants to implement his Content Management ALFRESCO-(COMMUNITY version) with Informix as its main database. Has anyone of you got some experience on the subject? My customer has tried it but failed. Kind regards, JUAN ROCA…
OAT missing profiled fields.
I have an instance that has been upgraded from 11.50 through 11.7 to 12.10. Oat has been upgraded to 3.16 When I use Performance History / Auto Checkpoints I see 5 measures (Buffers flushed per second, Dirty Pages per second, Logical Logs Flushed per Second, Longest Disk Flush a…
Re: Too much implicit connection in remote instanc
The following will work unless you actually need to join tables between the instances: Rewrite your applications to open two explicit connections, one to each server, and switch between them in the application using SET CONNECTION TO ... That will go directly to the two servers a…
Informix on cloud offer
Another soruce of information for IBM's new cloud offer: https://developer.ibm.com/bluemix/2016/10/04/informix-on-bluemix/ Regards and sorry for the publicity. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently…
HDR_TXN_SCOPE
I am considering migrating Production Informix from v11.70 to 12.10.FC6. HDR is tuned ON. The secondary server is read-only. (HP-UX 11.31 ia64) Config param. HDR_TXN_SCOPE is not set in current production on v11. Would like to set this parameter to NEAR_SYNC, the default, when w…
How do you train an Informix DBA?
Hi, Do you need to get a new Informix DBA training? Or get up to speed on the changes in version 12 to upgrade? I have been teaching Informix DBA's for over 25 years in how to manage and monitor and Informix Server. I will be teaching our next Informix course, "Informix for Data…
Where to find downloads for IDS 10.00 FC6 For Linu
Hi all, I'm looking for the installation file for an "old" IDS 10.00 FC6 for Linux 64(centos). Is there someone that can give me some indication on where to find the material ? TIA Danilo Brembilla…
Drop rowid transaction
Greetings. I am hoping I have not painted myself into a corner. I created a fragmented table with rowids. This was to prevent a problem I had encountered in a previous load of another fragmented table. With the perfect 20/20 hindsight most of us possess, I realized that the pro…
Blobs vs Smart blobs
Hey All, We currently have document storage using the blob data types. This is a legacy architecture used prior to the introduction of smart blobs. The size of the current storage for these blobs is about 10TB. The blobs themselves have traditionally averaged around 80k per blo…
IDS AIX to RHEL/Intel
A client is considering moving IDS from AIX to RHEL/Intel (which is exciting to say the least). To post a very general question ... any stories from the road going from AIX to Linux, or Linux in general? I recall Sandor showing great I/O numbers with direct I/O during the IDS 10 …
IDS 12.10 onaudit configuration
HI, I want to enable audit configuration on production database, before that need some advice/best practices to avoid any degrade performance on my production database. 1. When we enable audit, any impact to performance.? if yes, how to minimize this. 2. how to configure audit…
renaming chunks with ontape?
I would like to replace a drive with a larger drive (with larger chunks). Is it legal to create larger chunks on the new drive, and then use the rename option of ontape to do a cold restore, and use the new and larger chunks, in place of the former chunks? Is it legal to combin…
Re: latest news
Hey, Did you hear the latest news? You should definetely read more info here <http://tradeshymo.katiesmitherman.com/e4wyagni> See you soon, k7nirmala…
DBSERVERNAME in an HDR environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary server or they must be diferent ? I asking this because I have synonyms in and external server pointing to the primary server, but in the case th primary fail and the secondary be…
DBSERVERNAME in an HDR Environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance.…
Upgrading to Informix 12.10.FC6 with HDR
I am planning an Informix server upgrade from v11.70.FC7 to 12.10.FC6. I have a read-only secondary server replicating in HDR. (HP-UX 11.31.ia64) Questions: I start by breaking the replication and bringing both sides down. 1. Do I upgrade Informix on the Primary and the Second…
trouble getting HPUX test/dev system DB loaded aft
HPUX 11.31 (11iv3) on BL870c servers Informix 12.10.FC6 I know this is slightly off topic. Recently we migrated from using a EVA4400 as our Informix storage to a 3par 8200 SAN connected to our HPUX servers that run our ERP. The migration went smoothly. Each HPUX server are iden…
Copy a database from one instance to another
Solaris 10 IDS 11.50.FC8 I need to copy a database from an instance on one server to an instance on another server. On server 1 I did an onunload of the database to a local tapedrive. I am trying to do an onload on server 2 accessing the tape drive on server 1. Scenario 1 Ser…
Copy a database from one instance to another
Solaris 10 IDS 11.50.FC8 I need to copy a database from an instance on one server to an instance on another server. On server 1 I did an onunload of the database to a local tapedrive. I am trying to do an onload on server 2 accessing the tape drive on server 1. Scenario 1 Ser…
Using {+FIRST_ROWS} with FIRST 1 makes any sense?
Hi Does using 'SELECT {+FIRST_ROWS} FIRST 1 ...' is better then 'SELECT FIRST 1 ...' when we do not use order by? Explain show better cost but db engine should use the same best execution plan in both cases.…
Script to see who's (session) using temp space
Hi, I've been working on a script to allow a DBA to see which session(s) are consuming temp space. Basically a workaround for the problem covered in http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=77869 The script is accessible in https://github.com/domuso…
User Name from Connection Pool
Hi, We are running 11.70.FC7W2 on Solaris. We have a Java application that uses a connection pool for Informix DB connections. However, we have many triggers that log user activity on certain tables. We would like to log the user that made the change, however from the DB side we…
Delete command hang
Hi, we performed the follow , and the delete command hang: $ dbaccess mc -; Database selected. > select count(*) from mmo; (count(*)) 1940402 1 row(s) retrieved. > set isolation to dirty read; Isolation level set. > delete from mmo where dest_type = 103; 458: Long transa…
Informix on cloud webcast
Sorry if this is a repetition. The message has been around for a few days, but here goes (again): IBM will host a webcast next September 26 about a new offering of Informix on cloud environment. If Cloud deployment is an option for you, this may be very interesting. During the w…
LDAP/NIS user cannot activate dbaccess
Hi All, LDAP/NIS users which are not OS based are unable to use dbaccess command. The other OS users (informix) is able to connect to the database. I tried login with LDAP user and set all the environment variables and tried dbaccess, the command freezes and no output, no dbacce…
Script for onstat to onspaces
IDS 11.70.FC8XC4 AIX 6.1 Good Morning Folks, I have need to turn all my onstat -d output into onspaces commands. I found a couple of scripts in the repository but they either hang or fail. Does anyone have any reliable script for this that they would consider sharing? The end r…
Cannot Connect To Newly Installed Informix
Hi, I cannot connect to a newly installed Informix Server on Centos 7.1. My Informix version is 12.10.FC6TL It just won't login. I'm pretty sure that I'm throwing the correct credentials. My error is JDBC URL: jdbc:informix-sqli://192.168.206.141:12191/testdatabase:INFORMIXSE…
ALTER FRAGMENT INIT progress
Dear All, I've tried to do ALTER FRAGMENT INIT ON TABLE that did not have any previous fragments, 25M rows, defining 3 fragments based on expression( serial column < X ...) on a quite old testing machine and it took around 20minutes to move the data and finish the operation.(mor…
Informix for Database Administrators - Oct 31- Nov
Folks, I will be teaching our next Informix course, "Informix for Database Administrators", Oct 31- Nov 3, 2016. Sign up to lean all about the best database. We received a great testimonial from one of our Advanced Informix Performance Tuning class students: "The Advanced Perf…
Utils2_ak package update
Folks: I have uploaded a new release of my utils2_ak package to my web site. It contains new features and expanded type support in the dbstruct.ec utility. Note that the previous July 29, 2016 release contained new features in myschema. Read the details and download this releas…
Steps to apply Patches for Informix
Hi, Currently we are using Informix 12.10 FC4 and we are planning to apply the FC5 patch. Can any one share me the document on step by step procedure to implement the patches. Thanks in Advance.., Durga…
Re: RE: onstat -g glo: cpu efficiency
We have an IBM Power 750 (Power 7+) with 16 cores defined running SMT so that the cores appears to the OS as 64 cores. We have 54 VPCLASS cpu Our average efficiency looks to be in the low 60% range. We are experience about 80 lngspins per day with an peek connections of about …
Negative pages read in chunk
I have some system monitoring that captures pages read from each chunk. This is simply "select fname, pagesread from syschktab" For the most active chunk in the instance this statement returns a large negative number (-1,181,472,262). However an onstat -D returns a larger positiv…
Capture event of adding shared memory segment
Hi, IDS 12.10 FC4. I only want noteworthy event ( ALRM_ALL_EVENTS 0) But, It seems "adding a virtual shared memory segment " is not a noteworthy event, 16:42:36 Dynamically allocated new virtual shared memory segment (size 1000KB) 16:42:36 Memory sizes:resident:114076 KB, vir…
Error al realizar un DBIMPORT
Buenas Tardes..!! Con un atento saludos a todos, pido su ayuda con un error que tengo al hacer un dbimport de mi base. El error que despliega es que las columnas del archivo , no son iguales a las columnas de la tabla, este error me da en la gran mayoria de las tablas de mi bas…
Required to have names for simple constraints?
Folks, Working on IDS 11.5 on Solaris. DB was setup many years ago and has not had much mx/tuning since then. Gotten very slow. I'm primarily a MySQL DBA and have done a lot of reading on informix. Things are running much better, but one remaining step is to truncate some very l…
Database is currently open by another user
Hi, I have a script that runs on a crontab to do the dbexport of all databases. In that shell first a put informix in Quiecent mode with onmode -uy, then put in single user with onmode -jy, then run all the dbexports. But sometimes there is a database that fail and get the mes…
Long transaction problem
When IDS will used up all the logical log? i.e. the log file below the current logical log file has open transaction also . thanks for your time.…
Informix backup question
Question 1: when IDS start to do a backup on 3 AM , Do the backup only include those transaction data before 3 AM? Queston 2: When IDS is doing the backup ? there are still some new transactions,when do the checkpoint,where those dirty page will be flushed to ? Is it temporary d…
Creating index ONLINE
Informix idc11.7FC8W1: when running create index statement using the ONLINE parameter , SQL executing on that same table will abort. Is this normal or is it a bug?…
IDS and keepalive
AIX 7.1; IDS 11.50.FC8 Seeing ever-growing number of timeouts from a client (at their end) ... the message in engine msg log: 09/06/16 09:40:06 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. I still suspect it's network-rela…
Number of isread dropped
Hi All, Upgraded AIX Informix from 11.7FC6 to 12.10FC6. As I'm collecting metrics from sysmaster, I realized that number of "isread" dropped, any comment?…
Issues with 12.10.FC6 on Linux x86_64
IBM released an alert about this version/platform: http://www.ibm.com/support/docview.wss?uid=swg21989890 Please review the situations when it may happen : Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... -…
Demo Distributions
I am trying to download informix 12 to try on Mac. When I go to the user group web site. When I try to down load the 12.1 version I am pointed to the address http://www.iiug.org/cgi-bin/download.cgi?iif.12.10.FC1DE.linux-x86_64.tar I get a page not found. What do I need to di…
just take a look
Dear! Just take a look at that amazing and wonderful stuff, you're going to love it for sure! More info here <http://phevuprochi.classicpickles.com/e4cct> Hope this helps, Cash4Gold…
Re: FLASH: APAR: Adding a space with non-default p
FYI: This is fixed in v12.10.FC7 and later. An update from the APAR notice pages: Flash (Alert) Abstract On Linux x86_64 (64-bit), if a data storage space with a non-default page size and an initial chunk size + offset in the new space less than 2GB is added, after upgrading …
Fwd: FLASH: APAR: Adding a space with non-default
See the APAR notice below! Looks serious! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 th…
ER data volume
Hi, IDS12.10 FC4. A table mytab is ER full row replicated in Every-Where. Primary key is tabid. No trigger defined. job1, update mytab set col1=100,col2=150 where tabid=25 job2, begin work; update mytab set col1=100 where tabid=25; update mytab set col2=150 where tabid=25; co…
replication tecnologies and blobspaces
Someone knows wich replication tecnologies (HDR, SDS, RSS, CL) have problems with blobspaces? I'm reading in some IBM pages that HDR does not work but I'm afraid of missing information. Informix versión 11.70 and 12.10 If all replications are based in logical logs, if it fails o…
Speeding up ESQL fetches
Hi, I am trying to speed up a program by fetching a row into a sqlda structure instead of using EXEC SQL get descriptor 'demodesc' value :i for every column. So far so good, I can use it just fine to directly assign simple values into my structures. When it comes to datetime t…
Add disk slice, live?
I have a drive used exclusively by Informix for raw chunks. It contains the rootdbs as well as general table dbspace. It also has some totally unused space. "Totally", as in not even any slice defined for the cylinders in question. I would like to modify the disk label (the disk…
Record Locking and Update Statistics
I have had a number of situations where I have experienced a large number of record locks in our application which have been difficult to diagnose. However I have found that an update statistics low on the database causes the lock issues to disappear. I am struggling to understan…
SELECT while being UPDATEd?
A colleague created an update trigger on a table A. This trigger invokes an SPL that INSERTs a new row in table B. Some of the values being INSERTed into B are being SELECTed from table A, from the very row being UPDATed (and that fired the trigger). My colleague is experiencing…
Rss impacting performance
Hi, I have an informix Primary 11.7 database in Windows 2008 R2, I have monted an Rss server read only) fro reporting, it works perfect for 3 days, bu since 19 August the users complain a performance issus with the .net in house software, when I have checked IIS(Internet Informat…
Centos 7 XFS and IDS 11.7
I am told Centos 7 uses XFS filesystem by default.I am again embroiled in discussions on XFS vs ext2 vs ext4 with and without journaling. As this is above my paygrade, can I get some further pro's and con's of using XFS for my data chunks.…
Alter fragment on index is slow
Hi, RHEL 6.4 64 bits IDS 12.10.FC4 I have a table (aprox. 1000 millions of records) fragmented by expression (table and indexes). This table has three indexes. One of the index is: create index "dwh".ind1_facturacionx on "dwh".facturacion (dia_proceso, clave_documento) using …
iiug 2016 slides
Hi, Can someone tell me where can I download the presentations from iiug2016? As all the links on site iiug2016 don't exist. Thanks and regards, SP…
Restore informix database backup L0
Hi, I have production database and daily doing L0 backup and require to restore on the same server i.e. production server but different server name and chunks as well. How to restore different chunk same for the L0 restoration. Is there any method to do this Thank you --001a11…
Physical log chunks almost full
Hi, I have a physical log of 2GB, but when I do onstat -d I notice that the free colum is "1179", is it risky if that chunk is full and how can I free the space from this chunk. thanks…
rootdbs full
Hi I have activated the scheduled "kill user by timeout task in OAT", and then a few days my rootdbs has become full, so the question how can I avoid that my rootdbs become full by this functionnality enabled. for info, my loogs are on a specific dbspace. thanks…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
Error -908
Dear Friends: After an uninstall of an IDS 7.31 TD9 and subsequent installation of an IDS 7.31 TD6, clients can not connect to my database. To uninstall the I performed manually, following an internal IBM document, so there should be no problems (but apparently, any). The oper…
Re: Move sysadmin database
Frank, Sorry to reply to such an old post but I am seeing this same error intermittently when building instances in fully automated environments with 11.70.FC7W1. I agree that the problem is not a lack of space in the target dbspace or any other parameter because the problem is…
RE: Onbar dbspace restores by time of backup
If we do a dbspace restore is it the timestamp of the full backup start or completed timestamp or the timestamp the dbspace completed it's backup? 2016-08-04 22:27:18 942204 1011838 Archive started on rootdbs, dwa_poe_dtl_n_dbs27, scvdw_bkg_dbs01, dwa_poe_dtl_n_dbs26, dwa _poe_d…
Onbar dbspace restores by time of backup
OS: 6.1.3.0 IDS: 11.50.FC5 We are trying to restore specific dbspaces from and onbar backup by timestamp. We don't need to restore the full database, but just specific dbspaces. We are receiving dbspaces are not down. Bar_log.act: 2016-08-04 22:41:41 942204 1011838 Archive on …
Informix for Database Administrators training - Oc
Folks, I will be teaching our next Informix course, "Informix for Database Administrators", Oct 31- Nov 3, 2016. Sign up to lean all about the best database. We received a great testimonial from one of our Advanced Informix Performance Tuning class students: "The Advanced Perf…
iiug 2016 presentations
Is there a place I can download the iiug 2016 presentations?…
dbaccess dbname hangs for seconds
Hi, I encounter a bizare problem, the connection to database just hangs at random for some seconds (10 to 50), I have nagios which monitor a transactionnal web site and we have noticed today some delay in the pagesn, when I have connected to the database server (Windowsd 2008 R2)…
Inserting data and temporarily ignoring constraint
Isn't there a syntax that you can add to an INSERT command to ignore constraints during the insert? I need to do this for several tables. Larry…
Figuring out how much space a database is using
IDS 11.50.FC7 Solaris 10 I have 2 database in an instance sharing 2 dbspaces. Is there a good way to figure out how much space one of the databases is using as well as how much in each dbspace for that database? Larry…
Migration of blob data
Aix 7.1 Informix v12.10fc7 Oracle 12c We are in the process of moving our PeopleSoft HR from Informix to Oracle .. not my choice...lost that battle .. anyway, currently in informix one of the tables contains an employee which is a byte column. The migration of that data to oracl…
Delete duplicate rows in fragmented table without
Greetings again. IDS 11.5 I think I saw PaulW address this in a search result yesterday but I can't find it now. I have a fragmented (by expression) table named newrt. Due to an abort and restart of a load, one of the partitions has a large number of repeated rows. (I was wait…
delete from table where multiple columns match
WOW! That is one unclear subject line! Sorry about that. I'm also sure this has been posted and may even have been answered but I have yet to find an answer; it's so difficult to compose the perfect search phrase. IDS 11.5 I have carefully created a work table named hold_newrt.…
Onbar and PSM
HI, IDS 12.10 FC4 I was testing onbar and using onsmsync to clean older backup files. When I run the onsmsync -i "3 00:00:00" , the following are logs of BAR and PSM. Both logs have error lines, but the it seems the old backup files were cleaned up as expected. Any comments …
Ebexport
Does dbexport lock the database while running? Larry…
Promote RSS to HDR
Hi, how can we promote an RSS secondary server to be HDR secondary server in order to give users the right to only do their reportings on this server and keep all OLTP transaction on the primary.…
Convert RSS to HDR secondary
Hi, how can we promote an RSS secondary server to be HDR secondary server in order to give users the right to only do their reportings on this server and keep all OLTP transaction on the primary.…
Illegal operation on DR
Hi, I have a problem with some SPL(Procedure) when launched on my secondary informix server (RSS), for all procedures SPL for example: select col1 into var_col1 from table1: an error in laucnhed telling me can not create temporary file and Illegal operation on DR, is there any wa…
eliminate duplicate rows
Hi i have a duplicate problem with 300 billion table, i don't know why and when the unique index was dropped !! Now i'm using dbload to reload the data avoiding the duplicate - unload all the data with HPL - Drop / create the table - Create the unique index - load with dbload …
Question: Would this Warning Slow Instance/Server
OS: AIX 6.3.0.0 IDS: 10.00.UC5 The warning below, we have taken as just a warning and not something to worry about, BUT. Can this message actually be an advance cause, of any slowness in the Informix instance and/or server performance? Should we actually work to make sure our b…
dbexport : -425 - Database is currently opened by
Guys, Did numerous times of dbexport . in past 50 years, NO problem :-) :-) But, now it blocked the job... It is sure , no application , no ER, no HDR, NO nothing running there ( I even stopped scheduler ) ... Any tip to trace the " another user"? By the way, it is fine to d…
Trusted UDS Servers
Hello, Can you please tell me if making 2 IDS RHEL servers trusted is IDS version dependent? What I mean is if there is a restriction of the IDS version in order to make the servers trusted. I am trying to make an IDS 10 trusted with IDS 12 on Linux. Thanks, Vasilis…
ISM restore problem
I copied a large backup ( 1.3TB) to another server ( into /backup/Sicherung/B_DATA ) and followed the guidelines in ISM Admin's Guide and Backup and Restore. I created links with this litte script: ls /backup/Sicherung/B_DATA/1 > /tmp/myfiles.txt while read p; do ln -s /backup/…
Re: Please vote for a new Informix RFE:
Agree to disagree ... works for me ;-) Small block size: I ABSOLUTELY agree. However, that goes to my comment about not having control over the storage configuration. Less and less as the years progress. Storage guys LOVE block sizes from 1MB to 256MB while Informix (and most ot…
Re: Please vote for a new Informix RFE:
As I wrote, I disagree, so we'll agree on disagreeing. R&D will decide. Currently on a really busy system we have many threads waiting on a flush (in a worse case scenario). Some of these threads are not doing COMMITS. They just need a buffer to write to. Overall group commit wil…
Re: Please vote for a new Informix RFE:
Fernando: I disagree. I do not think that group commits are the right 'fix' for having all three logical log buffers dirty at the same time. You say that delaying the log buffer flush until more data is in them would not delay transactions, but that is exactly what it will do. Y…
11.50.FC9W3:Long checkpoint due to 2 sessions in c
Hello, I have problem which appears sporadically (~10 times this year) on some systems which our customers installs. Affected Informix is 11.50.FC9W3, SLES11 SP4. Behaviour is always same. Informix remains blocked in "CKPT REQ" state for long time (~4-12 hours) and is not acces…
Re: Please vote for a new Informix RFE:
Art, I understand the rational behind this request, but I don't think that is the best way to solve it. First, we need to distinguish between the logical log buffers (3) and the hdr logical log buffers (12). There are situations where we could use "more" of them. For standard se…
Please vote for a new Informix RFE:
Folks: I have entered a new RFE # 92334. It requests that IBM make the number of logical log buffers configurable, dynamically adjustable, and include an AUTO_ autonomic tuning capability for this resource: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=9…
SKIP SCAN
IDS 12.10 FC4. I have plan explanation of a sub query, Subquery: --------- Estimated Cost: 23317 Estimated # of Rows Returned: 42147 1) informix.activity_status: INDEX PATH (SKIP SCAN) (1) Index Name: informix.activity_status_idx4 Index Keys: act_item_descript (Serial, fr…
RSS to Primary ?
Hi, We are running Informix 11.70.FC7W2 on Solaris 11. We tested the following scenario and want to see why it works and if its recommended or not to do this. We have 1 informix "source" server with 4 RSS servers connected to it. 1) We brought down the Source server "onmode -k…
sqlunload: quotify.c:38: quotify: Assertion `bufle
Attempting to use myexport to test migration of a database; however sqlunload fails for every take unload. [informix@argus UNLOAD]$ myexport testdb Building schema file ... Waiting for data exports to complete... Database selected. 0 row(s) unloaded. Database closed. [informix@…
More about errors -951 / -952
Hi, HP-UX 11.31 Informix 11.70 FC8W1 I have a legacy windows application (it is not possible to modify code). This app uses ODBC and when the PC user is trying to connect to the unix server with a incorrect combination of user / password, then one of following lines are written…
HDR - export on secondary
On an existing HDR (11.70) I'd like running an export on the secondary node while the primary server still needs to continue running. On secondary node: onmode -d standard perform the export onmode -d secondary (HDR should start re-syncing) Any suggestions or recommendation…
IDS 12.10 on HP-UX- DS Total Memory
Hi, When we start Informix, we get this message, $oninit Warning: Parameter's user-configured value was adjusted. (DS_TOTAL_MEMORY) Need your opinion/advice for this, We need to adjust our memory parameter? Any explanation about this? Any document we can refer for this as refe…
onstat -g sql --- interpretation?
Hello,Under column Iso/Lvl, there are values such as CR, DR -- what do they mean?And also, there are many "wait 300" -- is it just something referring to set isolation level to wait 300 seconds from the application that we should not be worried about? Thank you! onstat -g sql IB…
DBSERVERNAME Best Practice Pri/HDR/RSS
Are there any suggestions related to best practices for naming the DBSERVERNAME in a Primary/ HDR/ multiple RSS cluster? Would it be ok have the exact same DBSERVERNAME for all instances in the cluster i.e. PRI / HDR / and multiple RSS servers? Then use separate names for HA_ALI…
Reorganize the 'informix'.TBLSpace to allow for fr
Solaris 10 IDS 11.50.FC8 We have been reorganizing and cleaning up one of our databases, and we have been able to delete several chunks that were no longer needed. Chunks in which the 'informix'.TBLSpace resides have been freed up as well, however the data is spread out and pr…
AUTO: Viviana Gomez/ARSA está ausente de la oficin
Estar=E9 ausente de la oficina hasta el 25/07/2016. Por favor, por temas de base de datos contactar a Horacio Churata int 2315 / Andres Vazquez int 2314 Nota: Esta es una respuesta autom=E1tica a su mensaje "Re: Informix limitations [37440]" enviado el: 07/18/2016 7:49:35. Est…
Informix limitations
Hi to All please, where to find different informix versions limitations (nb max of pages, extents...etc ? thanks in advance…
Oracle SCN/Informix and Golden Gate
IDS 11.5.FC8, AIX 7.1 Golden Gate is being used to replicate from IDS to Oracle. Instantiation is proving "interesting", and my Oracle counterpart has asked a few times if we have an equivalent to their SCN which they use to get read-consistent snaps of tables to instantiate if …
restore evolution
Hi i launched a restore with ontape, and i want to see its evolution, to estimate how much time it would take. thank you in advance…
detached index rebuild question
HI, A customer has the data cleaning requirement base on the datetime column, so they want to fragment some tables, but some tables has detached index; they want to know after they detach one partition, Do those detached index will be dropped and recreate ? or julstly delete some…
Re: Informix & implicit PAM results in "Server....
On Wed, 2016-07-13 at 08:51 -0400, Adam Tauno Williams wrote: > On Mon, 2016-07-11 at 08:04 -0400, Fernando Nunes wrote: > > Can you add the PAM file configuration? > > And regarding the error.... it looks like the sqlstatus. Can you > > try a remote dbaccess to obtain the native…
HDR - Want Asynchronous
Solaris 10 - SPARC IDS 11.50.FC7 I wanted to rebuild a few indexes. I dropped them and wrote an sql to recreate them. While I had replication going, it would stop after each index and send it to the secondary. I thought that it was because I has Synchronous replication set up w…
Backup/Restore Primary/HDR
Hi, We are running 11.70.FC7 on Solaris 11. We use onbar for informix backups. How does backup/restores work when switching from a primary to HDR (new Primary) server? Do I need to do another full backup when promoting an HDR server to Primary or can the logs being backed up by …
Optimizing IDS for SSD
Does anyone know of plans by IBM to have an optimize_for_SSD switch in the onconfig? The reason that I ask is that it seems that many of the issues that we've traditionally dealt with become moot once the engine truly understand the performance implications of SSD. Do we still …
IDS Growth vs Enterprise
Solaris 10 Sparc IDS 11.50.FC7 Are there any good statistics to run to determine when it is good to graduate to Enterprise Edition IDS from Growth Edition IDS? Larry ________________________________…
Fw: Restoring Ontape to a different instance on th
Also, to add a little more information, the new dbspace already exists in the other instance and is populated with chunks. I only want to restore one of the databases in the archive if possible. Larry ________________________________ From: LARRY SORENSEN Sent: Friday, July 8, 2…
Restoring Ontape to a different instance on the sa
Solaris 10 IDS 11.50.FC7 I know I have seen this before, but I can't find where I may have saved the information. What is the easiest way to restore an ontape backup to a different instance on the same computer? Are there any steps that someone may have typed up before that yo…
Re: err = -951
Hi,I had a similar problem with Ids 9.3 on Linux, The problem, in my case, was due to the fact that the new version of linux uses encrypted passwords on SHA512 instead of MD5. You will notice this thing through the file / etc / shadow, passwords encrypted with MD5 have $1 as a pr…
Informix & implicit PAM results in "Server rejecte
I have PAM auth configured on a new Informix instance; implicit, not challenge. I see PAM auth **succeed** via /var/log/secure - oninit: pam_krb5[12289]: TGT verified using key for 'host/argus.XXXXXX.XXX@XXXXXX.XXX' oninit: pam_krb5[12289]: got result 0 (Success) oninit: pam_krb…
Re: err = -951
Informix also has a trust file you can use if you don't want to set up general system wide trust. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my o…
err = -951
IFDS 11.7FC8 HHP-UX B.11.31 We have installed IDS 11.7FC8 on a new HP server. I am trying to set up an ODBC connection but get the following error: listener-thread: err = -951: oserr = 0: errstr = <username>: Incorrect password or user <username> is not known on the database s…
Compilation with esql shows Illegal instruction
My enviroment: HP-UX 11.31 Itanimum 64 bits Informix 11.70 FC8 W1 Hi, I trying to compile a program with the command: /opt/informix/bin/esql est2.ec -o est2.exe It results in : opt/informix/bin/esql[821]: 26790 Illegal instruction(coredump) The origin program is very large. I m…