Oninit® Archive
Results for “onstat -g dic”
DUAL table in Oracle
Andrew Hamm wrote: > > On a not quite completely related subject, I have to ask - why the odd > choice of name? I can't think of a reason why "dual" implies the use of > this table. The table has one row and one field; where's the duality in > that? Is there another table with 2…
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 ------------------------------…
November 12 New ideas - Please vote
Hi, Please vote up the new ideas I logged for Server Enhancements https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-579 Add functionality level https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-580 Add ability to control optimizer version https://ibm-data-and-ai.ideas.ibm.com/i…
DIRECT_IO/KAIO
John: Using DIRECT_IO will indeed use KAIO! Here's the full story: When Informix accesses RAW chunks (so character devices) it uses the OS's KAIO facility by starting a KAIO thread in each CPU VP to handle all IO to/from those RAW chunks. By default, when Informix accesses chunks…
how to manage comments for tables and columns?
Some use ERD systems others create their own data dictionaries. I built one years ago for the firm I was working at in 4GL. Still have that code I think. Art ------Original Message------ Hi All, The customer asked how to use the comment function to describe tables and columns in …
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…
memory monitor
Original post: HI, I use informix version 12.10, How to monitor below memory through SMI? dictionary cache; table statistics cache; ...... thanks for your time. Lu chuan Response: Well first off, when you say "table statistics cache" I'm assuming you mean the cache the s…
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…
shmmax syntax in onconfig file
SA here that needs to set the shared memory for Informix. I am not worried about performance at this point, just need to be able to get the informix server to start. The onconfig file syntax is a bit odd. All I want to set is approximately 4gb of shared memory. "WARNING: server…
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.…
error initializing 11.70.FC9
>> What output would 'oninit -ivy' produce, would it also fail 'initializing >> dictionary and UDR caches'? When I run 'oninit -ivy', I get the following output: /test_ifmx/IDS11.70.FC9 1708> oninit -ivy 11476 Reading configuration file '/test_ifmx/IDS11.70.FC9/etc/onconfig.tes…
SPL procid=0?
Just a brief summary of the Tech Support case. Tech Support did not have access to an instance of Solaris IDS 12.10FC3. They did have access to the IDS source code. They examined it, but could not explain the observed behavior. The bottom line is that they suggested we upgrade …
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…
Full memory even if I set SHMTOTAL
Hello. It seems you are using vp memory cache without the "static" word, after the cache size. Try setting that. A second good practice is to schedule an onmode -F with a good period of execution, according to your memory fill rate. There are some kinds of problems in shared m…
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)…
shared memory issue
You should always post your platform and Informix version details so you don't have to wade through version specific answers that do not apply to you. Here's mine for you: If you are running any later v11.50, any 11.70, or v12.10 earlier than 12.10.xC5W1 there are at least three…
Data Dictionary
Do you know of a good Data Dictionary software package? Or, if you know a format that works well for you, and don't mind sharing, that would be useful as well. Thanks, Steve…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
DB Tuning question
Hi Art, This is the updated configuration: I have changed SHMADD and SHMVIRTUALSIZE from 20000 to 100000. LRUS is still 16. LOCKS 300000 # Maximum number of locks #BUFFERS 150000 # Maximum number of shared buffers BUFFERS 50000 # Max number of shared buf NUMAIOVPS 1 # Number of…
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,…
Compression
IDS 11.70.fc3 Aix 6.1 I have a table that is currently 2.3B rows. The table is fragmented over 39 partitions in 13 dbspaces. I want to compress the table in order to get an idea of the savings we would get from doing this. When I tried running the compress function I got an erro…
Moving IDS to a new host
If you have RESIDENT set to a non-zero value in the ONCONFIG file, try setting it to zero. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do …
Re: Someone have a technique to alter tables with FK ?
JP: The original poster is not using any stored procedures. This is independent SQL statements. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions a…
Re: Someone have a technique to alter tables with FK ?
Hi Marco, Thank you for your answer. My big problem is not able to reproduce this behave. I try sometimes and every time just works... On the last 12 months , we already suffer with this problem at least 6 times. The last time was one week ago. I have pretty sure at least 3 t…
Re: Someone have a technique to alter tables with FK ?
On 02/05/12 14:37, Cesar Inacio Martins wrote: > Hi, > > 11.50 FC9X6 , AIX 6.1 > > We suffer with one situation at our production where just not found a > acceptable way to work yet... > I already open a PMR (for me this is a defect) but for IBM support is just > "work as design"…
Re: Someone have a technique to alter tables with
If the AUTO_REPREPARE is not solving the situation, then you will have to recode your applications to handle the error by repreparing etc. All of the application and middleware code I wrote at Bloomberg years ago was coded to do that because prior to version 11.10 this was a much…
Re: Someone have a technique to alter tables with FK ?
Hi Art. The database always have the AUTO_REPREPARE active. onstat -c |grep ^AUTO_RE AUTO_REPREPARE 1 But we don't try force it thru user environment AUTO_REPREPARE=1 ... should ? No Stored procedures are used at this situation, any way we was tried update statistics for proced…
Re: Someone have a technique to alter tables with
Prior to 11.50 you could only handle this in your code by adding a test in your applications after the execution of a prepared statement or the opening of a cursor against a prepared statement so that if the operation returns SQLCODE == -710 then reprepare the statement and reexe…
Re: Someone have a technique to alter tables with FK ?
Prior to 11.50 you could only handle this in your code by adding a test in your applications after the execution of a prepared statement or the opening of a cursor against a prepared statement so that if the operation returns SQLCODE == -710 then reprepare the statement and reexe…
Someone have a technique to alter tables with FK ?
Hi, 11.50 FC9X6 , AIX 6.1 We suffer with one situation at our production where just not found a acceptable way to work yet... I already open a PMR (for me this is a defect) but for IBM support is just "work as design" .... so, no solution... Just a correction / better documenta…
Someone have a technique to alter tables with FK ?
Hi, 11.50 FC9X6 , AIX 6.1 We suffer with one situation at our production where just not found a acceptable way to work yet... I already open a PMR (for me this is a defect) but for IBM support is just "work as design" .... so, no solution... Just a correction / better documenta…
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 …
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
The memory you specify in SHMTOTAL and SHMVIRTSIZE is specified in KBytes. The memory shown in onstat -g seg in in bytes Informix ideally will not stop when you reach SHMTOTAL, but it's hard to handle low memory conditions (sometimes to rollback you need more memory for example)…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Are you saying I should have SHMTOTAL 6442450944 ? Will the IDS stop if memory exceeds that number? From: Fernando Nunes Sent: Wednesday, September 21, 2011 5:12 AM To: Bill Hamilton Cc: informix-list@iiug.org Subject: Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE It …
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
It should not even start... You're saying that the memory limit is inferior to the initial memory allocation! It would be interesting to see the online.log of the instance... Regards On Tue, Sep 20, 2011 at 6:06 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > Many Thanks.…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Many Thanks. We will see if that helps. I now have this in the config ... RESIDENT -1 SHMBASE 0xc000000L SHMVIRTSIZE 130624 SHMADD 26124 EXTSHMADD 26124 SHMTOTAL 6144 SHMVIRT_ALLOCSEG 0,3 Will the IDS stop if memory exceeds 6144kb ? From: Alexandre Marini Sent: Tuesday, Septem…
Performance Issues
just post the output of onstat -g dic. Also the onconfig file for the primary. From: "VIKAS HIVARKAR" <vikas.hivarkar@gmail.com> To: ids@iiug.org Date: 08/01/2011 12:13 AM Subject: Re: Performance Issues [24484] Sent by: ids-bounces@iiug.org Hello All, Yes was have an HDR …
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…
What is virtual about Informix "virtual segment of shared memory"?
The "Virtual" designation is an internal Informix term referring to the internal management of memory that can be transient and shared between multiple oninit processes and user sessions. Basically it contains all of the server's in-memory data structures except the buffer cache…
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…
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.…
switch from block to raw, & modify HP-UX bufcache
Hi everybody, Informix Dynamic Server Version 11.70.FC1GE on HP-UX v11.11 (Risc) I am not a HP-UX admin, and it's been a long time since I've dealt with an Informix engine on block devices (I inherited, I didn't build it). I am seeking advice on whether my improvement plan bel…
Re: Too many open files - Isam error 104
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On > Behalf Of jrenaut > Sent: Tuesday, May 17, 2011 2:57 PM > To: informix-list@iiug.org > Subject: Re: Too many open files - Isam error 104 > > On May 11, 6:04 am, "Habic…
Instance Crashed !!
The resident segment is mostly the buffer cache, so that determines its size. The virtual segments contain the smaller caches like the dictionary cache etc. And working memory for sessions to use. There is no ratio between the two. Art On Jan 21, 2011 11:12 AM, "SHAHZAD SALAM KA…
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…
ONSTAT -G DIC
Hi Everyone, First thing. IDS 9.4. My customer told me that the last line of onstat -g dic output is showing a big value of Total number of dictionary entries: Is almost 99.000 Question: Is that bad? How can I know if it's bad? And if it is, how can I set DD_HASHSIZE and DD_HA…
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…
sysmaster:sysusers and sequential scans
On 8 June, 18:39, Keith Simmons <smile...@googlemail.com> wrote: > To occupy a few minds tonight :-) > > I've been investigating some highish sequential scan figures (1.4 > million in 8 hours). I know they are not bad in themselves but just > wanted to see if there were any large…
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…
Re: Linux LVM snapshot
Andrew Ford schrieb: >> BTW, being a SAN admin/UNIX sysadmin/RDBMSes DBA all at once, I wonder >> what's it like to be a DBA unaware of how are your database chunks >> stored. Is it easier not to worry about underlying server/SAN stuff or >> one worries even more since he/she has…
create index online
Hi all, I created a new index ONLINE. Thought that would cause no problems in production. However, one program reported errors: > Program stopped at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > 464. > Date: 04.11.2009 Time: 18:51:54 > > Program error at "/home/pr…
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…
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…
Lots of writes in sysprocplans, why?
On Aug 3, 2:44 pm, Omar Muñoz <omar...@yahoo.com> wrote: > Hi. > > While I was studying contention on disk issues, I realized that my sysprocplan has a lot of write activity - in fact, it's the most written table, according to sysptprof; the next one is a batch-used table whi…
Configuring 2nd informix instance on the same serv
In my setup, SERVERNUM is unique and a new dbspace is created on that ROOTPATH. And correct ROOTPATH parameter is mentioned in onconfig file. I tried with "oninit -iv" option also. This time also i am getting the same errors in online.log file. # oninit -iv This action will in…
Data Compression
Hi, When we compress any table, where we can find the Compression Dictionary ? Can it be viewed in any data dictionary ? As we need to make sure that Compression Dictionary is available, in case of any failure.…
IO problems and perf
If nothing else is running on the box then RESIDENT is irrelevant. Setting RESIDENT to 1 prevents the 'resident' shared memory segment (which contains the buffer cache and header structures for controlling shared memory) from being swapped out by other processes - you can also se…
ISAM reads of system catalog tables
On 5 jun, 14:08, TheBigPota...@Nothere.Co.Uk wrote: > On Jun 5, 4:46 pm, Art Kagel <art.ka...@gmail.com> wrote: > > > > > System catalog tables should not be read frequently at all, either from disk > > or from the cache. It looks like your data dictionary cache is mis-sized. > …
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…
IDS hangs; IBM diagnoses resident memory problem
"Eric Rowell" <erowell@gmail.com> wrote in message news:mailman.143.1232031123.1831.informix-list@iiug.org... Never had an issue with " RESIDENT " but then again currently we are not using it. Too many things sharing the server. Are you sure you aren't running into a memory lea…
9905 error with varchar in a multiset
sounds like an occasion of an oldie: 130885 9628 TYPE NOT FOUND USING SPL WHEN ROUTINE/EXT TYPE CACHE IS HAMMERED ERROR IS STORED IN SYSPROCPLAN up the values for PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX, PC_HASHSIZE,DS_HASHSIZE etc. Superboer. On…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
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…
oninit:Fatal error in shared memory creation
Hi all, I have installes IDS 9.3 on a suse 8 enterprise box. The database is not starting and i am getting the following error message: "oninit: Fatal error in shared memory creation. The oninit -ivy and the online log are as follows; oninit -ivy ------------ login as: informix…
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…
CPU VPs
To scale for anticipated traffic we increased number of CPU Vps from 15 to 25. Along with that we changed the affinity also. We were expecting increase in performance but it actually degraded the performance. Since then we have tried adjusting PC_HASHSIZE/POOL, DS_HASHSIZE/POOL, …
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.…
Parameter tuning?
Pls see the instance profile and shared memory parameters below. The problems I noticed are 1. low read-cache-hit 35% 2. low write-cache-hit 79% 3. a lots of bufwaits and seqscans What do you advice? Informix Dynamic Server Version 7.31.UD3 -- On-Line -- Up 158 days 02:30:01 --…
3 parameter/onstat questions
I just got off the chat-with-labs with John Miller. He left me with 3 questions I am hoping to get more info about, having failed to get anything useful from the version 10 docs. I'm on ids10.0.fc5. 1) He strongly recommended having the chunk mode set to expanded 'always'. He sa…
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: long time to wait until "dbaccess - Database - Select" answers
On 9 Nov, 11:39, "Keith Simmons" <smile...@googlemail.com> wrote: > On 09/11/2007, wjb <w.beh...@uni-bonn.de> wrote: > > > > > On 9 Nov., 09:59, "Keith Simmons" <smile...@googlemail.com> wrote: > > > On 08/11/2007, bozon <cur...@crowson1.com> wrote: > > > > > On Nov 8, 7:49 am, w…
Re: long time to wait until "dbaccess - Database - Select" answers
On Nov 8, 7:49 am, wjb <w.beh...@uni-bonn.de> wrote: > Hello, > > dbaccess - Database - Select > takes about 30 ... 45 seconds to list all 8 databases. > > After selecting a database it takes the same time to > show the info or the missing connect permission. > > The same behavio…
windows-1252?Q52=65=3A=48=65=6C=70=20=66=69=6E=64=
select tabname from systables as st left outer join sysconstraints as sc on st.tabid = sc.tabid and st.tabid >= 100 {No system catalog tables} and sc.constrtype = 'P' WHERE sc.constrid is NULL; Art S. Kagel ----- Original Message ----- From: Jonathan Smaby <ids@iiug.org> To: id…
Help finding tables without Primary Keys
Good morning, I have IDS 10.00.FC5 under HPUX 11.23. If there is a way to query sysmaste= r / data-dictionary to identify tables that don=B9t have a Primary Key, I would be eternally grateful for any assistance. Merci =E0 l'avance Jonathan B. Smaby DBSA Pomona College, ITS-AIS…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 15, 6:49 pm, Mark Jamison <maj...@yahoo.com> wrote: > Actually I believe the confusion is betwen the DS cache values with the DD cache variables. > > DD_HASHSIZE and DD_HASHMAX mean something else. DD_HASHSIZE is the number of buckets or lists, and DD_HASHMAX is the numb…
upscol & syscolval
On Oct 3, 7:27 am, Cats <ramwa...@uk2.net> wrote: > Hi > > I have a database with a lot of new tables, and setting up COMMENTS > entries via upscol is tedious in the extreme. I thought it would be > possible to simply INSERT rows into syscolval but that didn't seem to > work for…
Problem in initialization of IDS.9.40.UC1
I have IDS9.40.UC1 on linux. I was trying to bring up the server using oninit command. The below is the output of oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/software/ids/etc/onconfig'...succeeded Creating /INFORMIXTMP/.…
Re: Strange behaviour of the buffer pool
Looking at a larger instance on the same versions I can see the "resident" pool being 354MB while the "res-buff" being the same the BUFFERS setting: onstat -g mem|grep " R " res-buff R c00000001669d040 1280004096 2848 2 2 resident R c000000000491040 …
Using STMT_CACHE
Hi These are the advantages of using SQL Statement Cache feature. 1)Reduced memory consumption because query data structures are shared among different users. 2)Faster query processing time because for statements present in the cache, the database server can skip parsing and opti…
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.…
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…
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…
Question about Linux VM tuning for IDS
Rob, To answer your question... Memory Residency is an OS thing. Informix has a flag/switch that if set, it will attempt to perform memory residency *if* and I mean *iff* the underlying OS does support this feature. Going from memory... mlock() is the c function which will lock…
problems of inicializacion
Juan Pablo wrote: > Hi: Hi: Did you install the C4GL after IDS? If so reinstall the IDS software. Art S. Kagel > At the time of initializing my IDS it leaves the following message to me > error: > > Initializing Dictionary Cache and Stored Procedure Cache...Cannot find > mes…
Re: DD_HASHSIZE , DD_HASHMAX
Well it's been a while since I used v7, but it looks like a couple of columns are missing. However given the header for an onstat -g dic list# size refcnt dirty? heapptr table name I'm going to presume the first colum in your example is actually the refcnt. In tha…
Re: DD_HASHSIZE , DD_HASHMAX
Mark, the table xxacct is cached moer than once in this extract. Thanks 426 yes 95e02820 xxx@xxxshm:xxxx.xxacct 147 yes 9f220680 xxx@xxxshm:xxxx.xxacct 12 yes b0df9820 xxx@xxxshm:xxxx.xxcattr 1 yes ce4e2020 xxx@xxxshm:xxxx.xxpecl 9 y…
Re: DD_HASHSIZE , DD_HASHMAX
Could you shoot a small portion of the onstat -g dic output where you are seeing duplicates? Thanks much ----- Original Message ---- From: "tichman@excite.com" <tichman@excite.com> To: informix-list@iiug.org Sent: Tuesday, January 16, 2007 10:02:21 AM Subject: Re: DD_HASHSIZE ,…
Re: DD_HASHSIZE , DD_HASHMAX
A few questions. #1 How many Databases do you have in the instance. #2 Do you perform any remote queries to other instances from the instance. #3 How long has the instance been up. Multiple copies of the same table usually indicates that you have multiple versions of the tabl…
DD_HASHSIZE , DD_HASHMAX
We are running 7.31.UD3 on Solaris 5.9.I am investigating the optimal setting DD_HASHSIZE and DD_HASHMAX. Currenlty they are set at the default (31 and 10).We have approximately 430 tables in the database but when we run onstat -g dic I get 2400 data dictionary entries which seem…
sysptprof
Floyd Wellershaus wrote: > I am writing some benchmark scripts to keep track of chunk and table IO. > According to the manual, the following is true about sysmaster:sysptprof > > > The *sysptprof* table lists information about a tblspace. Tblspaces > correspond to tables. > > Pro…
sysXXXX XX tables
You cannot. Not to worry though, all that information is cached so as long as your caches are sized correctely the engine will rarely go to disk for catalog information and the fragmentation is irrelevant. Art S. Kagel ----- Original Message ----- From: Frank Lai <ids@iiug.org> …
Re: DD_HASHSIZE/MAX on a Baan installation with more than 100,
thank you for clarifying Art, I wasn't trying to misrepresent what you wrote. I just made the assumption (wrong, wrong, wrong) that the last line of onstat -g dic was the target for sizing cache rather than using that number as a starting point.…
Re: DD_HASHSIZE/MAX on a Baan installation with more than 100, 000 tables.
Hi Rob, there is very little overhead for DD entries over all , let me see if I can dig up my rough sizing calculations. The base overhead for the Data Dictionary Cache is as follows: X1 = 24 + (40 * DD_HASHSIZE) Below is the minimum cost of every Data Dictionary entry: Y1 =…
Re: DD_HASHSIZE/MAX on a Baan installation with more than 100,
mjldba wrote: > Not familiar with Baan installation but we deal with PeopleSoft which is > almost as big & bloated at 55K+ tables. > > I use DD_HASHSIZE of 677 (this should be a prime number) and DD_HASHMAX of > 10 & I arrived at my setting of 677 by using onstat -g dic | grep di…
DD_HASHSIZE/MAX on a Baan installation with more than 100,000 tables.
Not familiar with Baan installation but we deal with PeopleSoft which is almost as big & bloated at 55K+ tables. I use DD_HASHSIZE of 677 (this should be a prime number) and DD_HASHMAX of 10 & I arrived at my setting of 677 by using onstat -g dic | grep dic, grepping dic just to…
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…
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…
Update statistics and shared memory
So, a strange leap takes me to... how about if the update stats process messes up all the pages you've been happily cacheing all day, and then when the real work starts again you've loads of pages that you need to 'purge' before it can get going...?? You could maybe get a handle…
IDS 9.4 - startup problem
Hi, I'm receiving this error when I try to startup an instance "Initializing Dictionary Cache and SPL Routine Cache...Cannot find message file. Check INFORMIXDIR and DBLANG.FAILED" AIX 5.3 IDS 9.40.FC8 INFORMIXTERM=terminfo INFORMIXDIR=/informix/product/9.40 INFORMIXSERVER=tso …
Re: Permissions on a View
I have seen instances where the permissions on the remote table where cached and the only way to resolve the issues was to clear/flush the dictionary cache either by flooding the local engine with queries against every table in the system or by bouncing the engine. ----- Origina…
Informix instances with large number of tables and databases
bozon wrote: > So are you saying it doesn't run well. > > Obnoxio The Clown wrote: >> bozon said: >>> We are doing a proof of concept. In it we want to create a database for >>> each of our 2000+ customers. In each database we will have about 300 >>> tables and about 800 indexes.…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
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/…
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!…
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
Re: Really Frustrating -9628 Errors
Sounds like a bug i've seen before but 'should' have been fixed??? ... update stats will work but it only for xx hours and someother may fail. phone TS and have them look in their bugdb. wa afaicr is cranking up spl cache params PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX…
Optimizing a BaaN installation
Query sysmaster:syscfgtab (sysmaster:sysconfig is a view that hides undocumented paramaters)! There are DS_ parameters (?? Data dictionary caching). DD_ parameters (?? Data distribution caching) PC_ parameters (SPL caching) Check the IDS 10 manuals they document this stuff …
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.…
Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
Hi. I hace a problem trying to initialize the rootdbs in the creation of a new instance. I type: informix@BO:/informix/sq/dev$ /informix/bin/onspaces -c -d rootdbs -p s1_rootdbs -o 0 -s 2097151 And appears the error: shared memory not initialized for INFORMIXSERVER 's1' -Doe…
Re: oninit: Dictionary Cache and SPL Routine Cache error
RESOLUTION (sort of): There was some interaction with 4GL, possibly the media was bad, possibly the installation order. The db is now up and running as expected.…
Re: oninit: Dictionary Cache and SPL Routine Cache error
Hi Jef. Just a thought. I think truss -f -o file oninit -v is your help. -f option means -f Follows all children created by fork() or vfork() and includes their signals, faults, and system calls in the trace output. Normally, only the first-lev…
Re: oninit: Dictionary Cache and SPL Routine Cache error
I think that you are right about the message files getting overwritten if things are installed out of order. But, I installed in this order 4GL RT, 4GL Dev, IDS, Client SDK. This has worked for me in the past. I don't think that the missing message file is the problem. I thi…
Re: oninit: Dictionary Cache and SPL Routine Cache error
Looks like it is forking at the end and dying. ------- open64("/dbms/informix/etc/.infos.demo_on", O_RDWR) = 0 fcntl(0, F_SETLK64, 0xFFBD6D70) = 0 read(0, "\\007\\0\\0\\00201\\b\\0\\0\\0\\0".., 264) = 264 read(0, "\\001\\0\\0\\0\\0\\0\\0 R V H01".., 264) …
RE: oninit: Dictionary Cache and SPL Routine Cache error
Jef Have you installed any tools (4GL or ISQL) In the same directory? I have seen a similar error when the Tools were installed after the IDS and not before. Keith -> -----Original Message----- -> From: Jonathan Leffler [mailto:jleffler@earthlink.net] -> Sent: Monday, October …
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
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: Re: oninit error .. [5496]
$ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informix/etc/onconfig.padbv2'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/opt/informix/etc/.infos.padbv2" ... "/opt/informix/etc/.co …
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: Raw vs. Cooked files
Martin Fuerderer wrote: > Hi, I emailed a simple response yesterday, but the link seems to be lost. Here's another more detailed one: It does not matter HOW much memory the OS has for a buffer cache. There are still several reasons why RAW will ALWAYS be faster than COOKED dev…
HELP ME WITH THE FAQ....Please review
I've just finished adding all the FAQ Updates I have and fixing my email address everywhere (thanks June Hunt!). http://smooth1.my-bulldog.com/pages/smooth1_my-bulldog_com/ifaq/informix.htm Questions 1. Can someone review "How do I setup Enterprise Replication (ER)?" http://s…
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…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Reading co…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Readin…
strange behavior in 9.40.FC6
"Bill Dare" <dareb@jevic.com> wrote in message news:1115154586.41877d638e6a36c3447a085ec262c671@teranews... > > I've actually got a patch loaded, 9.40.FC6X2. The server is randomly > allocating multiple scan and sometimes group threads to sessions for no > apparent reason. Onst…
Re: connect to database error
and I reset oninit -ivy failed ,it execut process message : Checking group membership to determine server run modesucceeded Reading configuration file '/home/informix/etc/onconfig.std'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/home/informi…
connect to database error
and I reset oninit -ivy failed ,it execut process message : Checking group membership to determine server run modesucceeded Reading configuration file '/home/informix/etc/onconfig.std'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/home/informi…
Update statistics
Tilman Mode.... wrote: > There is a way to drop distributions without running 'update statistics > low' > > You may use the SQL command: > > DELETE FROM sysdistrib > WHERE tabid = > (SELECT tabid FROM systables > WHERE tabname = '<the_table_in_question>'); > > Disadvantage of thi…
Re: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I have DD_HASHSIZE=997 and DD_HASHMAX=27, these numbers were arrived at by running a script I downloaded from the s/w repository for calculating DD_HASHSIZE and DD_HASHMAX values. I have just rerun it and for a HASHSIZE value of 997 HASHMAX should be a minimum of 40. I'll check t…
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: Memory resident tables
Gustavo Tobares wrote: > This message is in MIME format. Since your mail reader does not understand PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last…
BAD PAGE
Hi Jairo, RUN ONCHECK -cD Also run check (before the backup): CheckReserved (Reserved Pages) CheckCatalog (Data-Dictionary) CheckExtents (Extents) CheckSmart (Smart-Blobs) CheckData (Data-Pages) CheckIndex (Index-Pages) ArChecker (Backups) -----Original Message----- Fro…
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: Informix Tuning Problem
Andy Leung wrote: > My server run very slow for this few weeks.. I've checked the %cache go 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92 97670 146260 …
Re: Informix Tuning Problem
UPDATE STATISTICS? Andy Leung said: > My server run very slow for this few weeks.. I've checked the %cache go > 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92…
Informix Tuning Problem
My server run very slow for this few weeks.. I've checked the %cache go 99%.. Hardware : IBM - H80 , 4 CPU , 2G Ram , HD x 2 dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 25899 119543 30538756 99.92 97670 146260 2077545 95.30 ONCONFIG : - …
problems of Inztallation's
Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via onmonitor .... the error is: shared memory not initialized for INFORMIXSERVER 'crazy_tcp If i want to inicialize vi command ..... the err…
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…
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…
cannot initialize root dbspace
$ 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 server run modesucceeded Reading configuration file '/informix/etc/on…
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…
Re: Writing to disk or server cache?
Andris wrote: > Thanks, onmode -B indeed seems to be the solution for long > checkpoints, have to test it on IDS 9.21 yet. > > Anyway, another question remains - how to force IDS to use or not to > use cache memory? What do you mean by cache memory? Informix's shared memory? T…
Informix IDS problem
Hi All, When I try to start the IDS 9.40 on HP PA-RISC machine, I get the following error. If I reinstall the IDS it works properly. If I shut down & restart the database it fails with the below message.. Checking group membership to determine server run modesucceeded Reading …
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: [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: Informix to Oracle migration
A detailed data dictionary of the schema. Would be a good thing to have.…
Shared memory and SELECT-Performance
On Mon, 01 Mar 2004 05:07:19 -0500, Markus Bschorer wrote: Increase the size of the buffer cache (BUFFERS onconfig file parameter) so that more data is kept resident. The fact that after a few minutes the data need to be reloaded is a clear indicator that the cache is too small…
Re: Informix Performance
--0-770701732-1077895028=:2607 Content-Type: text/plain; charset=us-ascii Daniel, Here are the answers by the topic number that u are having problems with. 1. The raw devices is the best because the IO is faster on raw devices. Have your sysadmin create rawdevices for you. …
Re: Informix Performance
--0-760546962-1077844301=:67157 Content-Type: text/plain; charset=us-ascii You seem to have many misconfigurations on your Informix server !!! Start investigating the following areas ! 1. Why are u using cooked files ? 2. How does your onstat -g seg looks like when the slow …
RE: 9.40 vs 9.21 performance
--0-36354248-1077737147=:94325 Content-Type: text/plain; charset=us-ascii Collin, Here are some things to test and trial : 1. Why are u grabbing one million locks at the time of the engine start ? Each lock consumes about 4k of memory from OS side I believe. 2. Please incre…
Problems running 9.40.UC3 on RedHat 8
I am having trouble creating an instance of Informix on RedHat 8. I have read all the problems people have been having running on RedHat 9 so we decided to try RedHat 8. We have also upgraded the glibc to glibc-2.3.2-4.80.8.i686. This was suppose to fix the problem with the TC…
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…
RES: ER performance
I would say that my systems reborn with that change. Both the overload and the performance issues simply disappeared. Thank you very much. By the way, this kind of information sharing, for me, is one of greater differentials between Informix and the other databases. Julio ---…
RES: ER performance
Are you working with tech support on this problem? If so, then do you have a case number? I can check into the case notes and advise the support engineer how to proceed. I'm really a bit uncomfortable making tuning advise without seeing the diagnostics of the engine. I'd like …
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.…
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…
9.40.UC2 Startup on RedHat 9
I'm trying to initialise a database instance of IDS 9.40.UC2 on RedHat 9 (kernel 2.4.21, glibc-2.3.2-11.9.i686) However, when I run the oninit -iv command I get as far as the message "Bringing up the ADM VP..." and that's it. No further messages. The following is the exact output…
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.…
Threads waiting on buffers
Those of us running SAP have between 10,000 and 12,000 (yeah, the comma and zeroes are correct) tables defined in the database. Hard to know how many of those tables actually get used in any specific system. Using an 80/20 thing, we probably have at least 2,000 active tables but …
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…
Re: Informix under Linux - real crap !
I have tested only 9.30 UC2 on SuSE 8.1 (equals SLES 8). Definitly does not run. I think, we change to the newest 9.30 UC6 or 9.40 (to come out soon, according to informix support) , which is supposed to have those glibc 2.3 incompatibilities in RedHat 9.0 corrected. 2.4.19 - 64G…
problems with oninit
hi, I installed IDS 9.40 on a Suse 8.0. After correct installation the oninit -iv command results the output: Checking group membership to determine server run modesucceeded Reading configuration file '/home/informix/ids/etc/onconfig.ids'...succeeded Creating /INFORMIXTMP/.infx…
cached tables
Let me add some points to Jonathon's comments here... If those tables are very active (massively hit), then they MAY stay in memory, or the buffer cache in particular. But this depends heavily on the size of the buffer cache. If the cache (BUFFERS) is too small, then these pages…
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…
oninit: Fatal error in shared memory creation
What messages do you get in the online log? Regards Colin Dawson >What is the problem when your shared memory is not allocating and attatching? > >This is what I get >############################################## >$ oninit -iyv >Checking group membership to determine server …
Re: Multiple DBs vs Multiple instances
----- Original Message ----- From: Terrence Mu.... <terrence@wagerworks.com> At: 3/13 14:23 > What are the pros/cons of have multiple databases in one instance > as opposed to having multiple instances with just one database. For multiple databases: Makes better use of system r…
Re: undocumented parameters
----- Original Message ----- From: Ricardo Manzo <Ricardo.Manzo@cosan.com.br> At: 3/12 16:20 > Hi all , > > Does anybody know the meaning about the parameters below and how does it affect > performance ? Yes... > DD_HASHSIZE Not to forget: DD_HASHMAX The above control the siz…
undocumented parameters
Ricardo; These are paired hidden parameters that tune the sizes of the data dictionary cache (DD_HASHMAX, DD_HASHSIZE); the data distribution cache, (DS_HASHSIZE, DS_POOLSIZE); and the stored procedure cache (PC_HASHSIZE, PC_POOLSIZE). These parameters are documented in the Per…
Re.systables.
Isn't it better to make sure that all the tables you routinely refer to remain in the dictionary cache, than to get too worried about extent sizes for systables & syscolumns. Or do I misunderstand what the dictionary cache is there for? Best regards, Andy. <.. snip ..> -- And…
Re: Permission Problem in View
--0-1769910248-1043256634=:29988 Content-Type: text/plain; charset=us-ascii The first time a view is selected from information on the remote tables that are used in that view are stored in the dictionary cache, as best we can tell. Since this info is cached, any changes made to …
Redbrick
----- Original Message ----- To: malcolmw@fast24.co.uk At: 3/26 8:29 Several commercial applications, notably SAP and PeopleSoft, have 10,000-30,000 tables, that's the main reason. Also there are instances, like our development servers here, where you may have over 100 databases…
Re: number of extents
David Williams wrote in message ... >In article <3a77a94b$1@news.iprimus.com.au>, Andrew Hamm ><ahamm@sanderson.net.au> writes >>Informix have written somewhere that no more than 8 is ideal because the >>extent pointers can all fit on one page in the system data for the table. >>…
Dictionary Cache
We have a second virtual memory segment which we would like to free up. No users are currently using this segment but we do have 11 tables out of 773 using in for Dictionary Caching. Is there a way of either removing these tables from the Dictionary Cache or rehashing them to try…
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…
Generate Data Models From SQL
WinTranslator Adds SQL Reengineering Generate Data Models From SQL For Popular RDBMS Products Excel Software extended the reengineering capabilities of WinTranslator to generate WinA&D data models from SQL code. Database designers can quickly generate logical and physical data …
Extents management
NO! The SMI tables are NOT tables, they are pseudo-tables and are really just windows in to the engines disk and shared memory structures. NO NOT MUCK WITH THEM. On the other hand if you mean the system catalog tables, like the ones you mention, which are existent in every dat…
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 …
Re: What are DD_HASHSIZE and DD_HASHMAX? How are they tuned?
Art. I only have one question more. These parameters apply to IDS 7.31 El Fri, 29 Sep 2000, Art S. Kagel escribi�: > Francisco Huezo wrote: > > > > Hi. > > > > The true is these couple of parameter are new for me. > > DD_HASHSIZE and DD_HASHMAX. > > > I looked up the Administr…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
What are DD_HASHSIZE and DD_HASHMAX? How are they tuned?
Hi. The true is these couple of parameter are new for me. DD_HASHSIZE and DD_HASHMAX. I looked up the Administrator's and Performace guide for IDS 7.31 and i can't find anything about them. In the forum, I learned something but i think is not enough, so far I guess they allow…
extents and system tables
adiosadios wrote: > > Hello! My cursory check of TFM turned up nothing so I am turning to all of > you. > > Our production db has several system tables that are approaching the 30 > extent range. I'd like to bring this down to a reasonable size (if it > useful). DON'T!!!!!! >…
Re: Tuning advice.
Madison Pruet wrote: > > Well, you do need more buffers. Generally the read cache rate needs to be > pretty close to 99%. You might be able to reduce your checkpoint times even > more by setting LRU_MAX_DIRTY to 2. > > You also have skewed usage of the chunks. From your sample…
Re: Tuning advice.
Yeh, I know about ol_ch_mars_a, Oh for more disk, or some free weekends to attempt a re-org! Looking at the onstat -g dic most lists are full but with unreferenced tables, I'll try upping this! I'll try the LRU_MAX_DIRTY 2 as well, doesn't this tend to reduce cached writes? I'…
RE: oninit Failure
What Informix version are you running? I.E. What is the output of "oninit -V"? What environment variable settings did you export prior to issuing the oninit command? Please post the output of "oninit -V" and "env" to the News Group. Your INFORMIXDIR environment variable may not…
Re: Why is rootdbs busy?
Nice script, but I'm afraid that there are some problems. 1) This does not calculate the hash value correctly. The hashing algorithm includes the char value of the name, the position of the character, and the number of hash buckets (DD_HASHSIZE). 2) Unless the sysxxx tables in …
Fwd: FW: Why is rootdbs busy?
Based on your system load and number of buffers defined you might be suffering from statistics lookups. Try enabling Data Distribution Cache. My database system tables are in a separate DBspace and I reduced the I/O by 50% using the DDC. Mileage may vary, I have 30,000 tables …
Re: Why is rootdbs busy?
The databases are defined in rootdbs, tables defined in lots of chunks. I'm not sure how to read the output of onstat -g dic. It appears that we have set DD_HASHSIZE to 501 and DD_HASHMAX to 4. Very few of the entries currently have a size of 4. The system is relatively idle at t…
Why is rootdbs busy?
Where are your databases defined? If the database is defined in the root dbs and the tables are defined elsewhere, then you might be hitting the systables quit a bit. What does onstat -g dic look like? There is a max length of each of the dictionary chains. If all of the hash…
Re: Updating sysdefaults
I think that the manual is right on this one.... ;-) It's not so important what is in the disk, but what is in memory in the dictionary cache. By changing what is on disk, you are bypassing the coordination with the dictionary cache, and --- well.... Jeff Larsen wrote: > Our …
Re: Updating sysdefaults
Thanks Art. I was pretty sure it was a bad idea. The manual writers should avoid tempting us by mentioning that the system catalog tables can be updated by user informix or anyone with DBA privileges. "Art S. Kagel" <kagel@bloomberg.net> wrote: >Jeff Larsen wrote: >> >> Our s…
Re: Updating sysdefaults
Jeff Larsen wrote: > > Our salesmen are always changing their minds about default > values for new customer records. We have a 24-7 system and > I have to kick everybody out just to be able to execute... > > alter table customer modify rate char(1) default 'V'; > > I know the ma…
data distribution cache
All: System info: - Informix 2000 9.21.FC1 - Baan IVc3 - HPUX 11.00 - DB 280 GB . 30,000 tables "12 Baan companies" I'm currently running DD_HASHSIZE 511 DD_HASHMAX 50 Considering DS_HASHSIZE 511 DS_P…
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…
Database Crash...Help
Hi All, I am having Informix v7.30.UC10X5 on HP UX 11.0. The database was running properly. I untared a isql tar file on the INFORMIXDIR and ran "installsql". The database was down when I installed it. But after instaling it did'nt comeup. So I again restore the earlier INFORMI…
SCO IPC
Bill Walker wrote: > > Art S. Kagel <kagel@bloomberg.net> wrote: > > > OK you tried, anyway. > > Yep. > > > IDS works fine on SCO, there are thousands of installations all using > > shared memory, indeed IDS NEEDS shared memory to work at all. > > Shucks. That do…
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…
Can you purge the Dictionary Cache?
In article <DWcXZKAt5fS5Ewdn@kontron.demon.co.uk>, Andy Lennard <andy@kontron.demon.co.uk> writes >Hi, > >Does anyone know if you can purge entries out of the dictionary cache. >It seems that once a tablename gets in there, it will remain until >forced out by another tablename, y…
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…
prepares in 9.2
cstefanick@koz.com wrote: > I recently went from 7.22 to 9.2 (big change, I know). In 9.2 > statement cache is used so that similar query plans are shared. Does > this mean that preparing statements is no longer needed in 9.2? > > Sent via Deja.com http://www.deja.com/ > Befor…
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…
Separating database system tables from the rest.
"Carlson@WHSmith" wrote: > > One of the issues I've had to deal with is the fragmentation of the > system tables within my larger databases. I thought that separating > those tables from all of the user tables within a database might be a > great ideas, for example: > > crea…
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…
Re: Initializing Dictionary Cache and Stored Procedure Cache
From: mourad <mouradNOmoSPAM@vt.edu.invalid> > >I'm trying to run Initialize the database server (Ver 7.3) >for the first time using oninit -iyv >but I've got the following messages: > >Initializing Dictionary Cache and Stored Procedure >Cache...Cannot find message file. Check I…
Initializing Dictionary Cache and Stored Procedure Cache
Hi, I'm trying to run Initialize the database server (Ver 7.3) for the first time using oninit -iyv but I've got the following messages: Initializing Dictionary Cache and Stored Procedure Cache...Cannot find message file. Check INFORMIXDIR and DBLANG.FAILED INFORMIXDIR is cor…
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…
Re: oninit use 95+%cpu
richard palmer wrote: > Informix 'trainers' that I've been around tend to know about odd quirks > of the engine -- they hear about stuff from internal sources that we are Often true. > > rarely informed of. That said, I think the SERVERNUM suggestion is > a crock that I would …
Re: Data dictionary
Graeme dbschema? Sujit Graeme Muirhead <csi@muirhead.freeuk.com> on 01/19/2000 08:07:47 AM Please respond to Graeme Muirhead <csi@muirhead.freeuk.com> To: informix-list@iiug.org cc: Subject: Data dictionary Can anyone point me in the direction of a script to generate a s…
Data dictionary
Can anyone point me in the direction of a script to generate a simple data dictionary for an SE database? Thanks Graeme Muirhead g_muirhead@csisystems.co.uk…
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…
system catalog cleanup
"Thomas J. Girsch" wrote: > > I'm afraid I already know the answer to this, but is there any way to > defragment (i.e., "clean up the extent interleaving") of the system catalog > tables, short of dropping the database and recreating it? I've got a 100+ > GB database that has sy…
Re: Baan on Informix 7.23 UC6
Tony Cullen wrote: > > Please ignore my last posting as I sent it as an attachment. I then noticed > that noone > else does this so here it comes without the attachment. Hi Tony, long time no-see. That is the preferred method, and in pure ASCII. > Hope someone can help here. We…
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…
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…
Write cache help
Wayne Trieu <trieu@ti.L-3Com.com> wrote in message news:807t74$ufk$1@nnrp1.deja.com... > Hi all, Hi ! > Can some one please help me how to increase write cache, right > now my cache is about 73% it seem low. I've tried all source recommend I > see on this group, but did …
Informix and Lawson
I am currently doing DBA work for a company running Lawson Financials. This is my first experiance with Lawson. It seems that all of the table design and layout functions (ie. extents, dbspaces, indexes, etc) are done from with Lawson instead of using the Informix utillities. …
system catalogues and extents
jblatz@worldnet.att.net wrote: > > I know that it's recommended that the number of extents for a table be > kept at 8 or less. However I notice that many of the system catalogue > tables have 12 or more. Is there anything I should/could do about this? First, the recommendation…
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…
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…
Re: Reac-Cache-Rate of a Data Warehousing System
From: "David Grove" <david_grove@health.state.ak.us> > >I'm wondering why achieving >95% read cache rate in a data warehouse would >be considered undesirable? Suppose you had several GB of shared memory. >You might be able to cache whole tables, or in a small warehouse, maybe >e…
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…
Re: Reac-Cache-Rate of a Data Warehousing System
I'm wondering why achieving >95% read cache rate in a data warehouse would be considered undesirable? Suppose you had several GB of shared memory. You might be able to cache whole tables, or in a small warehouse, maybe even cache the whole thing. Light scans are fast, but isn't…
Re: informix parameters in onconfig file
edem wrote: > > Can anyone advise me what can i make better in onconfig file > Informix 7.30FC7 ( will be 7.31FC2 soon ) on HP-UX 11 ( machine V2500 6 > processors) > i am using kaio ( kaioon=1 ) > Any advise will be very helpful > Thanks! > > And this is my onconfig file : It …
write cache / NETTYPE
Webber Valerie H wrote: > How important is the % Write cache on the onstat -p (listed below)? > I read you should shoot for 85%..... ours is very low... 8% and > sometimes 0%. How do you tune the database for write cache. We do > mostly reads and inserts and very few updates. >…
dictionary cache parameters
I read that the parameters (DD_HASHSIZE * DD_HASHMAX) should be greater than the estimated number of active tables in all databases for performance gains. Where the heck are these parameters? They are not in the onconfig file. Environment variables? Maybe. Any ideas? Also, …
dictionary cache parameters
I read that the parameters (DD_HASHSIZE * DD_HASHMAX) should be greater than the estimated number of active tables in all databases for performance gains. Where the heck are these parameters? They are not in the onconfig file. Environment variables? Maybe. Any ideas? Also, …
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…
Re: CASE tools for data dictionaries
>>>> Andrej Falout <afalout@xtra.co.nz> 09/01/99 01:36AM >>> >In article <37CB3908.E25B2ED6@iol14.com>, wraper@iol14.com says... >> I would suggest strongly that you invest in a copy of ErWin from Platinum >> Technologies. > >I disagree. I found this tool to be the biggest nightm…
Re: CASE tools for data dictionaries
From: afalout@xtra.co.nz (Andrej Falout) > >In article <37CB3908.E25B2ED6@iol14.com>, wraper@iol14.com says... > > I would suggest strongly that you invest in a copy of ErWin from >Platinum > > Technologies. > >I disagree. I found this tool to be the biggest nightmare piece of >s…
CASE tools for data dictionaries
list gurus, I am working on contract at a site using IDS(7.3) on Solaris. The customer has a database design in place. They are just beginning a project to do a ground up redesign. They are short on DBA expertise(ah, job security). I am looking for CASE tools for DB design a…
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…
DS_POOLSIZE,DSHASHSIZE , DDHASHSIZE & DD_HASHMAX
As you may notice from the onstat -g dic, we do allow the number in the dictionary chain to exceed the value of DD_HASHMAX. This is because the reference count is still raised (i.e. a query is currently using the table). As a general rule it is better to increase the width of t…
Loading into Shared Memory...
Marshall Turner wrote: Well, there is the SET RESIDENCY feature in version 7.3 -- the syntax is something like --- SET TABLE tab_name MEMORY_RESIDENT The table will remain in the buffer cache as long as possible. Writing the table out happens normally via checkpoints/LRU wri…
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.…
SYSMASTER database and extents
"Hamilton, Jerry" wrote: > > Hi Everyone, > > I'm running IDS 7.31.UC2, HP-UX 10.20 with PeopleSoft Financials. > > I know that too many extents on data tables is not good. Is the same true > with the sysmaster tables? I have the following sysmaster tables with more > than 8 ex…
mutex problem
Help ! My engine has crashed twice in the past 3 days, & I don't really have any ideas why, except that I believe it related to shared memory somehow. ? The system has been very stable - until now. There have been no changes that I'm aware of. The os has not been swapping at a…
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…
Nightmare NT configuration problem
Hi there, I have a dead-end problem that I don't understand... (involved with system installation so I simply can't work around it I install Informix dynamic server (universal data option) on my Windows NT 4.00 Server machine, set up the environment variables and try to run oni…
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…
IDS/SCO message file
For the life of me I can not figure out why informix (IDS 7.3 on SCO "Openserver" 5.0.5) is giving me this error: Initializing Dictionary Cache and Stored Procedure Cache... Cannot find message file. Check INFORMIXDIR and DBLANG.FAILED online.log shows no errors and …
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.…
Re: Online Config Changes
From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Not necessarily. The variables can be reconfigured within the ONCONFIG >file while the engine is up; they won't take effect until the engine is >bounced. There's quite a bit of stuff that can be set dynamically. For example, o…
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…
DD_HASHSIZE,DD_HASHMAX, DS_HASHSIZE, DS_POOLSIZE
Hello list, Has anyone encountered either an absolute or practical upper limit to these parms? (excluding total memory requirements). I only recently got my databases updated with distribution statistics and much to my surprise encounter worst performance after the update. …
PC_POOLSIZE
Does anyone know how much memory is being used by the default Procedure Cache? I'd like to increase the PC_POOLSIZE, but I'd feel more comfortable knowing exactly what affects this will have. I've done some testing with PC_POOLSIZE, and the procedure cache always keeps (PC_POOL…
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…
How can I list the databases of an instance from Unix prompt
I have tried the onstat command and it did not work. It will only list the active databases (three out of nine databases) on one of our IDS servers. I thought that <onstat -g dic> command is used to print dictionary cache information. Regards, Fred Lee fredlee@acm.org Howard wr…
Re: RESIDENT and PDQ
> > Also, as we all know, memory is cheap now. We would like to max out our > > Sun UltraEnterprise 3000 to 6G and cache up the entire database as > > resident, while still allowing substantial amount virtual memory. But > > it seems as though Informix is quite limited, permitt…
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…
MORE RAM - BIG CONTROLLER CACHE / DB ON RAW - DB ON FS
I recently had a discussion with a consultant. The following is a replay of this discussion. I just wanted to see your opinions on it. I : Why do you only sell storage arrays with no cache or a small one ? X : Disk subsystems with GBs of NVRAM come from th…
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?…
Sizing the dictionary cache. Does anyone bother?
Hi, I was wondering if anyone bothers to change the size and layout of the dictionary cache to improve performance. While looking through 'onstat -g dic' output over a period of time I noticed that the default dictionary allocation of 31 lists of 10 entries meant that some of t…
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 …
Re: How to invalidate informix' db-cache
In article <3649C80E.7F9@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Markus Pfadenhauer wrote: >> >> hi all, >> >> is it possible to invalide the whole internal database cache. >> By now I create some dummy tables and do a relationscan on them but >> this is not t…
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.…
Re: onstat -g dic question
Art S. Kagel wrote: > andy lennard wrote: > > > > An aside to this. On Solaris 2.6, 7.23.UC4 we had a problem with loads > > <snip> > > > > > Can't find anything in the manuals for onstat -g dic -- except that the > > > command exists. Does anyone know what the dirty? column …
Re: onstat -g dic question
andy lennard wrote: > > An aside to this. On Solaris 2.6, 7.23.UC4 we had a problem with loads > of 'dirty' flags caused by 'update table' statements. 7.30.UC3 seems to > have it fixed. > The dictionary rose from the default 310 entries to 1088, and > onstat -g mem gave dictpool …
Re: onstat -g dic question
An aside to this. On Solaris 2.6, 7.23.UC4 we had a problem with loads of 'dirty' flags caused by 'update table' statements. 7.30.UC3 seems to have it fixed. The dictionary rose from the default 310 entries to 1088, and onstat -g mem gave dictpool as 386Mb after 30 days. > Can't…
Re: BAAN IV on IDS ??
Rob You didnot see a BaaN database before apparently. There is a BaaN document on the creation of an Informix Database for the application. Some of its contents is OK. Some is definitely not OK. You'd better see some company that did this work before and knows the hazards of VL…
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…
Re: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
Re: onstat -g dic question
>Can't find anything in the manuals for onstat -g dic -- except that the >command exists. Does anyone know what the dirty? column means? > Onstat -g dic is used to dump dictionary information. The dictionary is the "in-memory" version of systables/syscolumns/sysindexes/ etc. T…
onstat -g dic question
Can't find anything in the manuals for onstat -g dic -- except that the command exists. Does anyone know what the dirty? column means? TIA, Tom Grenier DBA, Biztravel.com…
High-level DBA Opening in Chicago
Great client of ours has the following opening: They are looking to hire asap! Informix DBA Duties: *Responsible for all aspects of creation and upkeep of all Informix databases. *Responsible for all data design and dictionary development and maintenance. *Capacity planning an…
Opinions re: Sun OS disk caching with KAIO, On or Off?
Hello, For those of you using Sun boxes out there with Informix, help. Using 'top' recently I was looking at the memory free on our Sun E4000 (Solaris 2.5.1) and noticed that it was: Memory: 2048M real, 32M free, 52M swap in use, 972M swap free Notice the 32M free? After I r…
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…
Re: onstat -g dic
Art S. Kagel wrote: > Correct, it means that one or more of the system catalog tables has been > modified, through proper channels like an ALTER, UPDATE STATISTICS, > or CREATE/DROP INDEX statement, and the cached values are no monger > valid. The new values are not automatical…
Re: onstat -g dic
F.PALMITJAVILA wrote: > > Ok. > > What does it mean the DIRTI column? > > When she is YES, should I understand that the structure of that table to been > modified? Correct, it means that one or more of the system catalog tables has been modified, through proper channels like an …
Re: onstat -g dic
Ok. What does it mean the DIRTI column? When she is YES, should I understand that the structure of that table to been modified? How could I know what user to provoked this modification? Thank you. SaTriGuy wrote: > >Someone knows what is the result of onstat -g dic ?? > >Th…
Re: onstat -g dic
>Someone knows what is the result of onstat -g dic ?? >Thanks. The Dictionary is the in core cache of information derived from the system catalogue of a database (i.e. those tables with tabid < 99 such as systables, syscolumns, sysindexes, etc). Added to this is some informatio…
onstat -g dic
Someone knows what is the result of onstat -g dic ?? Thanks.…
Please help on BUFFERS configuration
Hello, This is the result of onstat -p: Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 55684746 62996402 402420642 86.16 585360 2321888 6684656 91.24 isamtot open start read write rewrite delete commit rollbk 158584062 4458…
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: Alter to cluster sysmaster
Joe Trubisz wrote: > > Any reason why I cannot do an ALTER INDEX...TO CLUSTER > on tables in sysmaster? Yes there is a good reason! Most of the 'tables' in SYSMASTER are not real tables bu pseudotables which are views into shared memory. Since the ALTER INDEX... TO CLUSTER nee…
Re: Column Names Returned from a View
The act of setting the values in the onconfig and bouncing the engine fixed the problem. Whether it was the adjustment to the data dictionary or simply the re-initialization of the engine I can't say for sure. Thanks, Larry Kemmerling AT&T Wireless Services Aviation Comm…
Re: Column Names Returned from a View
Larry Kemmerling wrote: > > This is a follow up to my original posting. Thanks to everyone that > has offered help. > > I created a simple view: > > CREATE VIEW test > ( C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13,C14,C15,C16, > C17,C18,C19,C20,C21,C22,C23,C24,C…
Re: sysmaster extents
davin_harvey@dsti.co.uk wrote: > I have a couple of questions on this then > > I've got nothing set for DD_HASHSIZE or DD_HASHMAX. onstat -g dic > reports 357 dictionary entries, but surely the maximum size is 310? > Also, only 14 of these entries are syste…
Re[2]: sysmaster extents
This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable I have a couple of questions on this then=2E =20 I've got nothing set for DD_HASHSIZE or DD…
Re: Re[2]: fragmented system tables
OK I'm dense. Still it will not help unless he also drops the database and recreates it. However, my main point still stands: This is not necessary, the fragmentation of the system tables in a database has NO EFFECT ON PERFORMANCE! This is not off the top of my head, I have ha…
Re: fragmented system tables
Sven Tolkemit wrote: > Hi people, On the broad assumption thatthis includes programmers, I will at least comment. > we discovered, that the system tables (systables,sysindexes, etc.) on > our Online 7.23.UC1 are very fragmented. We think, this leads into > performance problems…
Re: fragmented system tables
Sven Tolkemit wrote: > > Hi people, > > we discovered, that the system tables (systables,sysindexes, etc.) on > our Online 7.23.UC1 are very fragmented. We think, this leads into > performance problems. Is there a way to defragment the tables? Definitive answer: NO! You cannot…
Re: sysmaster extents
Paul wrote: > > I am running Online 7.23.UC4 on HPUX 10.20. > Is it important for the DBA to be concerned about the number of extents in > the system catalog? > I have plenty of room in root to accomodate the growth. No 1) There is nothing you can do about it anyway and 2) Th…
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…
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…
Re: limiting oninits?
This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_6F3B737D.52335F71 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted…
onstat -g dic output
<HTML> Hello, <P>Can somebody explain me the outcome of onstat -g dic <tablename>. <P>- What means all the output. <BR>- What can I do with it. <P>Regards, <P>Albert Wisse</HTML>…
Re: DD_HASHSIZE & DD_HASHMAX variables
Albert wisse wrote: > > <HTML> > I got from Madison Pruet the sugestion to increase the memory dictionary > with DD_HASHSIZE & DD_HASMAX because the application in use has > many tables, 2000 tables pro database isn't uncommon. > > <P>The dictionary parameters are undoc…
DD_HASSIZE & DD_HASMAX variables
<HTML> I got from Madison Pruet the sugestion to increase the memory dictionary with DD_HASHSIZE & DD_HASMAX because the application in use has many tables, 2000 tables pro database isn't uncommon. <P>The dictionary parameters are undocumented so if anybody has the syn…
DD_HASSIZE & DD_HASMAX variables
<HTML> I got from Madison Pruet the sugestion to increase the DD_HASHSIZE & DD_HASMAX <BR>settings because the application in use has many tables, 2000 tables pro database isn't uncommon. <P>The dictionary parameters are undocumented so if anybody has the syntax and document…
Re: INTIAL SIZE of the sys tables
>How can I set the INITIAL extent size of the sys tables like the >informix.systable >table? > >The only thing I do now is setting the NEXT SIZE after creation of >the database. > >The reason is that I know the will be big. for example I want to set >the INTIAL SIZE to 1024 for t…
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: -710 repeated
Some follow-up on this issue...I did some deja-news searches, and found the post listed below: -Peter ---------------------------------------------------- Subject: Re: DR cause error -710, help! From: Darshan Joshi <darshan@informix.com> Date: 1996/09/23 Mess…
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…
Re: sysptprof
Hi, Bill Ennis wrote: > I have a question on the sysptprof table in systables. The manual > says that profile information is available only when a table is > open. Does this mean that rows are deleted from this table when > no users are accessing OR does it mean that some inform…
the new bie with the share memory problem
Hi all: Thanks for all those who has responded to my previous question, you guy were a great help. Now I have put all the necessary stuff in /etc/system, rebooted, ran oninit -v, my results are: oninit -v Reading configuration file '/usr/yan/Informix/INFX_ODS_723/online/etc/o…
the new bie with the share memory problem
Hi all: Thanks for all those who has responded to my previous question, you guy were a great help. Now I have put all the necessary stuff in /etc/system, rebooted, ran oninit -v, my results are: oninit -v Reading configuration file '/usr/yan/Informix/INFX_ODS_723/online/etc/o…
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…
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: memory
Thuc Nguyen wrote: > > Hi > > I am running Online 7.23 on HP 10.20 > > We want to find out why we allocate alot of memory per user and never > release it. > > Is that memory leak? Actually you are probably not allocating any memory "per user". If your default connection, or the…
Data Dictionary Question OL DSA 7.22UC1
Now that I have added the 2 variables DD_HASHSIZE 61 and DD_HASHMAX 10 to the onconfig file, I still have a question about the Data Dictionary contents and when does it get flushed? Are there any commands to flush the contents? Any help would be appreciated. Thanks Tim Jones t…
Re: Diffs between InfoModeler in IUS and ROM
I can't give you the exact info your are looking for, because I have not seen the IUS version of Infomodeler. I can tell you that the version of Infomodeler bundled with Infomodeler is not the full version. I use Infomodeler extensively, and really think it is great. In the He…
Re: HP HW/OS and Shared Memory Segments Problem...
Greg Moye wrote: > > Does anybody know if current HP hardware (and HP-UX) still has that > nasty problem where >2 Shared memory segments can *really* slow things > down?? > > If so, is it scheduled to go away anytime soon?? > > TIA - Greg OK, I've been researching this HP shared…
US-NJ Oracle development
-- Hawk Data Processing, Inc. has an immediate opportunity for a Oracle DBA with the following skills for one of our most prestigious clients. This project is located in Somerset, NJ for a major telecommunications company. Oracle Devlpmt-SQL, PL/SQL, SQL *Plus, Oracle v7.3, SQL…
Re: doubt in onstat -g -dic
VASA SRINIVASA wrote: > > I have gone through system administration manual to find out the > detail column descpitions of onstat -g dic, specially 'refcnt'. I > coundn't find any reference to 'refcnt'. Please mail me details of > columns of onstat -g dic . Onstat -g dic reports …
doubt in onstat -g -dic
I have gone through system administration manual to find out the detail column descpitions of onstat -g dic, specially 'refcnt'. I coundn't find any reference to 'refcnt'. Please mail me details of columns of onstat -g dic . thanks --VASA SRINIVASA ______________________________…
Re: Data Dictionary HELP!
Try Powersoft's PowerDesigner...comes in several modules which can be purchased separately. I've used the DataArchitect module to reverse engineer a 360-table database. You can then break the design into sub-modules and print each one out...easier to look at. Later on you can con…
Data Dictionary HELP!
We have a 60,000 field/400 table Informix database and need to get a graphical view of the table joins and data field names to prototype a data warehouse project. Anybody know of a data dictionary tool that will help target the fields and tables? We checked out ERWin - but its t…
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: Update Statistics Question
> I understand the need for running UPDATE STATISTICS for the tables >in a database. The recalculated data from this command is going to be >placed in the systables, syscolumns, sysindexes and sysdistrib system >catalog tables. After updating statistics for user created t…
Re: Creating CISAM tables in C2000 report writer...
Hi, Decimal fields are not floats or doubles. They are encoded in an Informix proprietary format (documented in various manuals and header files). Informix provide functions to convert to and from decimal types with ESQL/C and maybe C-ISAM. Chris Guru wrote: > I am trying to a…
Creating CISAM tables in C2000 report writer...
Hi, I am trying to access an Informix SE table in Chameleon 2000's report writer. I have created the table in the Chameleon data dictionary and it reads all the details in the table correctly except for one field which, in Informix is defined as decimal (4,2). This field sends gi…
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: Caching tables in shared memory
Hi, OnLine 7.3 will likely contain options to indicate that specific tables should be favoured for caching. This can be used to bias caching for highly active tables. Chris -- Chris Jenkins (chrisj@informix.com) Advanced Technology Group >>> All statements and opinions are…
Re: Caching tables in shared memory
Uh, Rav... That's what BUFFERS are for. Ask your DBA about this parameter. The system is designed to do it as best it can within limits of memory configured. Caching caches only works if you have a faster storage medium. You don't. BUFFERS is as good as it gets. Forg…
Caching tables in shared memory
Hi Gurus, Here are a few questions regarding caching of frequently accessed table in shared memory. During a recent setup , I found that in my code a few of the tables were accessed very frequently. These are master tables and this particular module need not do any updates on th…
Re: Data-dictionary / Case tools
In article <33b13a91.30600891@gate.idg.no>, Nils.Myklebust@idg.no wrote: > > We are also looking at such tools. > In the thread mentioned by Billy there where no mention of > InfoModeler. It used to be made by Asymetrix but is now split out to a > separate company with the same…
Re: INFORMIX WISH LIST
Travis Rayhons wrote: > My current remedy for this is what most people do, name your fields > and > tables close to the meaning of their purpose. Also, I keep a data > dictionary in HTML format on my development server. The hassle is > when I > change a table, I must go to my …
Re: Data-dictionary / Case tools
We are also looking at such tools. In the thread mentioned by Billy there where no mention of InfoModeler. It used to be made by Asymetrix but is now split out to a separate company with the same name as the product. They are at http://www.infomodelers.com Have anybody used it? …
Re: Data-dictionary / Case tools
On 15 Jun 97 at 14:11, Paul Borrett wrote: > Does anyone have any experiences (positive or otherwise) to relate > concerning the use of data dictionaries or CASE tools with Informix > Online (currently version 5, moving to 7.23 shortly) ? There were bazillions of opinions offer…
Data-dictionary / Case tools
Does anyone have any experiences (positive or otherwise) to relate concerning the use of data dictionaries or CASE tools with Informix Online (currently version 5, moving to 7.23 shortly) ? The names i've had mentioned to me so far are ERwin from Logic Works & S-Designor from Po…
Re: Help -- OnLine server refuses connections
With ur current configuration nugread are cached 95% (which is good) and bufwrits are cached only 37% (which is a bad omen). Couple of possibilities ... 1. it looks like a shared memory problem. Check BUFFERS size in onconfig file. Buffers should be fairly large to handle 30 co…
Where are FillFactors stored in system tables?
Once you create an index with a fill factor, where does Informix store it in the data dictionary? For example, I would like to get a list of all the indexes with Fill Factors less that 90. Any help would be greatly appreciated. Thanks! David Gilbert (xanadu@mcs.net)…
Re: BUFFERS setting
In article <32BACDF0.3467@informix.com>, Dave Kosenko <davek@informix.com> writes >Bill Ennis wrote: >> >> You need to consider that you will be reading from the buffers as well >> as writing to them. >> >> I would be careful lowering since your read cache percentage is already >…
Job: CA, Alameda (East Bay) DBA - Oracle,Sybase,or Informix
Our client is a developer of retail business application (data warehousing) software in Alameda, CA (East Bay, 20 minutes from San Francisco). The Data Base Administrator is responsible for all aspects of data base, data dictionary, and object repository support for all software …
Re: >1 Virtual Shared Memory Segment slow down
If you're on an HP, set up you system to need only one or at MOST two virtual shared memory segments. The difference in performance between 1 and 3 is in the 400% range. It's a defect/feature/whatever of the HPs, but it's a real issue.. davek @ informix.com ("David L. Kosenko…
Re: >1 Virtual Shared Memory Segment slow down
"David L. Kosenko" <davek@informix.com> writes: > > David Williams wrote: > > > > I've been told by Informix that having >1 virtual shared memory > > segment slows down your Informix Online Database server.[snip] > > Why would added more shared memory segments slow down …
>1 Virtual Shared Memory Segment slow down
I've been told by Informix that having >1 virtual shared memory segment slows down your Informix Online Database server. Informix normally has 3 share memory segments 1 Fixed size 'Resident' shared memory segment for disk cache etc. 1 Fixed size 'Message' shared…
Any Suggestions on Integrated CASE Tools?
I am looking for an integrated CASE tool that can be used in teaching at the university level and for consultation. Does anyone have any suggestions? Looking for these features: - I-CASE tool - ER Modeling - Decompostion Diagrams (Business Process Hierarchy) - Process Modeling…
Re: Import structures from Foxpro?
Joe Lumbley wrote: > > Freedland, Marat - BALTO (mfreedland@pipermar.com) wrote: > > : Hello, > > : I have a large number of data files that need to be ported to Informix from > > : FoxPro and Access. Is there a way to import the file structures ( not the > > : data itself) …
Re: Import structures from Foxpro?
Freedland, Marat - BALTO (mfreedland@pipermar.com) wrote: : Hello, : I have a large number of data files that need to be ported to Informix from : FoxPro and Access. Is there a way to import the file structures ( not the : data itself) into Informix? Otherwise I am look…
Re: Import structures from Foxpro?
Freedland, Marat - BALTO wrote: > > Hello, > > I have a large number of data files that need to be ported to Informix from > > FoxPro and Access. Is there a way to import the file structures ( not the > > data itself) into Informix? Otherwise I am looking at the prospect of…
Import structures from Foxpro?
Hello, I have a large number of data files that need to be ported to Informix from FoxPro and Access. Is there a way to import the file structures ( not the data itself) into Informix? Otherwise I am looking at the prospect of manually entering the data dictionary for …
Re: Sparc Storage Array w/ Prestoserve NVRAM...
Greg (greg@cyberramp.net) wrote: : Has anybody put this combination to good use in an Online 7.1x : environment. I'm rattling around some ideas, but would like to hear : your success (or failure) stories. : I'd think caching writes to the physical log would produce the biggest…
Re: How do you guys maintain DDL versions?
Mischa Sandberg wrote: > > Once that DDL is in text form, any version control system gives you > what you need. Sybase is particularly nice in this regard: all the > text of non-table objects (procedures, views, rules, defaults, > triggers) is readily available, and is guaranteed…
Re: Data Dictionary / Data Modelling for Solaris
I have seen Silverrun demoed and it looks impressive. I seem to recall (please correct me if I am mistaken) that it requires its own data dictionary, rahter than working with the RDBMS'. Is that correct? Regards, jh -- Jared Hecker | ** HWA, Inc. ** Oracle and …
Re: Data Dictionary / Data Modelling for Solaris
S-Designor is also Good! On 24 Jun 1996 dbvision@inet.uni-c.dk wrote: } > cherylk@prod1.jcdc.doleta.gov (Cheryl Kendricks) writes: } > If you have CADRE working on 7 engine LET me KNOW! It's a work of sh...... } > from my view! } > } > ------------------------------------…
Re: Data Dictionary / Data Modelling for Solaris
> cherylk@prod1.jcdc.doleta.gov (Cheryl Kendricks) writes: > If you have CADRE working on 7 engine LET me KNOW! It's a work of sh...... > from my view! > > ------------------------------------------------------------------------- > Cheryl Kendricks > Internet:cherylk@pr…
Re: Data Dictionary / Data Modelling for Solaris
If you have CADRE working on 7 engine LET me KNOW! It's a work of sh...... from my view! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database …
Re: Data Dictionary / Data Modelling for Solaris
Try Cadre. jh U.Moser@t-online.de wrote: : We are looking for a Data Dictionary / Data Modelling Tool supporting Sybase : and running on X/Motif. Does anyone have one and can tell of experiences. : Thanks in advance : Ulrich : -- : ____________________________________________…
Data Dictionary / Data Modelling for Solaris
We are looking for a Data Dictionary / Data Modelling Tool supporting Sybase and running on X/Motif. Does anyone have one and can tell of experiences. Thanks in advance Ulrich -- ____________________________________________________________________ UM - Consulting …
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: OnLine 7.X performance - R U satisfied?
ray, > Are you taking full advantage of you physical memory? How does you > caching ratios look (onstat -p)? If not in the 90's play arournd with caching ratios are good, high 90's. > BUFFERS and SHMVIRTSIZE. Also, is the engine frequently allocating > additional shared…
Re: Old informix: I4GL, vintage 1988
> "M.T.Carrasco Benitez" <carrasco@innet.lu> writes: > Any support or knowhow about ? I still have the manuals if you have a question. > Hard question on dictionary structure. And what is that? > Tomas Nils.Myklebust@ccmail.telemax.no NM Data AS, Postbox 9090, Gronland, 0…
Re: IQ Report Writer - new column
In article <4kcbci$3ni$1@mhadg.production.compuserve.com>, Scott Riley <72630.2374@CompuServe.COM> writes > >I am using IQ Report Writer on a SCO Unix system with Informix >Online. I added a column to a table that is used in a >particular IQ dictionary, and I would now like to ac…
Re: Application Development
In article <DoHFsw.GIB@cix.compulink.co.uk> onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") writes: >This message is extremely relevant to an issue I am involved in at this >time. > [snip] >> 5. What other critical points if any should we be examining? >My major piece of ad…
Re: IQ question
hsprintjc@aol.com (Hsprintjc) wrote: >I am putting this IQ question in this area since I cannot find an IQ group >and I use it with Informix. I have created some customized IQ data >dictionaries to add some Informix table links that my application did not >have. Everything work…
Re: Good Buffer Size For Tuning Informix?
Hi Michael, The only really important factor in determining the number of buffers is the read and write cache hit ratios reported by tbstat -p. Keep increasing the number of buffers until these cache hit rates do not increase when the system is running a 'normal' workload. This …
HELP - Data Dictionary type utilities
I had no response to a previous request so I'll try again. I'm looking for a package that will produce field definition/population reports from a variety of Database systems. I'll be talking to clients with legacy desktop/mini/client-server databases which haven't been properly…
Good Data Dictionaries? and INFORMIX 4GL/4GX
Hi there. My organization is running INFORMIX 4.1 SE with lots of tables with little documentation. Are there any third-party database dictionaries out there that do a good job cross-referencing and documenting? Secondly, we are looking at upgrading our systems to a MS-WINDOW…
Re: Changing table ownerships & IQ
In article <41i4bn$a7l@cssun.mathcs.emory.edu> dheisler@bassinc.com "Dave Heisler" writes: > > We will be releasing IQ with our product soon. We have > ran into a problem in that IQ needs informix table ownerships > to be the same as what has been defined in the data …
IQ
I recently posted a reply to a question about the IQ product which said that I personally dislike it. I feel I ought to qualify that posting, so here it is! i) I would probably find many of the same dislikes to any similar product with a pre-build data dictionary, in that suc…
Free T-Shirt for Review of Data Dictionary
Free T-Shirt for Review of Data Dictionary Anyone interested in reviewing our product "Sentinel Information Catalog"? We are looking for people who have multiple database types, and who want to share the resultant dictionary using Lotus Notes. If you fit that description, and …
Re: Data Administration - Anyone Interested?
dstobart@shore.net (The BEACON Project) wrote: �There seems to be a lack of attention in the news groups to data �administration as opposed to database administration. Topics such as � Logical Data Modeling � Warehousing � Repositories � Strategies for modeling distributed dat…
Re: Data Administration - Anyone Interested?
>If a lot more people knew what a Data Dictionary was and used one, >life would be a fair bit simpler. FWIW, Tony Lima is going to present a session at the Borland Developers Conference next week in San Diego on creating a data dictionary for Visual dBASE. I'll be there, and wi…
Re: Data Administration - Anyone Interested?
The BEACON Project (dstobart@shore.net) wrote: : There seems to be a lack of attention in the news groups to data : administration as opposed to database administration. Topics such as : Logical Data Modeling : Warehousing : Repositories : Strategies for modeling distribute…
Re: Distributed Join
> relevant to the best solution today. As to distributed optimisation, ------------------------------- > OMNI does optimise distributed joins (because unlike its competitors, ----------------------------------------------------------------…
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?…
URGENT! Please read and help me!
Hello everyone, I am *DESPERATELY* looking for a 32-bit report writer to use under Windows NT. It must be something like Crystal Reports or better as far as functionality and features are concerned. It must have a data dictionary and I must be able to use its functions from C++ …
Re: Database tuning.. any hints?
Don't worry too much about the write caching rate. Although the book says that you should aim for 80% this assumes a well-balanced application. If you are doing a large number of INSERTs of large record sizes you will probably not achieve very high caching rates. Think about t…
Re: Can this be done?
In article <3adhaq$g49@gv-gate.gvg.tek.com>, martina@gvgtsg.gvg.tek.com (Martin Allred) wrote: > I was thinking, so look out. Can OnLine use a RAM-disk for the primary > database storage and put the mirror on a real disk? This should allow > for some serious speed improvements w…
Questions about Informix page buffers
Hi, in reading the Informix documentation, it mentions that page buffers are used to cache data from disk. It mentioned that the page size and number of pages are dependent on the database server and O/S. I am unclear on what the dependencies are other than the available memory a…
Questions about Informix page buffers
Hi, in reading the Informix documentation, it mentions that page buffers are used to cache data from disk. It mentioned that the page size and number of pages are dependent on the database server and O/S. I am unclear on what the dependencies are other than the available memory a…
Re: Informix vrs Oracle 7.0.x or 7.1.x
Alan Popiel writes: |> I have just completed Oracle 7 DBA training. I would like to offer the |> following comments comparing the data dictionary and optimizer of Oracle |> and Informix. |> |> 2. Oracle's data dictionary is rather more complete than Informix's. |> Oracle's DD…
Re: Informix vrs Oracle 7.0.x or 7.1.x
In <2tfedc$5cs@marlin.ssnet.com>, jminnich@bugaboo.ssnet.com (Joe Minnich) writes: >How does informix compare to Oracle 7. We are currently >beginning an evaluation. Feedback would be greatly appreciated. > Joe, I have just completed Oracle 7 DBA training. I would like to off…
Re: Does Informix 6.0 and beyond provides data dictionary information?
but where do you get to enter the data describes each table and column, etc... } } allau@sequent.com (Al Lau) writes: } } >Hi, } } >I'm interested in knowing what kind of information is available for the } >online data dictionary. I have not seen the 6.0 documentation and wonde…
Re: Does Informix 6.0 and beyond provides data dictionary information?
allau@sequent.com (Al Lau) writes: >Hi, >I'm interested in knowing what kind of information is available for the >online data dictionary. I have not seen the 6.0 documentation and wonder >if there is a way (Online 6.0 and beyong) to query the online interactively >and get a li…
Does Informix 6.0 and beyond provides data dictionary information?
Hi, I'm interested in knowing what kind of information is available for the online data dictionary. I have not seen the 6.0 documentation and wonder if there is a way (Online 6.0 and beyong) to query the online interactively and get a list of all those chunk locations (full pat…
Crystal Reports dictionary
Has anyone used Crystal Reports Pro 3.0 dictionary? I am having problems setting up the data. I have several reports that I wish to include in the selection but every time I start setting up the dictionary, I get booted out and Dr. Watson comes up asking what I was doing before t…
Re: BIG Istar performance problem
Paul, thanks for fast response, >> On the server I have 300 to 500 sqlturbo processes. No frontends >> runs on the server. All frontends are version 4.10.xx and all >> backends are version 5.00.xx. The slow connection with Istar is done by tcp/ip. >We have a Sun IPC (small, si…
S.JERSEY C'TRACTORS/STAFF
**************************************************************************** Posted date: 12/13/93 Makefield Software Systems, Inc., a software consulting firm located in suburban Philadelphia, managed by software engineers, is attempting to locate SEVERAL independent contractor…
Re: Schema Generator, Data Dictionary Questions
Thanks to all who responded to my post. Since I posted I spoke with technical support at Informix, and they faxed me "Tech Info Article #921, Interpreting values in coltype/collength in systables syscolumns, from the Fall 1990 Technotes". The document gives information above an…
Re: Schema Generator, Data Dictionary Questions
In article <C91npK.249@portal.hq.videocart.com> bgale@portal.hq.videocart.com (Bill Gale) writes: } PROBLEMS } } At this point I am having trouble reverse engineering values in the } syscolumns.collength field back to their english equivalents which were } used to build the colum…
Schema Generator, Data Dictionary Questions
I am building a combination schema generator which produces a dbschema-like sql command file for database creation. Additionally, it supports a minimal data dictionary. The basic idea of the schema generator is to populate two tables very similar to systables and syscolumns via…
Global Data Dictionaries
Salutations! I'm currently doing some research on Global Data Dictionaries, and was wondering if anyone out there in net.land would be able to add to what I've been able to find (my bibliography is included below, in case that is of interest). My (perhaps incorrect) definition …
Re: Systables in local cache (was: Correcting Next Extent problems).
}From: uunet!pyra.co.uk!graeme (Graeme Sargent) }Subject: Systables in local cache (was: Correcting Next Extent problems). }Date: 1 Mar 93 10:20:09 GMT }X-Informix-List-Id: <news.2727> }In <1993Feb23.160915.5802@informix.com> (Dave Kosenko) writes: }>Contrary to what the manuals…
Re: Correcting next extent problems
>While Jonathan is correct, I will venture to say that this entire >discussion is misguided. Contrary to what the manuals lead you to >believe, having more than 8 extents will not have any significant >impact on the performance of your system. The reason 8 is used is that >8 ex…
Systables in local cache (was: Correcting Next Extent problems).
In <1993Feb23.160915.5802@informix.com> davek@somerset.informix.com (Dave Kosenko) writes: >While Jonathan is correct, I will venture to say that this entire >discussion is misguided. Contrary to what the manuals lead you to >believe, having more than 8 extents will not have an…
Re: dbschema and documenting tables/columns
>From: uunet!col.hp.com!judym (Judy Miller) >Subject: dbschema and documenting tables/columns >Date: 23 Jul 92 16:49:57 GMT >X-Informix-List-Id: <news.1574> > >I need suggestions for documenting an Informix database I support. It >has been modified greatly since it was first cre…
Database Schema SCCS?
I'm looking for some software, either commercial or something someone has written, that will allow me to keep track of database schemas, and the changes made to the schema (add this table, delete this field, change this field from smallint to integer, etc) and allow me to version…