Threads from 2011
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Migration from IDS 11.50FC4 to 11.50FC9
Dears, I have recently upgraded from IDS 11.50FC4 to 11.50FC9 by renameing the current home and Installing new version in the old home.The database came up and everything was normal, but when I tried to restore an old level0 backup I got the following error. "Backup data versio…
extents size
hi, Knowing the size of a row and the number of rows, is there a method to appreciate the true value of the extents' size of a table ? thank's…
ids without network?
This concerns IDS 11.70.TC3IE on Window Server 2008. We have laptop that we can use for demos but Informix will not run without a connection to a network. Is there a setting someplace that will allow this?…
RE: ESQL/C - Receiving and Printing different date
So, now the question is, how do you print values such as datetime Interval and money and date strings? I can declare them in an ESQL/C program. Now I need to print them to a file. For a datetime interval variable, in the documentation it appears that I can skip the interval decl…
Innovator-C restrictions?
Hi We're looking at reducing TCO and want to check the full spec for Innovator-C; all we can find so far is the Overview page (http://www-01.ibm.com/software/data/informix/innovator-c-edition/) with some tidbits such as "Limited to 1 socket, or a maximum of 4 cores and 2GB of mem…
RE: Problem with HDR
Hello, Is there a known APAR for this issue? Thank you, Elena -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jamie Gedye Sent: Monday, February 21, 2011 11:19 PM To: ids@iiug.org Subject: RE: Problem with HDR [22845] Yes. I ra…
optimizer of informix behavior question
Dear All... I've developed esql/c in Linux accessing IDS 11.5 for years , As I remembered the following cursor will do only one time optimization , in the prepare statement ,after that , IDS won't do any optimization during cursor open and cursor close inside while loop , that m…
Which command you love most?
I would vote: onclean!! Because whenever onmode -ky does not listen to you....., onclean can give you a help with loyalty! ( Lifeguard?) Happy New Year ! Frank --0015174bf07084784f04b5187c56…
PSORT_DBTEMP
Folks, IDS11.50 FC8, Redhat Linux. Can we set up PSORT_DBTEMP ( to a file directory temporarily) in server side to let ALL client sessions to use the newly set PSORT_DBTEMP for sorting? Thanks, Frank --0016e6dd8599a0aec304b5167449…
New version of utils2_ak
I have uploaded a new version of utils2_ak. Look for the new release to be posted to the IIUG Software Repository in a few days, the README.1st file will be dated DECEMBER 27, 2011. Happy New Year to all. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: htt…
New version of utils2_ak
I have uploaded a new version of utils2_ak. Look for the new release to be posted to the IIUG Software Repository in a few days, the README.1st file will be dated DECEMBER 27, 2011. Happy New Year to all. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: ht…
AUTO: Douglas Dailey/Lenexa/IBM is out of the office (returning 01/03/2012)
I am out of the office until 01/03/2012. Note: This is an automated response to your message "Informix-list Digest, Vol 305, Issue 5" sent on 12/24/2011 10:00:01. This is the only notification you will receive while this person is away.…
Informix doesn`t start
Hi, I`v got hudge problem, Hope fore someone of you it will be simple to find what happen. So, I try to resize my rootdbs, I wrote a few commands sth. like this: C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50>onspaces -a rootdbs -p C:\\\\IFMXDATA\\\\ol_ids_11…
Re: how to get all the instance's chunks free space
On Dec 21, 12:14 am, joe <joecl...@gmail.com> wrote: > I created several informix server on a host. > To monitor each server's chunk space,I have to setup environment > parameter then run 'onstat -d' to check the chunk's free space. > > Anyone can write a shell script that get al…
Invitation to connect on LinkedIn
LinkedIn ------------ Art S. Kagel requested to add you as a connection on LinkedIn: ------------------------------------------ Informix Users Group, I'd like to add you to my professional network on LinkedIn. - Art S. Accept invitation from Art S. Kagel http://www.lin…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
Informix & Splunk
hi all has anyone had experience with using Informix and Splunk? if so, care to share thoughts, experiences, etc thanks…
SQLAPI oncheck question
Running IDS 11.50.FC5 on HP-UX 11.31 PA-RISC. According to the docs, if I run EXECUTE FUNCTION admin("check data", "partnum"); I should get something very similar to running 'oncheck -pt ...', and if I run EXECUTE FUNCTION task("check data", "partnum"); I should get a count of t…
Re: how to get all the instance's chunks free space
Get my package, utils2_ak, which contains an ESQL/C program, dbsavail.ec. The first time you run dbsavail against each server it will install a stored procedure, dbsavail, into the sysmaster database. Then you can run it easily against each server in a script like this one: #!/…
Use of DRDA (EGM or IDS 11.5?)
Hello, I have some questions regarding the connection between IDS 11.5 FC6 and DB2 z/OS V9. We have a client application that is accessing some dozen Informix databases hosted on two unix servers. The same application is also sending Queries via CICS to one of 15 different DB2-…
how to get all the instance's chunks free space
I created several informix server on a host. To monitor each server's chunk space,I have to setup environment parameter then run 'onstat -d' to check the chunk's free space. Anyone can write a shell script that get all informix server's information ( like 'onstat -g dis' do) and…
11.5 UC7E crashes
Hi, we have an Informix Server 11.5 UC7E running under Debian Linux. The system ran fine in no-logging-mode for several years until we switch to logging-mode to support a new application. Since then we experience crashes - the database dies with the following messages from the …
event trigger/alarm
Hi, Folks, IDS11.50 FC8, Redhat Linux. I am going to narrow down which job peoridically caused IDS to add new memory segments. Basically, the plan is, whenever IDS is adding a new memory segment( as in the attached online log messge) , the event will trigger my script to take …
Migrate Oracle/MSSQL to Informix
Hi All, Since we have a new version 11.7 which can compete with Oracle and MSSQL, is IBM doing the best they can do to market the Informix Database? I want to know what are the moves being done by IBM.. I still believe, Informix is the best DB engine ever built...…
AUTO: Out for the Holidays (returning 01/03/2012)
I am out of the office until 01/03/2012. I will be out, but will be periodically checking on email. Have a happy holiday season. Note: This is an automated response to your message "Re: migration checklist 7.31 to 11.7 [25662]" sent on 12/19/2011 12:54:34. This is the only not…
migration checklist 7.31 to 11.7
Current version: HPUX 11.23 IDS 7.31 migrating to HPUX 11.i3 IDS 11.7 I'm not the developer, but I have a lot of UNIX and sql tools used to monitoring production. I know in HPUX 11.i3 there is a tool that comes with it to search all of your scripts looking for decremented comma…
Physical Log
IDS11.50.FC3 HPUX11.11 this is the error message in the online.log we have been getting WARNING! Physical Log size 300000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 160 times maximum …
HDR-Connectivity issue
Our HDR setup between Production and Disaster Recovery is fairly new ( 4 months old) but this issue has been noted more recetly: three times in the past 2 weeks, always/only at night. The cause appears to be a brief network outage, though, the network admin. cannot see it with hi…
chunk list when system down
I need to be able to get a list of all chunks within an Informix 11 database whilst it is down ? Is this possible, and has someone already written something to do this ?…
C UDR - AIX
Hi , IFX 11.50 FC9X6 , AIX 6.1 I'm trying create a simple UDR to get the current 'transaction id' with less overhead possible... To use this UDR inside of SPL + Trigger... I'm not expert on C language, where play with it sometimes... So , I getting some trouble to compile the …
C UDR - AIX
Hi , IFX 11.50 FC9X6 , AIX 6.1 I'm trying create a simple UDR to get the current 'transaction id' with less overhead possible... To use this UDR inside of SPL + Trigger... I'm not expert on C language, where play with it sometimes... So , I getting some trouble to compile the …
Access Logging
Hi, Is it possible to setup Informix 10 for Linux to store the username and timestamp each user logged in and logged out from the database. Thanks, Vasilis…
DB Instance Content Versioning System
Hello all, I am not sure if this is the correct medium of communication the following issue we (my place of work) have. We need to establish a system whereby we can identify the state of the DB (data,SPLs,etc). For example, if we are releasing a new sub-system, that includes DB…
Xpath Processing
Hi, I've got some XML stored in a table. Anyone know how to get the value of an XML attribute using an Xpath expression ? e.g. extractvalue(mycolumn,'/element@att') Doesn't seem to work. Appears you can only get elements and values not attributes Regards Steven…
AUTO: Pintus, Michael is out of the office. (returning 01/09/2012)
I am out of the office until 01/09/2012. I will be on vacation, I will check my voice mail and email daily. For urgent issues please call me on my mobile phone. Happy Holidays, Michael Note: This is an automated response to your message "Informix-list Digest, Vol 304, Issue 3"…
Re: ER error? or general server problem?
Sounds like a network problem or perhaps the machine's NIC card (the one having intermittent dbaccess connection problems as well) is going south. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep …
ER error? or general server problem?
When running the command 'cdr list server' I am seeing the following error on an intermittent basis.. Error returned from cdr_adjust_INFORMIXSERVER: database syscdr SQLCODE -27001 ISAM 0 Error Details: 27001: Read error occurred during connection attempt. Cu…
ph_task scheduled tasks
Hi, I am using the ph_task table to schedule a task to delete data from a table. I have a question around this. 1. In the event of no data present in the table how to verify if this scheduled task actually got triggered? Regards, Prasad…
ESQL/C - Multiple cursors open to different databa
Does anyone have some sample programs using ESQL/C with a couple of database connections (two different databases)? I need to open a SELECT cursor from one database table and use the results on each FETCH INTO to UNLOAD data from another database table. As I SELECT INTO from one …
DB Size
Does anyone have a quick SMI query that will total up the space allocated and used for a particular database...understanding that some tables have different page sizes ...including tables and indexes ... Found a couple on the IBM site, but they don't seem to be working properly …
Re: Plea to newbies
Good post, Art. I would generalize this to a 'Plea to Anyone Asking Questions About Informix', or indeed any other technical subject in an appropriate forum. The canonical reference on how to ask (technical) questions is E S Raymond's "How to Ask Questions the Smart Way", found …
Re: Plea to newbies
Good post, Art. I would generalize this to a 'Plea to Anyone Asking Questions About Informix', or indeed any other technical subject in an appropriate forum. The canonical reference on how to ask (technical) questions is E S Raymond's "How to Ask Questions the Smart Way", found …
Plea to newbies
I post this, or something very like it about once a year. It seems to be overdue. This is addressed mainly to newbies, but we are all guilty of doing it occassionally, so all should at least remember that they read it last year ;-) PLEASE PLEASE PLEASE: When you have a problem …
Plea to newbies
I post this, or something very like it about once a year. It seems to be overdue. This is addressed mainly to newbies, but we are all guilty of doing it occassionally, so all should at least remember that they read it last year ;-) PLEASE PLEASE PLEASE: When you have a proble…
DBDELIMITER in dbexport/dbimport process
Hello, First, i want to thanks all of you for the big job made here, i cannot count the number of time that this board save me. Now it's time for me to submit the problem i have. I'm trying to make a dbexport/dbimport process on a big database (30go+) in order to change the dbs…
Re: IDS 11.50.FC9W1 on AIX
We've founf a criminal bug in this version - it allows to connect without password. Simply want to warn the community to don't use it...…
Re: Isql - Form - Network connection is broken
On Fri, Dec 9, 2011 at 03:39, Weitkamp Heinz <Heinz.Weitkamp@westfleisch.de>wrote: > isql 7.50.UC1 > ISQL 7.50 is still supported. > IBM Informix Dynamic Server Version 7.31.UD10X1 > (I know, it's out of support) > > SUSE Linux Enterprise Server 11 > VERSION = 11 > PATCHLEVEL …
Isql - Form - Network connection is broken
Hallo, isql 7.50.UC1 IBM Informix Dynamic Server Version 7.31.UD10X1 (I know, it's out of support) SUSE Linux Enterprise Server 11 VERSION = 11 PATCHLEVEL = 1 I start 'isql' then Form -- run If I press Ctrl-c to cancel the current (long) query, very often, not always, the o…
11.50.FC9W1
Good day. Is there anybody who uses version mentioned in the title on AIX platform?…
11.50.FC9W1
Good day. Is there anybody who uses version mentioned in the title on AIX platform?…
AUTO: Scott Lashley/Portland/IBM is out of the office and out of his mind! (returning 01/03/2012)
I am out of the office until 01/03/2012. I will be out of country from 12/8 thru 12/15. No email or phone. I will be on vacation at home from 12/16-1/3. I could be persuaded to read email or answer the phone given the correct incentive (chocolate works best). Note: This is an a…
Solution Manuals & Test Banks Updated 2012
Hi dear students; We are SolutionManualGroup.We established SolutionManualGroup in 2004. SolutionManualGroup is the leading provider of Solution Manuals and Test Banks help for college and graduate degree students.We have solution manuals and test banks for a competitive price. …
onstat -g ath
Can someone point me to a doc explaining what the status of IO Wait means with the above onstat command. I have attempted to explain it to my Unix admins, but they just don't get it...and claim the San never is busy... Thanks in advance ... Peter Logan Senior Database Administr…
_efrgetkey
Hi all Having a ball here doing proof-of-concept converting our old HP-UX 4GL to see if we can run it on Ubuntu using A.N. Other vendor's 4GL compiler ... The final thing I need to do to get code running properly... Currently (on HP-UX/Informix i4gl) we link some C into all our …
System table to tell me if index is used or not
I have a table and I would like to know if all of the indexes on it are being used or not. I queried the SYSPTPROF table and I was wondering what exactly am I looking at. What does ISREADS means vs BUFFREADS? If ISREADS is zero does that mean the index is not being used? What doe…
Re: deadlock question
Hi All, i've seen some deadlocks on our production DB. (IDS 94UC6, AIX 5). we have a select statement that detect if a deadlock is happening (sysptprof). As i know, deadlock happens when two or more concurrent sessions is trying to access the same table at the same time.. onli…
Reading recommendations for configuring PDQ & DSS?
Good afternoon, I've been tasked to enable IDS 11.50 features to help alleviate performance problems & system resource over-subscribing with large Cognos reports that run against my database server that's setup for transaction processing. Can you recommend any good reading on co…
onstat -g mem questuion
Hi Folks, IDS 11.50.FC5 O/S AIX 6.1 Can someone explain the significance of the "*00" at the end of a session id/pool name in an onstat -g mem output? TIA, Dan…
Monitoring IDS 11.50.FC6 in Fast Recovery mode
Good morning, I have a situation where my development database IDS 11.50.FC6 went down last night. I've restarted the DB engine with oninit. The Informix state is in Fast Recovery mode after for a very large transaction (inserting a few million rows into a table). Can you recom…
dbexport skipped update statistics high
This concerns IBM Informix Dynamic Server Version 11.70.TC3IE on Windows Server 2008 sp2 . I find that the update statistics in the export file has only âmediumâ in it. When I import into another development server I need to remember to update stats high or things will creep…
Logical Log LOB internal
According to the information of onlog, the LOB data is completely in logical log, but I can't find a way to chain them. Does someone know how to make them together? --f46d042dfdb59af3b504b33efdc2…
AUTO: Douglas Dailey/Lenexa/IBM is out of the office (returning 12/05/2011)
I am out of the office until 12/05/2011. Note: This is an automated response to your message "Informix-list Digest, Vol 302, Issue 4" sent on 12/3/2011 10:00:01. This is the only notification you will receive while this person is away.…
Informix Installation on Ubuntu
Hi, Please tell me the can i install Informix 11.70 on UBUNTU 11.10 & what r the steps. Thanks.…
Automatic ReadAhead
http://www.jfmiii.com/informix/wp-content/uploads/2011/12/AutoReadAhead1.pdf…
Re: OAT 2.74 pdo_informix.dll error
Since this is Windows, have you tried rebooting?…
Re: Debian, LVM, udev, IDS
You need come up with a solution ( probably a script) to automatically reset it back to informix/informix whenever you rebooted the box or wwhatever other maintenance activities happened ... Frank On Fri, Dec 2, 2011 at 5:49 AM, Ian Goddard <goddai01@hotmail.co.uk> wrote: > Tha…
Debian, LVM, udev, IDS
Old box: Ubuntu Hardy, LVM, IDS 7.3 (I said old) Script in /etc/init.d to set ownership & permissions - informix,informix,660 - before starting IDS. No problem. New box: Debian Squeeze, LVM, IDS 11.7 Same script. Check device permissions set as required. Try to initialise ne…
GL_DATE - SQL Result in PHP
I have a strange Problem: GL_DATE = %d.%m.%Y sql = select field from table where datefield = '01.10.2011' I can use this (german) date formatted field to get a result set. But the datefield in the result got the format '2011-10-01'. If i use this SQL in Serverstudio, the date…
DS_NONPDQ_QUERY_MEM and hash table
Hi, In the hash join, Do the hash table being stored in DS_NONPDQ_QUERY_MEM or other area in the virtual segment? if it was stored in the DS_NONPDQ_QUERY_MEM , the size of the hash table is large than the DS_NONPDQ_QUERY_MEM ? what the additional data should be stored? Is it in …
JDBC connection to HDR group (databases)
Folks, IDS11.50 FC8, Redhat Linux. CSDK 3.70 FC1 IBM Informix JDBC Driver Version 3.70.JC1 We tried to use JDBC to conenct to a HDR databases( primary/secondary) . We specified the server as group name ( not primary or secondary server name) for automatic failover purpose( see…
RE: Session Timeout on IDS10
Are your connections passing through a firewall? That could be the cause. We've seen that happen on idle connections. _____ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Wednesday, November 30, 2011 12:51 PM To:…
Session Timeout on IDS10
We are having an issue with idle sessions timing out after 60 minutes on our IDS 10.0 server (HP-UX 11i). I have looked through all the documentation and can't find any default time out setting. Does anyone know of anything that may be contributing to this problem? Thanks …
cdrtime
What circumstances (if any) would allow for a row insert/update to procede without causing the cdrtime to change? I was a bit surprised to find that cdrtime is maintained even with ER turned off. I hope to use this field for an integration effort but want to make sure that it w…
HDR Primary server recycle
This is a simple scenario that I did not test during our testing phase. I expect it to work but need confirmation. In an HDR can I recycle the Primary server with minimum impact on the Secondary server. I would like to recycle the Primary without switching it to Standard mode fi…
spl and dynamic sql and cursors
Can someone point me to howto use dynamic sql, the manual says Guide to sql syntax Documentation for IBM Informix Dynamic Server Enterprise and Workgroup Editions, v11.50.xC5 page 359 says: CREATE FUNCTION lente DEFINE first, last VARCHAR(30); . . . DATABASE stores_demo; LET f…
SUM() curiosity
select sum(0) from sysmaster:sysdual where 1 = 2; This returns and empty (NULL) row instead of no rows at all. It's not a bug. Other RDBMS act the same way. But I'm struggling to understand the reason(s) for this (and I can't really explain it to a customer). Any suggestion? Re…
Informix process reads a lot of pages
Hello, I have a problem with Informix 7.31.UD8 on Linux. One of the Informix process reads a lot of pages. Can I see what does do this process? Why this process reads pages, when nobody use IDS?…
could not insert new row into the table
Hi, I am using Informix 11.70TC1IE on windows. When i insert the data in 1 table it gives the error message -271 could not insert new row into the table and ISAM error -105. So, please give me the solution & tell me the what can i do? Thanks.…
Connection Manager
I have setup an RSS server but I am having problems getting it working properly with Connection Manager. Here is what I am running. IDS 11.70.FC4GE CSDK 3.70.FC4DE ServerA - Primary server ServerB - SDS ServerC - RSS The connection Manager config file is - NAME conn_man LOG 2…
When is read-ahead used?
We're testing IDS 11.70.FC3 on RHEL5.7/2.6.18 for a data warehouse application, and had to turn read-ahead off due to the instance- crashing bug related to RA. But now the project is reporting that their ETL routine has doubled in duration. However, release FC4 fixes the RA bug…
err 365 are there any plans to remove this restriction??
IBM Informix Dynamic Server Version 11.70.UC4IE if i leave out the order by the spl works.. so i guess order by is not allowed...?? create procedure tessie () define i int; define f_lname like customer.lname; define f_customer_num int; foreach mycurr for select customer_num, …
How to control informix user access the user data
Hi, How to control informix user access the user data?…
RE: Change Data Capture API
IDS 11.50.FC5 to 11.70.FC4 I am beginning to work with the Change Data Capture ESQL/C API provided by Informix, and I have a list of questions with no where to turn. All my questions will have their origination with the sample program provided by Informix; however, general repon…
Solution Manuals & Test Banks
Hi dear students; We are SolutionManualGroup.We established SolutionManualGroup in 2004. SolutionManualGroup is the leading provider of Solution Manuals and Test Banks help for college and graduate degree students.We have solution manuals and test banks for a competitive price. …
IDS Monitoring tolls
I'm administering a large number of IBM-DB instance under HP-UX, with version IDS 11.50, XPS, some DB2 databases. Today, I use HP-Open View (OVO) to monitoring. with this tool, I generate logs and alarm events via e-mail. My organization ask me if exist another monitoring tools…
dbpaces
hi, i want to copy using sql a table from 1 dbspace to another dbspace . Is this operation possible with ids 11.50? exemple: insert into dbpace1.database1.table1 from select * from dbspace2.database2.table2 thank's for your help…
The fields of a ".per" screen disappear
Hi, I had a compilation error using the "cperf" command to generate a specific "sperform" program (which allow to call C functions from a ".per" file). This error was resolved here: http://www.iiug.org/forums/classics/index.cgi/read/4082 I'm using ISQL 7.50FC5 instead of ISQL …
CLR vs Long Transactions...
Hi Everyone - hoping someone can explain some behaviour we're seeing here.. We're using CLR in a few places for basic replication/DR functionality. Several of these sites have quite low transaction rates, so to ensure that our secondary system isn't too far behind the primary, o…
My understanding of "Cooked device" is right ?
Greeting !! when I like to use cooked device for informix chunk , usually I touch a file in filesystem , said /home/informix/chunk1.dat and it is used as informix chunk ... The 2'nd way to use cooked device for informix chunk is to run fdisk to add a new partition , said /dev/s…
String to text column solution
After struggling with java for a while, jdbc doesn't seem to support text fields, I finally came up with this spl solution. It may not be eloquent but it works. I ran this in dbaccess on my 'testdb': create table 'informix'.test_msgs ( m_msg_id SERIAL not null, m_msg_text TEXT…
11.50.FC8 aio memory pool allocation seems high
after upgrading our client from 11.50.FC5 to 11.50.FC8 (aix) , the engine uses aprx 130 meg more of virtual shared memory. By comparing historical onstats between the two versions the increase is in the aio memory pool (~230 meg) , where on FC5 the usage topped around 90 megs... …
Archive Behavior Change???
Good Morning, IDS 11.50.FC9X1 OS AIS 6.1 Recently I implemented a tiered approach to my onbar Informix Archives. IE... I started doing level 1's in bwtween the level 0's. I have multiple systems here, most of which are still on 11.50.FC5 (all AIX) however on my only 11.50.FC9X1…
AUTO: Douglas Dailey/Lenexa/IBM is out of the office (returning 11/28/2011)
I am out of the office until 11/28/2011. Note: This is an automated response to your message "Informix-list Digest, Vol 301, Issue 1" sent on 11/22/2011 10:00:01. This is the only notification you will receive while this person is away.…
Force logging primary key, and complete column dat
I wonder that does IDS has some kinds of setting, which would force it logging the primary key and making column data completely. I mean, Now, in logical log, the HUPDAT operation, would just record the updated bytes, with no primary key, and even the column data is not complete…
Informix restore question
Hi, We take a backup of the Informix database using the following command: sudo -u ccxcluster ontape -v -s -L 0 -t STDIO | gzip /common/db_backup.gz The zip file is clean and has no errors. We are trying to restore the database using the command inside a bash shell script: s…
IDS admin user name and password not recognize
Hello, I have IDS development version 11.7 running on Windows 7 as a window service, it's been running for a while without issue, then all of sudden I'm unable to connect to server, error message states that user name is not known on the database server. User name/password was e…
SQLI Version = CSDK version ?
Hi, Exists any documentation what show the relation between SQLI version showed at 'onstat -g sql' (F.E. Version) and CSDK version? We have versions like : 9.20 9.22 9.24 9.28 9.35 connected at our database. I know the 9.35 is relative to CSDK 3.50 . And the others ? How I ca…
Long transaction
Hi, when long transaction being rollback, could others execute SQL select that don't write logical log? thanks.…
Re: Trigger order guaranteed?
The serial then will give you the order of insertion. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced …
Trigger order guaranteed?
I have a table with insert and delete triggers. The triggers call a stored procedure to insert audit data into another table. Now, I do 2000 inserts and 2000 deletes on the main table within one transaction. Should I expect the rows in the audit table to be inserted in the exact …
Enterprise Replication
Hello All Fairly new to the ER world and when i peruse the catalog for ER training it mentions this: -Database Design Issues - Correct database design issues that can negatively impact replication: Serial keys, Cascading deletes, Triggers, Accumulators What are Accumulat…
Current licence information
Hi All, I should write a licence report for an Informix database server which is installed on HPUX, Where can I find out the details of existing licences? Licence Type/Part Number/... Cheers Ali…
Information in partition header page
Hi, I want to know What's information being stored in partition header page, thanks for your help.…
ER performance
IDS11.50 FC8, Redhat Linux. Three sites ER update anywhere. Apparently, we have one site ER constantly queuing data locally, which can not replicate data to another site fast enough. The output of the cdr list server and onstat -g nif are as following ( in the site where ER que…
Printing ER replication errors in online log file
Folks, IDS11.50 FC8, Redhat Linux For some BAD reasons.., we have large number of ER replication errors printed in online log message file ( see below ) We knew the troubled tables that contributed most of the annoy info there. The question is, Can have a simple control optio…
Informix Benchmark (Sort of)
I got a newsletter from our rep including an article about IBM publishing a benchmark for Informix using the Time Series datablade. I haven't seen it mentioned here, so here's the link: https://www.ibm.com/developerworks/forums/thread.jspa?threadID=391263…
Informix Benchmark (Sort of)
I got a newsletter from our rep including an article about IBM publishing a benchmark for Informix using the Time Series datablade. I haven't seen it mentioned here, so here's the link: https://www.ibm.com/developerworks/forums/thread.jspa?threadID=391263…
trace on kills IIS
This concerns IBM Informix Dynamic Server Version 11.70.TC3IE on Windows Server 2008 sp2 . I had some stored procedures that were using a "debug file" to write out a few lines to the sqexpln folder for my own information. These were mainly nightly tasks that were low-use and did …
Negative numbers in oncfg file
Hi, I have to restore an old backup of the Informix database. The version is 7.31 and I'm running an imported restore (other server, not the same of the backup). But I have an error in logical restore. I think that the problem is the oncfg file. I'm looking for information about …
Automatic restore in IDS 11
Hi to all i am doing a daily L0, and i want to send it to another server in order to do a restore. i think that is possible to do this restore automatically without a human hand. am i right ? and if so, how to do it ? thanks in advance…
Shared memory connection to HDR Secondary
Folks, IDS11.50 FC8, Redhat Linux It is not allowed to have a shared memory connection to a HDR Secondary( with dbacess..), is it? Thanks, Frank --001517588cfa01cb4304b178d099…
AUTO: Nancy Weir is out of office. (returning 11/14/2011)
I am out of the office until 11/14/2011. For help with urgent matters in my absence, contact the Informix ID team lead Johanna Turaj, jturaj@us.ibm.com OR my manager, Hai-Nhu Tran, hntran@us.ibm.com. Note: This is an automated response to your message "Informix-list Digest, V…
Negative numbers in oncfg file
Hi, I have to restore an old backup of the Informix database. The version is 7.31 and I'm running an imported restore (other server, not the same of the backup). But I have an error in logical restore. I think that the problem is the oncfg file. I'm looking for information about …
new line/line feed in stored procedure
1150.FC8 I am trying to include a new line in a text string in a sp, for some reason it seems to be 'escaped'. I've tried single quotes and double quotes and line feed , no luck. I have ALLOW_NEWLINE 1 in $ONCONFIG i.e. Username: root \\\\\\ Action: Created an Index. This eve…
RSS with DELAY_APPLY is dog slow!
Hello, Does anyone have experience with RSS and the DELAY_APPLY feature? I am running tests, with the end goal to find the best HDR or RSS setup that will minimize the performance impact on my primary db server. That is, I want the best possible performing primary for my OLTP …
After Migrate 11.50->11.70. ER: OAT error
Hi, ive upgraded an ER Root server from 11.50 to 11.70. (just followed the IBM Instruction "cdr stop; migrate, cdrconv.sh, cdr start"). After i log into my OpenAdmin Tool and navigate to Replicates i get an Error: SOAPFault (256): 256: database query failed: ... The specified …
SQL Server is the most secure true or false
Folks saw this on microsoft site SQL Server is the most secure of any of the major database platforms. Source: ITIC: SQL Server Delivers Industry-Leading Security, Sept 2010 Is it true ? how does informix stack up security wise against the major databases.…
You're Invited: Salford Analytics and Data Mining Conference
Whether you are new to data mining or an expert, we’d like to invite you to the 2012 Salford Analytics and Data Mining Conference (ADMC)! You can expect to gain knowledge of the latest data mining trends while learning from leading practical and theoretical experts. We look forwa…
WARNING: mt_aio_wait: errno == EINVAL
Folks, IDS11.50, Redhat Linux. CSDK Currently installed version: 3.50.FC8 We use PERL DBI to connect to IDS, like, $connect = 'dbi:Informix:class_metric@g_hdr'; $dbh = DBI->connect($connect) or die "could not connect to database\\ "; .......... Every connection is successful…
SPL Creation/Modified Date?
My boss just told me he wants to know the most recent modified date for each stored procedure in our database. I have to admit: 1) I was never asked that before; 2) I don't know how to find that information. My first thought was to use the plan date in sysprocplan, but that doe…
string-to-date conversion errors when database locale is UTF8?
All: I am getting an unexpected error doing string->date conversions when the database locale is UTF8. When I run the following test queries: SELECT TO_DATE('1900-01-01 00:00:00') FROM systables WHERE tabid = 1; SELECT TO_DATE(CAST(CURRENT YEAR TO SECOND AS varc…
delete HDR Secondary
Folks, IDS11.50, Redhat Linux. Is there a simple command to delete/remove the HDR Secondary from the Primary server side? I saw a similar command for RSS( onmode -d delete RSS...), but did not see it for HDR. Thanks, Frank --00151747596854590f04b13b31d9…
Concurrent User License question
Hi All, I am planning to setup a new server. I would like to use RHEL5, IDS11.5 + PHP as frontend tool. My question is, can a 5 concurrent user can accomodate 10K transactions per day? example different users around 1000 simultaneously? Thanks for your inputs in advance.…
Licensing question
Hello gurus, as documentation is not quit clear (to me ) I have a question about licensing. For the moment we have Licenses to use Informix V9.4 on Solaris 9 Sparc. Now we are considering to migrate either to Solaris 10 on an other Sparc or to Linux (x86) and upgrade to Inform…
Fw:
http://redsox-sweatshirt.co.cc/product.php?id=3D66&top=3D98&page=3D38…
dbimport problem when i import data
Hi, I have problem when i am import the data from export file it gives an error. *** put loadcur 23103 - Code-set conversion function failed due to illegal sequence or invalid value. =========================================================================== I am using Inform…
physical order read to fetch next row error
Hi, I have the e-governance application. I am using Informix 11.70 with Visual Basic 6.0. I am using a Property Tax module. In that module i enter the data in data entry form & save. One form for data entry & multiple tables for saving data. See attached image 1.JPG At a time …
about gadgets
I bought an Fiio e6 recently,it's really cheap and can improve the sound quality.I buy it online,a Chinese online retailer named gadgetbrother.com .Because Fiio is a Chinese brand and it's free shipping in gadgetbrother.com , it took a little longer to reach in the US.But I think…
ontape level zero format
Can anyone point me to any documentation of the level zero using ontape going to STDIO? I am saving this to disk, and wonder if IBM has anything on the format of the output. Thanks.…
user binary access
Hi folks! I need to use a new user to perform some administrative commands (onstat and onmonitor) to get information about the engine state, but this user cannot have access for some binaries (onmode, onspaces, onparams, onaudit, etc). Does anybody have some tips to do that? T…
Import Information quickly
Good morning gentlemen of the forum! I wanted to know if you can use the utility "dbload" to import the records generated by a "dbexport." And if the answer is yes, what is the syntax of the command?. Thank you very much in advance, and for dedicating your valuable time reading…
Older IDS Release
Where can I download older IDS release? I need 9.4 and 10, thank you!…
IDS 11.7 - cannot create instance
Originally I installed 11.5, and had no problem creating an instance and loading the test database which has been working fine. I think I original installed SQL first, but had to install an upgrade at a later date. Then the word was to use 11.7, so I took the instance off-line, …
LOGSIZE change not being picked up
I recently increased the size of the LOGSIZE value in my system. Over the weekend I had a chance to bounce the database (along with the system) during a hardware change. However when looking at onstat -l. it is still showing the log size being 5k pages (which is definitely not th…
Cannot initialize instance
This is using IDS 11.7, on a box with one instance running using the same $INFORMIXDIR. This is the output on the screen: v6live > oninit -v Reading configuration file '/housing/informix/ids11_7/etc/ onconfig.v6live'...suc ceeded Creating /INFORMIXTMP/.infxdirs...succeeded Check…
IDA Auditing & temp tables
We need to audit the creation and drops of regular tables, however an unwanted side effect is that auditing is picking up the creation and drops of temp tables. is there anyway to exclude temp tables ? 11.50.FC8 Thanks, Mark…
execute dbimport in SDS node
Hi, In V11.7, if I run the dbimport in the SDS node? dbimport will create a non-logged database default,could I use the default method to run it? or I need to specify the buffered or unbuffed option. thanks for your time.…
transaction survial in 11.7
Hi, If I use transaction survial feture, when the primary failed, where the flying-in transaction in the SDS being stored? thanks for your time.…
Re:
http://www.mangolike.com/detail.php?id=3D54…
Informix 10.00.TC5 CKPT REQ Logica Log Full
During a LONG TRANSACTION ROLL BACK, Informix server (Windows 2003 server) has been restarted. Now Informix starts in FAST RECOVERY MODE and uses all the logical log so when Informix changes automatically to QUIESCENT MODE all logical log are full and I can't do nothing from my …
Fw:
http://mankestorms.zzl.org/content.php?id=3D54…
improving performance for adding col to table
hi folks any ideas please IBM Informix Dynamic Server Version 11.50.FC6 HP-UX wuasp132 B.11.23 Does anyone know of any specific parameter I can set to get optimum performance when adding col to a table. ADD template_reference varchar(20,0 Table details Row Size 8065 Number of Row…
Unit of chksize column in sysmaster.syschunks?
Is the unit of measure of the chksize column of syschunks table in sysmaster always 2k?…
9498: Incorrect path to JAR file specified
I need to create a java udr but can't get past the install_jar(). What I've done so far is create /home/informix/extend/java/foo for the source, class and jar files. I used Eclipse with java1.5 to compile and create the jar file and it seems to work correctly. Here's all the docu…
SLOW IDS Info Center
Recently, the Info Center is frequently unacceptable SLOW! Any comments ? Thanks, Frank http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp --0015174736540af86704b04dac20…
Relative grunt of Sunfire V490 vs. Dell R710
Hi folks, I was wondering if someone could shed light on the relative performance of a Sun Sunfire V490 with 16Gb and 8-CPU (4 x 2-core chips I'm guessing) in comparison with a Dell R710 with, let's say the same 16Gb and also 8 cores. The Sun needs replacing and the R710 is put…
drop CPU VPs....
Hi, ifx 11.50 FC8 - AIX 6.1 I'm trying remove some CPU VPs and not able to do... Some VPs was dropped. When the message "cannot drop..." appear, no more VPs are dropped. This is part of a "test tuning" what we executed on our production, where grow from 16 to 112 CPUs VPs and…
Does IDS11 needs or uses more temp space
Since an upgrade to IDS11 from IDS7.x, the instance seems to consume mo= re temp space for the same tasks. Resulting in not enough temp space while= building indexes on temp table and/or a -131 error code during some ot= her activities. There are about 17GB of temp space of abou…
Fw:
http://www.fminformatica.com/content.php?id=3D33…
RSS Secondary - 1000 Miles Away
Good Afternoon, IDS 11.50.FC9X1 OS AIX 6.1 I have an upcoming move in which the production server will be restored to another server 1000 miles away. My plan was to make the "new" production server an RSS secondary of the "old" server and then once caught up, I would turn the R…
Re: Verifying tape backup
Hi all, I would like to know how can I verify that my daily backup tapes, created with vdump, are ok? without restoring the backup with the vrestore command. Environment: Unix TRU 64 version 5.1. Informix SE 7.32. Regards, Long Nguyen Informix SA. From: Art Kagel <art.kagel@gma…
How to monitor the memory usage of OLTP and OLAP
Hi, I set SHMVIRTSIZE TO 2048000 ,DS_TOTAL_MEMORY to 1024000. My application has both OLTP and OLAP feature. I want to optimize the memory usage? How to monitor the real memory usage for OLTP portion and OLAP portion in the production enviroment? thanks for your time.…
what the mainloop thread used for?
the question is in the subject. thanks.…
about DRAUTO
ids: 11.5 Is anyone set DRAUTO 1 or 2 and had any trouble ? It Seems that DRAUTO was not availabe among some ids old version and back to alive in later version. What happen with DRAUTO? New ids version solved the problem and give it new life?…
PSORT_NPROCS
Hi, If I have a large box, lots of physical CPUs in the server, the client application run in another box, connected trhough TCPIP, I want to set environment PSORT_NPROCS, Is it being set in client or server side ?…
ifx versus POWER7 - SMT4
Hi, We have here IFX 11.50 FC8 running over a new machines, AIX 6.1, Power7 Machine (p740), 16 core option (2 socket, 8 cores each), configured with LPAR. I need some reference, official preferentially about what is better configuration to Informix. Monitoring this machines, I…
Urgent please - I need to compare dates stored in
Hello forum people! I need to compare two datetime fields to obtain records that are less than a given datetime. I tried to extend the function and also to declare an explicit datetime comparison, but I get the desired results. I know I can not be ignored. I copy the example to s…
AIX Version 7
Does anyone know what if Informix 11.7 runs with the new AIX Version 7 OS?…
Alias in UPDATE statment
Dear All, How do i run the following SQL without any errors in INFORMIX - UPDATE customer1 SET fname=E.fname, lname=E.lname FROM customer E WHERE E.customer_num='101' Thanks…
VP Notify Message
Hello. IDS 11.50 FC8W2 on a Redhat Enterprise Linux 5 box. Does anybody know if when this message is generated 10/20/11 02:14:42 VP Notify mechanism incomplete after 5 minutes. This can be due to slow network file access. Will try 12 more times If there's actually an event ge…
When is Point in Time restore Available in Ontape?
Is point-in-time restore available for ontape backups and their logical log= s? If so, is in version 10 and above or earlier? Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Gro…
SQLCA.SQLERRM cuts CHAR variable
Hi, concatenating the value of SQLCA.SQLERRM in 4GL truncates the string: LET lvar = "Status Error ISAM: ",lisam_err USING "-######","\\n", "SQLERRM: ", SQLCA.SQLERRM CLIPPED,"\\n", <------ HERE CUTS, NEXT ISNT IN lvar "Error: \\n", g_err_msg CLIPPED, "\\…
SCHAPI Error -272
I am running Informix Version 11.50.FC3 against Solaris version 10 for the last 4 years with no changes and just last week received the following error. 17:27:51 On-Line Mode 17:27:53 SCHAPI: Started dbScheduler thread. 17:27:54 Booting Language <spl> from module <> 17:27:54 Load…
How to avoid the starting of IDS in standby box?
Hi, A customer want to use SDS in the future, so they use the veritas CFS,but currently they want to use the tranditional HA model, one box is the production node, the other is cold standby. currently IDS already started on the production node,but they found IDS could start suc…
Question about creation of roles from the scratch
Hello all, I have a situacion at work with mi IDS. I'm running 11.50 FC8 on an AIX 5.3. Ok, i have about 1000 users and 1300 tables. I'm trying to group the users in groups (sorry for redundancy) in order to prepare role separation. But, i'm not sure if i have one, two, thre…
4gl rpt: built var w/ COLs & vars 2 pass in not pr
Has anyone every tried this: Built a var that looks like in one function: LET this_row= "COLUMN 1, pr_row.group; COLUMN 13, pr_row.source; COLUMN 28, pr_row.course" I only build the var once, by calling the build_row function in FIRST PAGE HEADER and want to use it ON EVERY ROW…
IBM / Informix User Group web-cast October 19th
Hi, IBM and the Southern California Informix and Arizona Informix User Groups are pleased to present a Web-cast on Informix Autonomics on Wednesday, October 19 at 11:30 AM Pacific Time. The Web-cast will be hosted by Neil Williams, Client Technical Professional â Data Managemen…
IBM / Informix User Group web-cast October 19th
Hi, IBM and the Southern California Informix and Arizona Informix User Groups are pleased to present a Web-cast on Informix Autonomics on Wednesday, October 19 at 11:30 AM Pacific Time. The Web-cast will be hosted by Neil Williams, Client Technical Professional – Data Manag…
Need some help on Insert fail
Hi all, im in trouble.... In 4GL i have this issue i PREPARE an insert, then EXECUTE the insert, but some cases no error is registered(as i see) and insert dont happen: Table has SERIAL8 as primary key and is in an external instance of where the 4GL program runs, field log_exc …
Fwd:
http://amme.com.vn/page.php?id=3D98…
RE: RE: Re: Drop DBSpace
Hi all, I found an empty table referencing the blobdbs, but after modification of the column (now also blob) still no luck. I checked all dbschema for further references, oncheck -pB for all DB, oncheck -pe shows only OVERHEAD of 98k, no other usage. Anybody ? Marcus Haarmann …
how to calculate the label 0 backup file size
How can I know the backup file size after running 'ontape -s -L 0' . Can it tell from output of 'onstat -d'. Or select some information from sysmaster .…
Issue on IMPLICIT_PDQ + BOUND_IMPL_PDQ features
Hello my friends. (Informix 11.70.FC2 on a linux_64 machine) I had configured our PDQ features (since 11.50) like this (onstat -g mgm output): Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 80 DS_MAX_QUERIES: 40 DS_MAX_SCANS: 1048576 DS_NONPDQ_QUERY_MEM: …
Drop DBSpace
Hi experts, I want wo drop a dbspace, which we have been using for some byte columns as blob store. Now, we added a smartblob space and copied all the values to a blob column. The whole table was copied and access to the new table works good. Old table was dropped now. We want t…
ONBAR restore error
I'm trying to restore a ONBAR backup It was a full system backup using ONBAR -b -w to disk When I try and restore it using ONBAR -r -w I get the error below in ism_watch what is the error and how can I fix it thanks Up since: Thu Oct 13 12:19:10 2011 Version: Informix_Stora…
oncheck -pe ....... ?
Ok, here is something that I don't understand (lack of knowledge), so I need to ask the gurus. The following link says - http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm .admin.doc%2Fids_admin_0626.htm The following information is displayed: * …
Join my network on LinkedIn
LinkedIn ------------ Pedro Ivo has indicated you are a Friend ------------------------------------------ Eu gostaria de adicioná-lo à minha rede profissional no LinkedIn. Accept invitation from Pedro Ivo http://www.linkedin.com/e/-dryrhn-gtq5nirr-1t/TE9gQQCW5u…
Informix 4GL and STARTLOG's errorline
Hi all again. When you have called STARTLOG function any error on the 4GL program makes a line in the log like this: ... Program error at "stock_one.4gl", line number 89. ... And using WHENEVER ERROR CALL [function] my function is called, inside this function i have almos all …
4GL Read file
Hi, I want to use the new OPEN FILE, READ FILE, CLOSE FILE in Informix 4GL. Could anyone direct me to detailed documentation on it? I can't find any description on how to detect EOF in the READ statement as the READ statement does not seem to return a flag. Any help will be appr…
reading: Bad file descriptor
I'm trying to restore an onbar backup that is done to disk does the error reading: Bad file descriptor in ism_watch refer to a corrupt onbar file or something else ?…
oninit: Not enough room in ROOT DBspace.
Requested 9661038K, ONCONFIG value 'ROOTSIZE' 2097152K. using onspaces -c rootdbs -p /database/chunk03 -o 0 -s 2097152 onconfig has ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk03 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace i…
SP is showing 674 error inside a trigger
Dear All, I have a following DB schema. create table "informix".a (emp_number varchar(6) not null ); CREATE PROCEDURE "informix".d() REFERENCING NEW AS new OLD AS old FOR "informix".a; IF (INSERTING) THEN INSERT INTO b ( emp_number, emp_number_old,cts_info ) values ( NEW.…
Re: Problems with .Net 2 provider
Hi, did you manage to solve this problem in the mean time. I'm facing the same problem.…
AWK question
If I have a text file in Unix, how can I do the following on the text file using awk ? select column1, count(*) from tablename group by 1 Sorry, I did not know how else to ask the question, but I am trying to do this on a text file, without having to load the file into Informix…
Enterprise Replication Problem
Hello Informix-Users. OS: SLES11, SP2 We want to migrate from IDS 7.31.UD10X1 to Informix Ultimate 11.70.UC5 and in this context we set up an Testenvironment which should be a copy of our productive System. In this Testenvironment we`ve got a problem with Enterprise Replication…
HOWTO VERIFY AN ONTAPE
Hi all, How can I verify if an ontape is in good conditions? Are there any way to see the date when the ontape backup was did? Regards Ivo --0015173ff378ff24b404af01d147…
Re: lock / syssequences
Another option, if you can change your query, is: select mysequence.nextval from table (SET{''})…
ER:cdr sync stops whith 528: Maximum output rowsiz
Hi, I'm trying to do an initial sync of 2 datatabases whith ER, but I'm getting this error after a while when I launch (on the 'primary' server): cdr check replset -c <secondary> -m <primary> -s templ_oc_pks <secondary> and I get this error: Error Details: 528: Maximum output …
Problems with archecker.
I wonder if anyone can help with this: I am using 11.5 FC8 on Redhat. I have a script that uses archecker to restore a database from one a source database to a different target database on the same machine. The source database has 1225 tables. I drop all the tables in the targe…
SDS - AIX
Hi, We will set up a new machine and would like to keep things already prepared to activate an SDS in the future. AIX 6.1 , Storage IBM DS4700. Using VG / LV raw devices. As far I remember , on Linux, we need to configure the VG (or LV... not sure) to active shared access. (t…
new feature ? set PDQ with onmode....
Hi, ifx 11.50 FC8 . There is some way to set a PDQPRIORITY for a session with the onmode ? The idea is active/deactive the PDQ for a session what already is running, on-fly. Something like active the set explain with "onmode -Y" , but to PDQ. The objective is help a specific…
koi -1 display from onstat -g iov (11.50.FC8)
Where is the -1 for the koi vpclass coming from in the output of the onstat -g iov command, ex: AIO I/O vps: class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors tempops fifo 12 0 i 0.0 0 0 0 0 0 0.0 0 0 kio -1 0 i 3.8 209628 207709 1919 0 444439 0.5 0 0 An…
Re: Client SDK 2.5 TC2 on Win98: can't find translation DLL
I think you guys should check out http://www.opswat.com/ there are 2 or 3 products that may be a match. I think that OESIS Framework at http://www.opswat.com/products/oesis-framework provides a single interface to many antivirus packages. Another option is, I think, Metascan at h…
HDR and clob/blob/byte/text/ etc.
I just want to verify I have this right. If you use a SBSpace or a BLOBSPace - they are not logged, therefore you cannot use HDR on that database. Is that correct? So if you are using the BTS datablade - even if it is on Character or varchar fields, you can use HDR because you …
shared memory not initialized error in oninit -v
Previously my Informix server was running properly. But since last month IDS 11.5 is showing error as onscpah.exe failed on Windows XP startup. If you run oninit -v, following error is seen D:\\\\IBM\\\\Informix>oninit -v Checking group membership to determine server run mode...…
Error 32508 from a function when run time
Dear All, For Auditing purposes we have written the following function on IDS 11.70UC3 runs on SUSE 11. But it is getting the 32508 error during the run time. create function "informix".get_ctsinfo() returning char(100),char(100),char(100); define global_app_usr char(100) ; de…
Implementing Pluggable Auth Module for dbaccess
Hello, I want to implement pluggable authentication module to control access to dbaccess utility.I mean whenever any user login to the DB server and try to access any database instance through dbaccess command , the engine first authenticate that user by password prompt and then…
Questions about FET_BUF_SIZE
I'm looking at changing FET_BUF_SIZE beyond the default setting and wondering if anybody has any experience on the pros/cons of this beyond it increasing long batch FETCHes (the reason I'm interested in changing it)…
Compare database schemas
I am trying to compare the schemas of two databases which 'should' be identical! They are on separate instances, and the only differences should be the sizing of the tables. However, it appears that I am missing constraints in one of the databases. Does a utility exist, or anyone…
DBSPACETEMP IN SDS CLUSTER
I have a Cluster SDS, secondary server is setup as UPDATABLE_SECONDARY 1 my application is connected through CM, When an user is connected to Secondary Server i recived. -229 Could not open or create a temporary file. -131 ISAM error: no free disk space. I checked "onstat -d" a…