Oninit® Archive
Results for “ENCRYPT_SMX”
Encryption/compression of backups
Is onbar the only informix tool that will do compression and/or encryption of the data being backed up? Can onbar do that with the basic ISM, or do you have to purchase a storage manager from another vendor (Legato, Tivoli, etc.)? What type of encryption does the base ISM use?…
Encryption in ontape for version 11.5
I've seen a bunch of posts where users do archives to disk, THEN encrypt the files and then send them (maybe) to tape, but is there any "direct" encryption by the ontape command in version 11.5? We're only on version 10, but plan on getting to 11.5 (or whatever is the latest begg…
Re: Pam for encrypt password
I don't think the problem is in Informix per se. The OP changed their encryption from "traditional" to "blowfish". The OP states that the "traditional" passwords were authenticated, while the "blowfish" passwords could not be authenticated. What it sounds like is that when he c…
InformixHQ H2 existing database encryption
Hello, You can only encrypt h2db as an empty DB for the first time. Once the h2db is created without encryption, you cannot encrypt it, and vice versa. ------------------------------ Shubham Kapoor ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Informix 14.10.xc11
The manuals are usually pretty up to date, specifically the "What's New" section where you can see the FC11 items. What's new in Informix ibm.com Specifically: Internal IBM Java packaged with Informix server removed • GSKit upgrade • InformixHQ 2.4.1 enhancements • Partial Index …
TLS/SSL with IBM Data Server Driver
HI, You need to put the certificate in a keystore and tell the client and server about the keystore. https://www.ibm.com/docs/en/informix-servers/14.10?topic=encryption-secure-sockets-layer-protocol Regards, David. ------------------------------ David Williams -------------------…
restore through STDIO
Hello. Unless you are trying to create an RSS node on your cluster, I don't see any benefits in using zip/unzip. 1-huge cpu consumption in a serialized method. 2-your network link should be already a high speed to accomodate your primary load for HDR replication. 3-if you are dea…
IFX 14.10xc8 Updatable RSS and CPU Usage
Hello, In dev env. i've configured a pimary with 2 rss. there is no user activity and i see a high usage of CPU when a do a onstat -z followed by onstat -g smx i've notice a very high number at #scheds onstat -z; onstat -g cpu | grep smx IBM Informix Dynamic Server Version 14.10.…
Potentially Serious HDR Bug 14.10.FC7W1
IT44118: AN ENCRYPT THREAD CAN LOOP FOREVER IN A RUNNING STATE WHEN ERRNO IS 11 ? You probably should be seeing the errno when stracing the VP... Going to be fixed in upcoming 14.10.xC11. ------------------------------ Andreas Legner ------------------------------…
HDR
Dear Casey, Now I have changed all settings. PRIMARY SQLHOSTS # sqlexec-ssl 9089/tcp on_nebula31 onsoctcp sk-om-ifx-402 soc_nebula31 on_nebula32 onsoctcp sk-om-ifx-402 soc_nebula32 ~ PRIMARY /etc/services soc_nebula31 51001/tcp soc_nebula32 51002/tcp PRIMARY /etc/hosts.equiv # ho…
Index page size recommendations
" We've been told to rely on the storage system to do both encryption and deduplication (rather than compression)." May God have mercy on your soul. ;)…
ontape error
idsdb00105650 ( IT32529 ) : With extended Checkpoint/Log reserved pages and encryption at rest with rootdbs encrypted, server may fail to come online…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
dbspace encryption and upgrade IFMX in-place
In auto-response mode :-) ( got the info from the Tech Support) Upgrade to 14.10 with encrypted dbspaces works fine if you encrypted with AES256. It won't work with AES 128 nor 192 in xC1. It is a known issues that will be fixed in 14.10 xC10…
Replication (RSS) instance it not coming up
Hi All, I an new to the Informix anf getting below error. Please help IDS version : 12.1 OS : SUSE Linux Host Name : Server1 Server1 is hosting 17 informix RSS replication instance. we have create 1 replication instance around 1 month back. it was running fine. On one file day …
Activate RSS Encryption?
IDS 12.10.FC12 Solaris 10 1/13 What is the specific procedure (sequence of events) to activate encryption between a primary and an RSS? I believe one need only set the ENCRYPT_SMX parameter. I think it needs to be set on both ends (but don't know for sure). I don't know if the …
RSS Encryption Performance Hit?
Does ENCRYPT_SMX need to be set only on the RSS, only on the Primary, or on both? After enabling this network encryption, how can one verify that it is operating? Thank you. DG…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Encryption Key for Column-level Encryption
Hello All, We are potentially needing to implement column-level encryption for the first time, and I would appreciate some input from anyone currently using it. Can you give me an idea of how you are storing the password/encryption key? The manual states the below: "When you …
HDR is not working
Dear All, In our environment we have configured HDR. it is successfully configured. Today unexpectedly primary server got physically restarted with unknown reason. But as per HDR setup application should redirect to secondary server, which has not happened, still the secondary s…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
RSS does not apply logs
hello, I have the following situation. I would be very pleased if somebody could put a light into this. Thanks a lot, JUAN Primary: amc1_rss RSS server: amc4_rss RSS DeLAY_APPLY 5M Why does RSS secondary not apply logs up to 116024, having long past the 5 minutes delay config…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
cdr autoconf serv failed...
Hallo everyone. I have two servers with Informix 12.10.U8 (Linux) and I want to make an "update anywere" ER between then. Local network, no firewalls, CDR_AUTO_DISCOVER = 1 on both servers. host1: - INFORMIXSERVER=server1 - sqlhosts: g_1 group - - i=1 server1 onsoctcp host1 9088…
HDR- Distance and Latency
A couple of additional points. HDR communication is half duplexed over a single network connection while RSS ( SMX) is using full duplexed mode. Additionslly SMX can run in parallel over multiple network connections resulting is a significant boost to effective bandwidth. Sent fr…
onpassword utility related to Connection Mnager.
GSKit implements all the security and encryption, by means of providing required shared objects. So in order to use onpasswd, and later to be able to read encrypted file or use encrypted communication, you'll need to have GSKit installed. From: "MUKESH TANUKU" <mukeshbt1328@gma…
HDR Implementaion
Yes I am posting the Secondary server Online log 20:58:15 IBM Informix Dynamic Server Started. 20:58:15 Requested shared memory segment size rounded from 4308KB to 4796KB Mon Jun 12 20:58:17 2017 20:58:17 Requested shared memory segment size rounded from 110629KB to 110632KB 2…
ISSUE regarding IFXCLONE
Hello, After running ifxclone for more than 10 hours and being conscient that nothing was happening (just rootdbs and physical log dbspace were noted in the message log saying that physical restore was done, data dbspace had initied the physical restore but not yet done), (the in…
CDR DS CDRD_xx thread is aborting
HI, All, IDS11.70 FC8 A little bit complicated system generated the massive errors ( below). System architecture : a GRID is composed of 3 instances A, B and C. A is the grid master and also a HDR primary server of a Secondary read-only server D . A and D are configured with D…
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…
Compress Repack Slow Performance
Dear All, Have an instance of Informix 11.7.FC4 that runs on AIX PowerHA Cluster, IBM POWER machines, with 64 logical cores, 160GB or RAM memory and FC storage. Have a total of 600GB of chunks, containing few big tables within 1 DB (100GB (100mil records), 70GB, 50GB) fragmented…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
sh.addShard
Hello, IDS 12.10 FC4 RHEL Linux Used MongoDB shell to create a Shard. Did a bunch of configurations, setup, tests...... Eventually, I am stuck here, mongos> sh.addShard("leslie-dat:9171") { "code" : null, "ok" : 0, "errmsg" : "command failed -- undefined server (37) " } mo…
Data Encryption
With the recent rash of data breaches in the news, I'm doing some high level research for a presentation on data protection. I know that Informix supports network data encryption, column level encryption, and requires certain permissions on $INFORMIXDIR and the chunk files. Howev…
Wakeup RSS Server
I too get this (not very often, smx thread exiting posted to the msg log ) on a HDR pair 11.70.FC7 due to network issue or latency. About half the time I need to reboot the secondary, the other half the primary too. Each time I opened a PMR and on the last event I was advised to…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Encryption
anyone able to provide a quick breakdown of encryption in versions 11.70 and 12.x ? Our client is looking for complete "table level" encryption; to the best of my knowledge IDS only supports encryption at the column level. Thanks, Mark…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
RE: HDR replication with data encryption
Turn on SMX encryption for RSS encryption. Sent from my iPad > On Nov 29, 2013, at 11:27 AM, "LARRY SORENSEN" <lsorensen25@msn.com> wrote: > > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7. > > We have been performing replication locally, and so we have neve…
Using Informix ODBC with connection manager
Hello. As soon as you implement your CM, it will be a "network gateway" for your production cluster (and maybe redirect your connections to any cluster node, according to your CM defined policy). So, your ODBC connection will be changed from your database, to your CM hostname/p…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Encryption techniques
Hey everyone, I wanted to know from those of you that use an external product to do encryption at the database level- what product you use and how satisfied you are with it? so far I have found Vormetric that does this. Does anyone have performance numbers of how the database op…
Strange HDR behaviour
There is/was an issue with HDR regarding "SMX thread is exiting " and it does not re-establish connectivity unless the affected HDR server is restarted. (Unless it is fixed in 12.1). If that's the case then you would see the following in the msg log : 15:26:34 DR_ERR set to -1 1…
Replication problem or stand alone server problem
Does the onstat top line still show the primary server is in primary mode? If the logs on the primary are secondary are still compatible you could try putting the primary back into primary mode and run the onmode -d secondary again on the secondary. That sometimes works when th…
Frequent HDR failures: -25572 (oserr = 0 or 4) generally needing restart (11.50FC7 on SLES)
Hi All, I'm more a developer than a DBA, but after our DBA left, I seem to have inherited the job of supporting a number of servers running development databases on a free version of Informix - Innovator-C 11.50.FC7IE The development boxes are running as HDR pairs, and we've ne…
a problem with backup a logical logs
Hello, Yesterday I have a problem with the backup the logical logs and I attached the information that I got from Informix: Can anyone help me to find the problem in order to void this in the future? Any help will be welcome Regards Muthana Here is the information I get from …
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
Password encryption and Informix
Our Info Sec folks have asked that we change our OS passwords to be encrypted using sha256 instead of the md5. When we do this client tools which pass in the user id and password from another server do not work. We are running on AIX 6.1TL7, IDS 11.50.FC9XA, and a variety of diff…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Re: Password encryption
AFAIK Informix always calls the crypt() function, with the provided password to obtain the encrypted version and then checks if it matches with the stored encrypted version. I believe that crypt doesn't follow the alghoritm that was defined. The only workaround I know would be t…
Password encryption
We are running AIX 6.0 TL7 and Informix 11.50 .FC9XA. InfoSec has requested that we change from an MD5 encryption to a SHAH256 to pass audits. We have done this and now we have issues with passwords which are encrypted with SHAH256. When we reset the user to use MD5 it works but …
Using ifxclone to setup HDR
Original Post: I haven't played around with ifxclone as of yet, but that error on the target would seem to imply that it was having problems connecting back to the source. Can you post what the sqlhosts file on the target machine looked like? (just for note on solaris you can us…
SQL/Optimizer Question
Just eyeballing the schema provided I am guessing you will get 16 rows per 2KB data page. assumed row size of 120 bytes. WHERE i_case_relation_cd = 3 is currently evaluated to return 98,108 rows while we do not have the statistics on the table, the cluster value would indicate h…
Password Encryption
Hi All, IDS 11.7FC2 with replication Solaris 10 Informix Connect 2.70 I want to implement password encryption implementing CSM (SPWDCSM). Question: 1) How will the application (front end) handle CSM. Is there specific modules that the application have to call. The front end a…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
multi-threaded ifxclone?
I found a session from last years IIUG conference by Hyun-Ju Vega and it says the following in the powerpoint: Source archive data is sent to target using SMX (parallelism is controlled by BAR_MAX_BACKUP ONCONFIG parameter on target) I set BAR_MAX_BACKUP to 4 on my target machi…
Informix Clustered Indexes
On Tue, Jan 31, 2012 at 07:53, Tom Lehr <tomcaml@gmail.com> wrote: > Have been doing some reading about clustered indexing and wondering > what experiences other folks have had with them? > We currently do not use them in our high transaction OLTP world and am > a bit wary due t…
RSS with DELAY_APPLY is dog slow!
ok - I think you guys helped find it... > dbaccess sysmaster <<EOF > > SELECT * FROM syscfgtab WHERE cf_name = 'RSS_FLOW_CONTROL'; > EOF No rows found. Which looks like RSS_FLOW_CONTROL was not implemented in xC7. And watching onstat -g ath I notice the following (when testin…
HDR & RSS
On your first question, ENCRYPT_SMX is supported by 11.10, but it was probably no dynamic yet until 11.50 or 11.70. You will have to modify the ONCONFIG file manually and bounce the server for it to take effect. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blo…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Problem with check point
Hello All, My database is running on IDS 11.50.FC8W3 with HDR and RSS , I have a problem when I have tried to add space chunk of 8 GB in dbspace during the chunk addition database respond very slowly and ultimately checkpoint blocked up 70 seconds and following errors found in m…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
Error re-Starting SDS Secondary server
IDS 11.50 FC8X4 Linux I have an SDS secondary server that I started up last week. Today I made a configuration change and stopped/ restarted the server. When it attempted to restart, I got the following "Logical Log File not found." error. 08:36:02 Logical Log File not found. 0…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Issues in Data Encryption
Hi I am encrypting data of a field. The encryption functions always returns different output against same data and same key. I mean whenever i execute the encryption function for some specific data , it always returns a different output during each execution, where as the data a…
Failure with DECRYPT_CHAR
Thanks Jonathan ! The problem was indeed the length of the column (and the way I tested). I increased the length of the encrypted column, ran a "select length (encrypted column)" and found that for some data the original column length was insufficient. It is a bit surprising ho…
RE: Archive using ontape with incryption
IDS 11.70.FC2 Solaris 10 - 64bit What is the easiest what to backup and restore to tape using `ontape` along with encryption? Has anyone restored, having used encryption for the backup, successfully and without incident? Thank you. Larry…
RSS Cannot Connect
if RSS (or other secondary) does not receive any message (including heartbeat message) after IFX_SMX_TIME seconds wait, it will think the primary is down or network is broken, then the secondary will print out the error message in online.log and close the SMX connection. a coupl…
Encrypting Data in Transit with onsocssl
We have a requirement to encrypt data in transit from the client to the database. We are trying to use onsocssl with odbc, but have not had any luck. Does anyone have any experience with onsocssl with odbc access from a windows client? We can connect to dbaccess using onsocssl…
Encrypt/Decrypt Columns
you may need use both SQL function to encrypt and decrypt. the SQL encryption functions store some special information in the encrypted data, the SQL decrypt function will not recognize other encryption format.…
Informix RSS Issues - Slow apply of Logical Logs a
Has anyone came across this issue. When I first setup my RSS instance and turn it on "onmode -d RSS {primary}" it takes a long time to apply the logical logs from the primary (2 minutes per logical log) while the primary is generating a logical log every 30 seconds. I also noti…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Import restore issue
Hi, I was able to restore the database from inftest1 (prim) to inftest2 (sec) by ontape utility. But I still have problem with the "onmode -d secondary inftest1.newpiper.net" from inftest2 server. Please check out the output from below and advice. Thanks From inftest1 "onmode -…
SDS and SAN Storage
On Aug 12, 8:21 pm, rpa <ruediger.pa...@t-online.de> wrote: > Hi all > > what is possible and what is the best way to create chunks on a SAN- > Storage (NetApp) for SDS. > We are planning for IDS 11.50 database installations with SDS feature. > > OS will be LINUX (SLES or UBUN…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
HDR Error
On 17 Feb, 02:26, John Carlson <jwcarls...@yahoo.com.invalid> wrote: > red_val...@yahoo.com wrote: > > I keep getting an error when I attempt to turn on HDR on my secondary > > server with "onmode -d secondary <primaryserver>." The > > informixserver > > message log reads: > > >…
Suspending HDR temporarily?
On Feb 4, 2:39 am, Art Kagel <art.ka...@gmail.com> wrote: > There is a way but it's a bit back handed: > > - Checkpoint the primary and wait for the secondary to process the > checkpoint. > - Shutdown the secondary (so server A?) > - Change the sqlhosts file on A so t…
RE: encryption on IDS 11.50.FC5 on Solaris 10
Hi, There is no encryption built into either ontape or onunload. There are no command line switches to create or read encrypted files with either ontape or onlunload. For ontape, you can use the BACKUP_FILTER and RESTORE_FILTER onconfig parameters to pass the data through anoth…
RE: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
> From: domusonline@gmail.com > Subject: Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this? > Date: Mon, 7 Dec 2009 23:14:12 +0000 > To: informix-list@iiug.org > > Ian Michael Gumby wrote: > > I have to agree that the issue is interesting…
Re: How to secure ODBC connection
> From: red_valsen@yahoo.com > Subject: Re: How to secure ODBC connection > Date: Mon, 30 Nov 2009 09:53:20 -0800 > To: informix-list@iiug.org > > On Nov 20, 2:57 pm, LIGHT SCANS <light_sc...@yahoo.com> wrote: > > Sorry. You cannot encrypt ODBC. For internal systems you can > >…
How to secure ODBC connection
Sorry. You cannot encrypt ODBC. For internal systems you can restrict access to your company's internal network or use your company's network hardware to do encryption. For both internal and external (i.e. internet) you can encrypt with something like SSL, ssh or sftp. -L.S.…
RE: Encryption overhead
This competes with similar products from HP and probably others. Note: Its not encrypting the active database, just cooked files. So as you write to the disk, your data is encrypted. Again, this is a software based solution, it also has (IMHO) minimal value since 1) Your engine …
Re: Encryption overhead
If there is the need to encrypt the "entire database" it's possible to do it with IBM encryption expert (or eventually with any similar product). This "hooks" into the low level OS calls and can encrypt files/filesystems. Not sure it it works with raw devices. But when using it, …
Encryption overhead
One of our customers asks, about encryption: 4. Do you have any idea what is the performance hit by encrypting either specific columns or the full database ? Of course, it's a "How long is a piece of string?" question. But does anyone have a feel for some approximate figures o…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
ANYONE KNOW IDS USERS OR CONSULTING FIRMS IN NYC
I am looking for work in the New York City metro area. Can anyone refer me to an end-user or a consulting firm?.. below is my resume: Frank J. Rotolo, frank.pr@msn.com _______________________________________________________________________________ Summary: Over twenty six years…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Informix Encryption Questions
Dear All, I would like to get the information on the following two questions which are related to the usage of Encryption in Informix (IDS 11.50 FC4) How Informix provides key management? ===================================== While using decrypt_char function, we need to provid…
Re: 11.50.xC4 Compression with workgroup edition?
An easy way to distinguish between IBM (DB2 and IDS) compression and Oracle compression is to look at e.g. an employee table with, say names and addresses and other junk (like salaries ;-) Block compressions wins, as Mark points out, in fast changing data. Global compression wins…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Simple Password Encryption not happening
I have attempted to enable Simple Password Encryption yet my network sniffer still shows plain text passwords. conscsm.cfg (copied straight out of the manual): SPWDCSM ("client=/opt/informix/lib/client/csm/libixspw.so,server=/opt/informix/lib/csm/libixspw.so","","") sqlhosts: t…
Encryption in the engine?
Ok, so yeah, you have AES and 3DES encryption. But its software based. How can you seamlessly connect to a hardware based package. I mean there are add on cards and network appliances that are specifically designed to do the encryption. Add to this the newer libraries and highe…
RE: IBM Database Encryption Expert support for IDS
Gee, If I encrypt something on my linux/unix box, root can't read it either, unless root knows the key. As to encrypting chunks, there's another way. Use a cooked file system where the file system writes are encrypted. (This has been around for the past couple of years.) Again,…
Re: IBM Database Encryption Expert support for IDS
If you care to read the details, nobody is talking about encrypting a column. It's about encrypting the chunks in a transparent way to the oninit processes. And you didn't get the point about root access. Maybe it's my English. The idea is that root won't be allowed to read the e…
Re: IBM Database Encryption Expert support for IDS
Ian Michael Gumby wrote: > if you look past the marketing blurb, more smoke than mirrors. > Without encryption hardware, you're going to take a huge performance hit > if you're encrypting a column that you index. My understanding is that Vormetric uses a piece of tin on the side…
IBM Database Encryption Expert support for IDS
IBM Database Encryption Expert support for IDS: http://www.ibm.com/software/data/db2imstools/database-encryption-expert/ The latest fixpack (1.1.3) introduces support for Informix 11.10FC2 and 11.50. This means transparent data encryption without root access... Regards -- Fern…
Re: Smoke and mirrors...
On Oct 12, 2:20 pm, InDeep <ind...@indeep.com> wrote: > Ian Michael Gumby wrote: > > To your point. Yes IDS will perform much better that either Oracle or > > DB2 in a VM environment. > > Let's not make sweeping statements without facts. I have been happy with IDS > so far on VM…
Re: Smoke and mirrors...
Ian Michael Gumby wrote: > To your point. Yes IDS will perform much better that either Oracle or > DB2 in a VM environment. Let's not make sweeping statements without facts. I have been happy with IDS so far on VMware Fusion on my Macbook Pro, but I have not had a history of ex…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Managing IDS in IBM HACMP environment
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > ROBERT ROMERO > Sent: Thursday, May 08, 2008 1:59 PM > To: ids@iiug.org > Subject: Re: Managing IDS in IBM HACMP environment [12053] > > Appreciate the comments. > > We are plan…
Re: Optimizer Issues with 10.00.xC8
Another point of confusion that has me summoning the UPDATE STATISTICS gods. As a reminder, my test table ("foo") looks consists of five columns, col1-col5. Col1, Col2, and Col3 are integers, while Col4 and Col5 are character fields. I have a unique index on (Col1, Col3) and a…
High Extent Tables.
Quick question: 1. If I create a clustered index and drop it on a table with high extents, will that reorganize it and reduce the extents or 2. Do I have to unload the data, drop the table, re-create the table, and re-load the data or 3. Should I rename the original table to a…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: Pam for encrypt password
>From: Manoj Mohan <manojm@us.ibm.com> >That sounds right.. we need to have a PAM module which will take the >password encrypted with blowfish cipher and authenticate it >and then we should put that in the pam stack in the pam.conf file. > >Manoj But this isn't an Informix iss…
Pam for encrypt password
Hello, all. I have problem with PAM (Pluggable Authentication Module). I have IBM Informix Dynamic Server Version 9.40.UC8 on Solaris 9. I can't to adapt Informix for users authorization by PAM. In the past he used the traditional UNIX encryption algorithm for encrypting passwor…
RE: IDS10 and Encryption
I'm currently running 9.40.FC8 and will be upgrading to 10.00.FC5 soon, we are about to write an encryption program(s) for financial / personal customer data and was wondering if anyone had done something similar using the built-in encryption Regards Colin There are 10 types of…
Re: IDS10 and Encryption
ENSSSM? Is that the AES or 3DES encryption in the engine? (Sorry I know the feature, not the buzz words. ;-) Yes, I'm using it. I have a client where I needed to authenticate the user so that I could limit what they saw and limit others from seeing their work. (Its a sales for…
RE: IDS10 and Encryption
I'm looking into using column level encryption and was wanting any info on what people have done in that area Regards Colin There are 10 types of people in the world, those that understand binary and those that don't ________________________________ Subject: Re: IDS10 and Enc…
IDS10 and Encryption
Is anyone using this feature? If so what are your experiences, any pitfalls? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Feel like a local wherever…
Re: HDR recommendations
On Aug 25, 3:41 pm, Madison Pruet <mpru...@verizon.net> wrote: > mohitanch...@gmail.com wrote: > > On Aug 25, 4:12 am, Madison Pruet <mpru...@verizon.net> wrote: > >> mohitanch...@gmail.com wrote: > >>> On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: > >>>> mohitan…
HDR recommendations
On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: > mohitanch...@gmail.com wrote: > > On Aug 24, 9:59 am, Madison Pruet <mpru...@verizon.net> wrote: > >> mohitanch...@gmail.com wrote: > >>> On Aug 23, 8:45 pm, Madison Pruet <mpru...@verizon.net> wrote: > >>>> mohitan…
Re: Performance of column level encryption
I have used Informix's encryption. Carsten is correct, using encryption you will incur some overhead. You really don't tell us much about your application. You say you have to encrypt a couple of columns but you don't really give us a use case or a rough example of your applica…
Re: Performance of column level encryption
On Mon, 2007-07-30 at 22:33 +0000, mohitanchlia@gmail.com wrote: > Version: IDS 10 > > We have need to encrypt few columns of the database. One of the > options I looked at was encryption functions provided by informix. > But, when I asked some of the consultant they told us that…
Performance of column level encryption
Version: IDS 10 We have need to encrypt few columns of the database. One of the options I looked at was encryption functions provided by informix. But, when I asked some of the consultant they told us that Informix has performance issues in using their encryption functions. They…
Re: Informix beats Oracle
Aleksander Kamenik wrote: > Madison Pruet wrote: > >> ontape -s -L 0 | gzip | encrypt > backup_device... >> > > Shouldn't that be "ontape -s -L 0 -t STDIO" ? > > Anyway, that's pretty much what I'm using except for the encryption > part. What do you use for encryption exactly, an…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
RE: Encryption Question
>From: John <john_hibner@earthlink.net> >Hello Everyone, > > Does anyone know if Informix can alter the encryption password or key >on the fly, as opposed to decrypting and then re- encrypting? >If so what is the syntax? I looked in the manual(online) does not show >that ty…
Encryption Question
Hello Everyone, Does anyone know if Informix can alter the encryption password or key on the fly, as opposed to decrypting and then re- encrypting? If so what is the syntax? I looked in the manual(online) does not show that type of functionality. Thanks, -John Hibner…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Encryption with BLOBS
I have a client that is wondering if anyone has experience with encrypted BLOBs and IDS. Anyone? They haven't started using them yet, but are wondering about performance implications and other pertinent issues, good or bad. I assume they're v7 blobs btw, not slobs (uh - smartblo…
Re: CSM Question
Martin Fuerderer wrote: > Hi, > > I would have thought that ENCCSM includes encrypting > the password as all the communication between client > and server gets encrypted ...? > But I may be quite wrong with this as I have never looked > into the details of ENCCSM. > ENCCSM is ne…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: ontape encryption?
Hello, On Jan 4, 4:42 am, chud <chrishud...@gmail.com> wrote: > Hello, I am a Linux admin with some past database experience, however I > am new to Informix. We are running Informix IDS 9.4.0 on RedHat ES 3 > and 4, and we do backups via ontape to a tape device. I have been > …
Re: ontape encryption?
chud wrote: > > > Additionally ontape can backup/restore to/from STDIN/STDOUT. This is > > useful if you want to do something like. > > > > ontape | gzip | encrypt > /backup/bkup.dat > > Can anyone add to this? Could you possibly use GPG? Do any of you > encrypt your ontape ba…
ontape encryption?
Hello, I am a Linux admin with some past database experience, however I am new to Informix. We are running Informix IDS 9.4.0 on RedHat ES 3 and 4, and we do backups via ontape to a tape device. I have been asked to look into how to encrypt the data on the tapes. I noticed the…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166401364.229016@bubbleator.drizzle.com... >> Tambi Dude wrote: >>> "DA Morgan" <damorgan@psoug.org> wrote in message >>> news:1166388023.574809@bubbleator.drizzle.com... >>>> How one defines quality is…
HP-UX PA-RISC/Itanium
HP claims that HP-UX maintains high degree of compatibility between PA-RISC and Itanium based system. Here is the quote from document they published on their website (http://h21007.www2.hp.com/dspp/tech/tech_TechDocumentDetailPage_IDX/1,1701,9928 ,00.html): "One of the design go…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
IDS 10 encrypting ontape
Has anyone had a chance to use TAPEDEV of STDOUT in IDS 10 and pipe it through some sort of encryption to a tape device or file? IDS 10.00.UC4, RedHat AS3 TIA. Bob Roussey robert.roussey@spiritair.com…
Re: Ontape security when shipping tapes
bozon wrote: > > Jonathan Leffler wrote: > > You can use that to avoid the >> intermediate copy to disk which they suggested. Note that when backing >> up, it is imperative to compress before you encrypt. Encrypted data is >> random looking and hence incompressible; > > Do you …
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: Database Encryption
Adam Tauno Williams wrote: > > Wondering if Informxi 10 supports any type of data encryption natively? > > If so, what are the types (column level, table level etc..) and what are > > some of the caveats assocaited with it's use? > > I know that 10.x supports column level encryp…
RE: Database Encryption
Madison, I've heard, that the encryption algorithm, implemented in IDS 10, can produce different encrypted records for same input and same key (while the decryption is able to exactly reconstruct the original key). >From this perspective, even 'equal' search on encrypted data c…
Re: Database Encryption
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.395.1151597436.19084.informix-list@iiug.org... > > Campbell, John \\(GE Cons Fin\\) said: >> Any impact to performance? > > Yes, plus it makes indexing pointless (on encrypted columns). Why?…
Re: Database Encryption
----- Original Message ----- From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: "Campbell, John (GE Cons Fin)" <John.Campbell2@ge.com> Cc: <informix-list@iiug.org> Sent: Thursday, June 29, 2006 12:19 PM Subject: RE: Database Encryption > > Campbell, John \\(GE Cons Fin\\) s…
RE: Database Encryption
> Solaris? Nope, Intel Linux. > How much data? Actually encrypted? Not a terrible amount. We use this to store customer credit card information - in order to make it encrypted on disk and and on backups. > Any impact to performance? Not even measurable do far. But then we…
RE: Database Encryption
Campbell, John \\(GE Cons Fin\\) said: > Any impact to performance? Yes, plus it makes indexing pointless (on encrypted columns). -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile…
RE: Database Encryption
Solaris? How much data? Any impact to performance? Just curious - we've considered using it if we ever upgrade to 10 - still at 9.40.FC5 on Solaris 9. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Adam Taun…
Database Encryption
Hello All, Wondering if Informxi 10 supports any type of data encryption natively? If so, what are the types (column level, table level etc..) and what are some of the caveats assocaited with it's use? Thanks for your time, Tam.…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: column level encryption
Thank you, Mark…
column level encryption
hello all, i am correct in reading that column level encryption is available in IDS version 10 but not 9.3/9.4? thanks tom…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Column level encryption - IDS 10
Because we are using block encryption algorthms with chaining. That means you can not store an encrypted number in only 4 bytes. <hariog@yahoo.com> wrote in message news:1134601844.476897.14850@f14g2000cwb.googlegroups.com... > Hi Folks, > > AFAIK column level encryption is ava…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Free space...Clustered Data
Urich Ann wrote: > Do many companies use clustering indexes...via table data ordered by a > key (clustered)? > > Is there a performance boost in Informix when the data is clustered -- > and then retrieved via cluster sequence? The performance benefit is marginal - and debatable.…
Re: IDS 10 erratic run times
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:3pliprFb403pU1@individual.net... > IDS 10.0FC3 on Solaris 2.9 > >>> This is a brand new server which we are preparing to migrate a v9 system >>> to. > Over the past few weeks I have run multiple dbimports from more-or-le…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: Update Statistics
The order I run update statistics is 1) MEDIUM DISTRIBUTIONS ONLY, 2) HIGH for first column in an index, 3) LOW for all other columns in an index, 4) UPDATE STATISTICS FOR PROCEDURE <procname> Is this still the recommended order? Regards Colin >From: "Andrew Ford" <andrewfor…
Re: Update Statistics
Yeah. I've got all of that. But is it true that running update statistics high (or medium) without the 'distributions only' clause does the work of low (building statistics) plus some extra stuff (building distributions). I've been putting a lot of work and thought into optimi…
RE: Update Statistics
Update statistics low doesn't build distributions, the way high does. It compiles information about the structure of the indices (depth, leaf nodes, clustered-ness, second-highest and second-lowest values, etc), and places them in systables, sysindexes (or sysindices, in IDS 9.4.…
Re: XPS
"Mark Townsend" <markbtownsend@comcast.net> wrote > Oracle was using three pricing metrics in those days - unlimited user > pricing based on the MHz of the CPUs, named users and concurrent user. > > In 2000 the unlimited user pricing for Oracle Standard Edititon was $15 > per MH…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: serial and sequential scan
superboer7@planet.nl (superboer) wrote in message news:<bb790a36.0502160532.2c2ac371@posting.google.com>... > where is OPTCOMPIND set to???? if 2 then set it to 0 > > or > > export OPTCOMPIND=0 > > start dbaccess with your problem qry. > > Superboer. > > > > "Bill Dare" <dareb@je…
Cool File Encryption Software Released.
You can use this software to encrypt your important files which you don't want others to see with AES encryption algorithm. Cool File Encryption adopts the international standard cryptographic algorithm--AES that has been proved to be secure by numerous attacks and tests. Cool F…
Re: serial and sequential scan
hajek@nspuh.cz wrote: UPDATE STATISTICS MEDIUM FOR TABLE... Is insufficient. Unlike HIGH and LOW, MEDIUM does NOT update the systables, syscolumns, and sysindexes records. It is the information in the latter that IDS uses to determine the cost of using a particular index. I …
Re: Has IDS 9.5 been released?
Way back when (28 October 2004, to be precise) nobody wrote: > it depends on how its being implemented. > > Just because you have a feature doesn't mean its optimal or works the > way you would want it, or is as secure as you think it is. ;-) > > Example. You have a column that y…
encryption functions
Hi I am looking for some encryption function to encrypt values stored in a column does anyone know of any esql/c function which provide this Thanks Sudhir…
Re: Has IDS 9.5 been released?
If the data is encrypted by the user (as oposed to by the system) then how could the DBMS index the data without knowing the key? Cheers Serge…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
encrypted passwords storing in IDS
We are looking to store the encrypted passwords in 7.31.FC2 and 9.21.FC3 databases. Is any third party software or Informix routine is available? Please let me know what tools you are using? Thank you, Rao Yalamanchili --------------------------------- Do you Yahoo!? New and …
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
HDR using encryption with CSM ??
I set up a HDR pair of two servers. The replication is in clear text. Is it possible to use encryption with the Informix CSM methods for this HA pair. My first test failed with : 12:25:34 HDR can not connect to <paired server> over a CSM connection…
Re: Views question?
Comments in-line. rkusenet wrote: > "Mark Townsend" <markbtownsend@comcast.net> wrote > >>Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both >>of these do have Alter Table Drop Column. So who could it be ? Lets >>think about this for awhile. Are we all thi…
Encryption of data in a column
Is there a function in Informix to encrypt a string? Specifically, I'd like to use a stored procedure to store a password on a user table. The stored procedure would receive the password, encrypt it and then store it. It would also have to be able to do the reverse. I'm hoping th…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: An interesting meeting with IBM
"Andy Kent" <andykent.bristol1095@virgin.net> wrote in message news:ac5fb36.0404080205.28a8b515@posting.google.com... > Data, > > Yes, I've worked with Oracle. > > Not sure why you ask. > I needed to get answers first before proceeding. Most of the time when people say they will…
Re: column-level encryption
Ping Tang <pingtang@us.ibm.com> wrote in message news:<c3pr8c$k9p$1@terabinaries.xmission.com>... > Thomas: > > Column-level encryption will be available in 9.50 release ( next major > release). It is????…
Re: column-level encryption
--0__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05 Content-type: multipart/alternative; Boundary="1__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05" --1__=09BBE4F3DFC97E058f9e8a93df938690918c09BBE4F3DFC97E05 Content-type: text/plain; charset=US-ASCII Content-tran…
RE: column-level encryption
Thomas J. Girsch wrote > I have a requirement to do column-level encryption in an > Informix 9.30.UC6 > database. If possible, I'd like to avoid datablades (although Stored > Procedures / Functions would be okay). In a perfect world it > would be a > fast algorithm. The encr…
column-level encryption
I have a requirement to do column-level encryption in an Informix 9.30.UC6 database. If possible, I'd like to avoid datablades (although Stored Procedures / Functions would be okay). In a perfect world it would be a fast algorithm. The encryption algorithm doesn't need to be s…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Re: Anyone seen this behaviour before ?
TBP <TheBIgPotatoe@Nospam.Nothere.Co.Uk> wrote in message news:<brn87n$vi0$1@sp15en20.hursley.ibm.com>... > mad_villan wrote: > > I have a HDR pair which were working fine up until lately. The primary > > runs in a veritas clustered environment - secondary is standalone. > > Conf…
Anyone seen this behaviour before ?
I have a HDR pair which were working fine up until lately. The primary runs in a veritas clustered environment - secondary is standalone. Configuration is fine. However, when i recently failed over to the second node in the cluster the instance came up cleanly BUT there was a con…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
non ASCII characters in text column
we have a text column and a requirement has come from a particular user that it should contain text in encrypted form. now the encrypted text will contain non ASCII characters. Is it possible for the text column to store one row in ASCII text and another row in non-ASCII text. Wi…
oncheck -me Feature Request
OK, I've collected the comments of the discussion on oncheck -me, and my own correspondence with contact, and these are the results of my investigations: 1- oncheck -me was never intended for general release 2- it was not completed internally and is not completely safe, meaning…
IDS 9.40.UC2, Encryption
I try to configure encryption with IDS 9.40.UC2 on an AIX platform and I'm a little bit confused about the different error messages I receive. Server-Platform: ---------------- AIX 5.1 IDS 9.40.UC2 Server-SQLHOSTS: ---------------- ids940 onsoctcp defx0db0 ids940 csm=(ENCCS…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Database Encryption?
Hello to All, I have been tasked to research companies that provide database encryption within the database. Data at Rest. I was hopeing someone out there is using database encryption to protect either critical customer information or sensitive company information in informix. O…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
force engine to use indexes
Because your update statistics indicate that the data is highly unordered and will result in multiple hits for the same data page. Because of that, it is mathematically faster to do a sequential scan of the data pages and sort them than it is to hit the same data pages multiple …
Encrypting Data
Hello everybody: I have a DB with very confidencial data i would like to encrypt. Do you know any Informix or third party tool for encrypting? I don't want to encrypt everything but specific fields. The scenario is: . Informix IDS 2000 . DataStage for extracting and updating…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Avoiding rebuilding of indexes
<Jinu.Joseph@citicorp.com> > We operate on a database of size 22 GB. For operational efficiency and > speed it was suggested that the indexes be dropped and recreated on a > weekly basis. Now the problem is that this takes 7 hours, and we dont > have that much time. So there are …
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
encryption or ssh
Does anyone know of a way to encrypt the requests sent to/from the database server ? Since the user name and password are sent pain text it is easily sniffed. I tried to port forward with ssh, but keep getting an error about to many files open I have bumped up the kernal param bu…
Re: Encryption...
From: "Art S. Kagel" <kagel@bloomberg.net> > >On the third hand I have not seen one yet. You must be a real handyman. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com…
Re: NUMCPUVPS
mmmmm In addtion to what the others said.... Are you running KAIO? If you are do the following echo "_ncols/D"|adb -k /stand/vmunix /dev/kmem If this going up at all be worried, if it's going up real fast be very worried. It measures the number of collisions ie the number o…
Encryption...
Does Informix 9.2 support encrypted data? Can I store encrypted data in the database, if so how does Informix handle this data? Thank you in advance…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Data Encryption
Hi all, Wanted to know if there is a way to encrypt the data on a column on the DB side? Basicly, I has a password column and what it to encrypt the values. Any ideas? Or would it just be easier to have the client encript the data before inserting to the DB? I'm running IIF v9.2…
IDS 9.20 in a Clustered Environment
Hi All, Has anybody implemented or used IDS 9.20 in a clustered environment? I would particularly like information regarding its uses as a High-Availability and Scalability Solution. Any information will be greatly appreciated. Thanks, DOn…
ODBC connectivity with EDS
Hello Admins, I having a problem connecting to my EDS environement running in a clustered environment. I have SDK (2.40 TC1) in my windows NT workstations and when I do Ilogin demo and try to connect to the EDs database I get -952 error. I have a IDS 7.31 enviroment in the sa…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
RE:
From: SAMPATH <sampath@gulfins.com.kw> > Its not RAID. Its a cluster software as series of disks will be >in a box accessed by differenct Unix servers. Thanks. I believe the technical term is "disk farm" :-) OK, as long as it's not RAID 5, you're over hurdle no 1. Now for hur…
Re:
From: SAMPATH <sampath@gulfins.com.kw> > > We're having IDS 7.3 running on Alpha 4100. All DBspaces are raw >partitions and mirrored. We are planning to move the disks out of >machine and put them as a disk array with clustering software from >Compaq. 5 disks + 1 emergency disk. …
RE:
Hi, Its not RAID. Its a cluster software as series of disks will be in a box accessed by differenct Unix servers. Thanks. Sam > -----Original Message----- > From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] > Sent: 01 June, 2000 11:44 � > To: sampath@gulfins.com.kw; informix…
Posting from the Informix-list
Hi, We're having IDS 7.3 running on Alpha 4100. All DBspaces are raw partitions and mirrored. We are planning to move the disks out of machine and put them as a disk array with clustering software from Compaq. 5 disks + 1 emergency disk. Has anyone tried this before? If one of t…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: Top Databases Used
Well it depends on all what you will be doing with your database. OLTP "based stuff" Informix, no doubt, fastest in the market at oltp with little or no headaches. Warehousing data of 1 terabyte or more, Teradata, period. Easy to manage, DBA's dream. "Stuff's not running fast…
Re: informix, linux and beowulf
Informix does NOT use that kind of clustering as is present in Beowulf. The Informix clustered product, XPS or IDS 8.xx, uses multiple co-servers in two distinct ways. 1) It can spread a database, indeed even a single table, across multiple coservers on the same or on different…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Borland Delphi and Informix
Hello everybody, we have huge performance problems on our 2-node Sun-Cluster with Informix: Environment: Sun E4500, 6 CPU's, 1GB Memory (primary host for database) Sun E3500, 4 CPU's, 1GB Memory (secondary host for takeover) 4 A5000-Diskarrays with 14 9,2GB disks each connec…
Data Encryption
Hi, We plan to encrypt the data stored in one of our databases.Also to encrypt the data in flat files and backup tapes. Our System is : Informix server : IDS with ADS Version 8.21.UD4D1 Unix OS : HP release B.11.00 HP9000/V2200 Do we need a third party tool to enable that, if s…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
IDS on NT feasability
This is an OLTP or DSS system? For a 50GB system, personally, I'd opt for some kind of UNIX. NT just chugs its heart out and as was mentioned, is more expensive the bigger it gets. Of course, you could pilot the system on both NT and a UNIX of some kind. IBM has good NT, in …
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
Password Encryption?
Hello all, How does one implement password encryption between the client and the server? Our clients are VB, RDO and Informix ODBC 3.3 (on Windows NT) and our servers are 7.3x on both SCO Unix and NT (I do not dare ask the question if it is possible to implement. I just assume …
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
A question about Indexing.
Vijith Gunawardhana wrote: > > Hi > > In my work environment we are using Informix Dynamic Server AD and XP > Options 8.2. > Seems that nobody else has taken a crack at this, so I'll have a go (and try to leave my prejudices at the door :-)). > > Here they don't use indexes at …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
RE: -710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20
We also had this problem and figured out that when we did a HPL it changed the constraints and indexes, loaded the data and then changed the constraints and indexes back to what they were defined originally. -----Original Message----- From: Art S. Kagel [SMTP:kagel@bloomberg.n…
-710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20
Jim Maus wrote: > > My multi-threaded Informix esql process received a -710 (table-name has been > dropped, altered, or renamed) error. The process was using a prepared > statement to fetch using a cursor. The source table was not dropped, > altered, or renamed. I cant reproduce…
Question on encryption
Hello, I just received a question about encryption. The question was originally based on encryption of an MS Access database, but Informix was discussed as an alternative. I'm not aware of any encryption capability built into Informix itself. I think that any encryption would…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: How to reduce SE .dat & .idx file sizes?
We're also running SE-Databases and there is only one way to downsize the dat and idx file sizes: unload, drop, load or an dbexport/dbimport. My solution for this problem is to do a weekly dbexport/dbimport in cron. If greater/more lecks in your dat / idx files, this will slow d…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
AppPage encryption
Hi , Is there anybody know how to encrypt the apppage source in informix, thanks in advance. Wing. PS please also cc to my email address wing@dbz.com…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Informix Directions
Has anyone out there been working with Informix since the late '80s? Remember how they simply dumped VMS support back then? Seth "Tim Schaefer" <tschaefe@mindspring.com> writes: >Yeah, um, but I heard that the SCO porting of Informix is over. There = >will be >no more SC…
Re: Informix Directions
Yeah, um, but I heard that the SCO porting of Informix is over. There = will be no more SCO ports, and Informix is dumping the small end. What does this do to the market, and in particular, my career path? It = goes in the dumper to stay with Informix. Apparently this is prob…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: De-fragmenting tables. Some questions
An even easier way is to use the "ALTER FRAGMENT ... INIT ... " to rebuild the taregt table wherever you want. For a big table I'd do it at odd hours with logging off so you don't get bit by a long transaction. Greg Thomas J. Girsch wrote: > > Expanding on Art's expansion on …
Re: De-fragmenting tables. Some questions
Expanding on Art's expansion on David's suggestion: A quick-and-dirty way I used to use to defragment tables was to do an ALTER TABLE NEXT SIZE to set the next extent size sufficiently high, and then do ALTER INDEX <pick-an-index> TO CLUSTER. Be warned, though, that this method…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Encryption
In article <66ovbv$7q0@cssun.mathcs.emory.edu>, Susik Lee <slee@gus.net> wrote: >If you look into iiug, you will found 4glcrypt program. That program and several others can be found in the repository file "fgl_crypt". Walt. -- Walt Hultgren Internet: walt@rmy.emory…
Re: Encryption
If you look into iiug, you will found 4glcrypt program. I used this program to encrypt some of information in a table (ex. ssn, sarary, address etc..) Within program, I check for login ID, if user has permission to view this information, I just de-crypt data before displaying on…
Encryption
Hi, I have this problem: i need to protect sensitive data in an Informix OLDS 7.13 database in a way that they can be accessible only from an application but not via direct sql queries (i can't use access control because i don't administer the system). I'm looking for some middle…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Chris Curvey wrote: > > > If you have row level locking, the first select stmt will lock one row. > > As the primary key is 4 bytes you can potentially put 4-500 keys on any > > page (if you have 2K pages). In a page lock system (like Sybase and > > MSSQL) the probability of a us…
Re: Question on Update Statistics
[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <19971107041400.XAA11881@ladder01.news.aol.com>, kponn@aol.com says... > Hi > > If I want to run update statistics on busy tables, can I do the following: > > 1. select tabn…
Re: [Q] How do I force usage of index
Daniel Williams <#danny@uk.ibm.com> wrote in article <341014AA.41C6@uk.ibm.com>... > > Is there any way I can force usage of the indexes to see if it makes any > > difference (presuming that the the query optimizer has decided not to > > use them for some reason) ? > > Have you r…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: script or spl for update statistics
In article <5ujprh$mcu@cssun.mathcs.emory.edu>, zeljan@laus.hr says... > Hi, > > in Informix Guide To SQL Syntax there is recommendation for updating > statistics: > 1) run update statistics with distributions only > 2) run update statistics high for columns with indexes > 3) run…
Re: Informix and Clustering
Nils Myklebust wrote: > > Informix and NCR have some special cooperative solutions to this used > successfully by several customers. There was even a setion on this at > the reasent user conference that your local Informix office may be > able to get information on for you. SUN, …
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Help: Reducing Extents -Reply
Just a comment about Gregs posting. I have also used fragment to rewrite a non-fragmented table in place. I have found afterwards a high likelihood of receiving 243/172 errors on such tables. This seems to be reduced if they are [de]fragmented into a different dbspace that they…
Re: Help: Reducing Extents
Chad, after increasing the NEXTSIZE in systables (don't worry too much about the first extent, it'll tend to be coalesced pretty well unless you have a lot of fragmented tables in the same dbspace). two methods not mentioned are: 1. use onunload/onload - it's waaaay faster tha…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <862264236.20961@dejanews.com>, Brenda Muller <muller.brenda@primestar.tci.com> writes: > > >plans like clustered SMP systems with fiber between the boxes, > > >or some NUMA-like MPP systems with "memory" connectivity > > >between boxes (I still don't see how that woul…
Foreign keys and indexes
We use a mixture of foreign keys and application managed referential integrity, depending on our application. I prefer application managed RI on our larger databases because it is more efficient. We have some very large tables with highly duplicate values on the child columns t…
Re: ***Bitmapped Indexing API Beta - Now Available***
Patrick Gainer <gainer@64k.com> wrote: >Deon du Plessis wrote: >> 3) THE ROUTINES OVERCOME THE PROBLEMS ASSOCIATED WITH HIGH CARDINALITY >> >> DATA. This is basically acheived by breaking the data into sections. >> If there is no data in a particular section, a BM for that secti…
Re: cluster index
I agree with Billy et al regarding the process for updating. I thought I might add that we use clustered indexes as a means of database maintenance. Every so often we will suspend use of the database, run appropriate clustered index creates, and then remove the indexes on compl…
Re: Security Vs DBA ?
Hi Richard: Why not try to save sensitive column information in encrypted form? The encryption algorithm is best known only to the HRD Manager. PS: If you want more information contact me. I'm happy to have more discussion on this. Cheers…
Re: Indexes and Stored Commands/Procedures
On 12 Sep 1996 01:49:06 GMT, sammers@pop03.ca.us.ibm.net (crunch) wrote: > >General question on indexes. > > IMHO tables (with indexes) that have high volumes of insert and >delete operations need to be re-index periodically, else 'bad' things >will happen. Please comment. Hi, W…
Re: Dataencryption for Informix
: swing@cumulus.blitz.de (Andreas Huemmer) writes: : Hello! : : Is there any posibility to encrypt the data between an Informix 7.1 : Server and a workstation on the LAN? : : All ideas welcome! OpenLink has an encryption option in their ODBC drivers that would do this. I h…
Dataencryption for Informix
Hello! Is there any posibility to encrypt the data between an Informix 7.1 Server and a workstation on the LAN? All ideas welcome! ciao…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Informix, Sybase, Oracle or MS SQL server
> : Sybase: > : Liked dealing with them but it seems that they have some serious > : problems--no row-level locking, no two-phase commit. I like their > There's another thread in here kicking around row level vs page level locking. > It pops up periodically. I have not found …
PRESS: EDS' dbINTELLECT TECHNOLOGIES & INFORMIX FORM STRATEGIC
EDS' dbINTELLECT TECHNOLOGIES AND INFORMIX SOFTWARE FORM STRATEGIC=20 RELATIONSHIP MENLO PARK, Calif. (April 8, 1996) -- Informix Software, Inc.,=20 (NASDAQ: IFMX) the leading provider of parallel processing database=20 technology, today announced that EDS dbINTELLECT(SM) (dbI)…
Re: Large table extents
Cheryl Kendricks wrote: > > Yes to question 1. Yet, if you have an index and set up query correctly > to use index it will use it. But once a table becomes highly fragmentted > either due to delete or insertions it is a good idea to unload and reload > the table. Or if you have …
Re: Large table extents
On Wed, 13 Mar 1996, Cheryl Kendricks wrote: } Yes to question 1. Yet, if you have an index and set up query correctly } to use index it will use it. But once a table becomes highly fragmentted } either due to delete or insertions it is a good idea to unload and reload } the ta…
Re: Large table extents
Yes to question 1. Yet, if you have an index and set up query correctly to use index it will use it. But once a table becomes highly fragmentted either due to delete or insertions it is a good idea to unload and reload the table. Or if you have enough space within the dbspace ju…
Re: Clustered indexes - again
} >So given these responses I am confused. Does leaving an index } >clustered effect future inserts/updates etc? } } >Robert Clark } } } > } >-------------------------------------------------------------- } >e-mail: robert@clark.netkonect.co.uk } >snail: 12 Balvernie Grove, Wan…
Re: Clustered indexes - again
On Wed, 13 Mar 1996, tolly brumbelow wrote: } robert@clark.netkonect.co.uk (Robert Clark) wrote: } } >OK, } } >I have now had a few responses to my original Q about clustered } >indexes - thanks to all of you. } } >Dan Madvig (d-madvig@bethel.edu) said: } >> If you leave it chus…
Re: Clustered indexes - again
robert@clark.netkonect.co.uk (Robert Clark) wrote: >OK, >I have now had a few responses to my original Q about clustered >indexes - thanks to all of you. >Dan Madvig (d-madvig@bethel.edu) said: >> If you leave it chustered, then every time the index changes >> the engine has t…
Secure or encrypted access over LAN
Does any one know of a secure LAN access method to INFORMIX OnLine 7.1. We want to encrypt the login and password going to the server on a LAN from a client running INFORMIX-NET. Charlie Foster Charles.H.Foster@att.com…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
performance is the least reason to choose oracle over sypbase, ingres, informix. even if sybase and oracle were the same, oracle is superior in so many ways that it defies description. consider the mass of client tools, media tools, internet tools, and the presence of "row level…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Sorry...I can't resist... To paraphrase a certain executive: "We're faster, cheaper, better. Cool. Think about it. Then buy SYBASE." >For an apples to apples comparison consider the following: > > DBMS Platform CPUs TPC-Cs Cost/Transaction > ----…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
For an apples to apples comparison consider the following: DBMS Platform CPUs TPC-Cs Cost/Transaction ------- ----------- ------- ----------- ---------------- Sybase HP T500 12 5,600+ $390 Oracle HP T500 12 5,369 $535 …
** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
REDWOOD SHORES, Calif., Oct. 27 /PRNewswire/ via First! -- Today, Oracle Corp. announced a record-breaking TPC-C open systems benchmark, 9414 tpmC, surpassing the existing performance record, also held by the Oracle7 database. Oracle7's new record is more than two times faster …
Re: Care and feeding of OnLine
Okay, I was hoping that by being vague, I would get a wider range of responses. I see now, though, that I was too vague. I'll try again to get the ball rolling. What my client-oriented customer is looking for is some simple steps they can perform to keep their OnLine da…
Re: VLDB - for real?
What is a VLDB? Used to be 10GB, now it's 100GB, soon it will be 1TB. And the Intel 8086 used to be an adequate processor for most end-user computing. It's all relative. There's probably a corallary to Moore's Law in regard to database size. About the same time that Informix ann…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Clustered Indices
In article jql@ixnews3.ix.netcom.com, tcummins@ix.netcom.com (Tim Cummins) writes: >In <3p6toh$ojl@cssun.mathcs.emory.edu> phr@fmsc.com.au (Peter Harris) >writes: >> >>I have RTFM but I am still a tad mystified, when do you use clustered >>indices and when do you avoid them? what…
Re: adjacent row delete bug
} From: kwa@mtatm.mt.att.com (K.ANDERSON(MT5756)XXXX) } [...] } We are now seeing the problem with NON-adjacent rows. I am assuming we } are banging up against another bug. } } Does anyone know a another like bug ?? } Maybe it's not a bug. Are you using the default page lock mo…
Question: The data encrypted (while using I-OnLine)
What am I to do to store the data encrypted on a hard disk while using I-OnLine ?…
Column Encryption
I need a method to take entered data (passwords), encrypt the value, and store the value in a column. Obviously, I would need to decipher the stored value for future validations. The purpose of this is to merely keep any individual from scanning the database for passwords. Any…
Re: Encryption under I4GL
In <3egsgv$sfn@mother.usf.edu> smorrow@dotrisc.cfr.usf.edu (Steve Morrow) writes: >I am interested in encrypting this PIN number. Since such a function >doesn't exist (yet) in 4GL, has anybody written such a routine, or has >anyone made use of the UNIX encrypt() call from withi…
Data deletion in Informix
In Message-Id: <3d3v5v$lkc@raffles.technet.sg> sgs@technet.sg (Alan Chen) writes: > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free logically but not > physically ?? The space is still allocated f…
Re: What affects performance?
In article <CqsC5J.H96@rosebud.strinc.com> amw@rosebud.strinc.com (Allen M. White) writes: >In article <2sk35o$80v@goshen.connected.com>, >Kurt Schmidt <slores@goshen.connected.com> wrote: >>In article <Cqq0no.9x9@boi.hp.com>, Jack Parker <jparker@boi.hp.com> wrote: >>> >>>But mo…
Re: What affects performance?
In article <2sk35o$80v@goshen.connected.com>, Kurt Schmidt <slores@goshen.connected.com> wrote: >In article <Cqq0no.9x9@boi.hp.com>, Jack Parker <jparker@boi.hp.com> wrote: >> >>But more seriously, Paul and the other posters made some very valid points. >>What the original reques…
Encryption Functions?
I need to develop an encryption/decryption mechanism for password fields that will be stored in an Informix database. Because it will be stored in a database, the task is slightly complicated by the fact that I've got a fixed length that I can output and that the password can co…
Re: What does sysindexes.clust contain?
graeme@pyra.co.uk (Graeme Sargent) writes: : Who can tell me what the numbers in the sysindexes.clust column mean? : : I realise that low numbers mean clustered and high numbers mean : unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 : acceptably low or unacceptab…
What does sysindexes.clust contain?
Who can tell me what the numbers in the sysindexes.clust column mean? I realise that low numbers mean clustered and high numbers mean unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 acceptably low or unacceptably high? If one wishes to write a utility which tro…