I am not an Informix DBA, but have been challenged with implementing a
logging solution for Sarbanes Oxley compliance.
What we would like to do is log all activity on the database by the
Informix DBA's. In particular, we would like to include log on/off

Hello,  We recently upgraded to 94fc8.  Per TFM, I am attempting to use the truncate table sql.  It is generating the illuminating 201 error.  The table has no constraints or views.  It's data is generated via a trigger from a master table.
syntax to date:  
truncate table yadda;

Is anyone using archecker successfully - any surprises to look out for ?
I would also appreciate if someone can point me to good documentation
about archecker.
Thanks

Hi, I was asked to try a restore for a client on version 7.31, using a
7.30 backup.    I told them that this was not supported, but they
insisted that I do the restore and prove that it doesn't work.
So I set up a database on another machine, took the 7.30 backup (that

IDS 94FC8 using ontape for a restore.  In performing a warm restore of a dbspace, how critical is it to have the exact same size and number of tempdb spaces?  I have a tape from a previous period before we added several new tempdb spaces.  I would rather not modify the system ...

I would like to check if I have in text column non alphanumeric characters.
Is it possible to do it with SQL?

See:
http://articles.techrepublic.com.com/5100-9592_11-6100380.html?part=rss&tag=
feed&subj=tr
I am not technical enough there ;-) I am pretty sure some of our Gurus could

You all want to see Informix in the press, so help IIUG achieving this goal by
sending the following information to me:
Name of journalist,
e-mail,

Running Informix version 10 FC5
is it possible to use the UPPER function as a default on a field?
for example :
create table 'informix'.city_state_zip (

How can I query the sysmaster SMI tables to get the number of "Active"
user sessions.  I know that I can get the total number of user sessions
from syssessions.  However, I would like the "Active" sessions.
Thank you in advance,

According to the Availability spreadsheet on the informix.com website, IDS
v7 is not available onthe Itanium chip.  Can anyone confirm this?
The website used to have a contact email address where someone knowledgable
about Informix - an American lady living in Basingstoke, as I ...

I have a problem when in my IDS 9.40 in Linux System 32 Bytes have more
than 1100 conexions.
Which is the max conexions for IDS? There are any parameter in the
Operatym System for more conexions or only it's a limit of Informix?

I've configured an IDS database with ISM for backup using onbar; in the
bar_act.log I see:
WARNING: Logical Logs will not be backed up / salvaged because
LTAPEDEV value is /dev/null

I'm setting up an IDS database for test purposes (both IDS 9.40.UC4 on
Redhat AS 3), so I unloaded a table from a production db into a file and
transferred the file to test node.
When I try to load data with command:

I am using ids7.3.i print reports on dot-matrix printers fine.when i
setup a laser printer i get a blank page.Any ideas that can help.
Thanks