Oninit® Archive
Results for “SP_AUTOEXPAND”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
script to check status of dbspaces & chunks
Hi All, I need to write a shell script to check the status of all dbspaces & all chunks of an instance & send an email if any of dbspaces/chunks got corrupted/dropped/inconsistent etc Can any body help me in this regards? Regards…
Question on file systems for cooked files
Again, responding inline: A couple of follow-up questions based on your response: We're in agreement on the separate file for each chunk (as you acknowledged in your response), and I was expecting to use the EXTENDABLE option as well. My Linux sys adm (and most sys adms I've wor…
Extending chunk capacity
John: The self-adjustment is that when I set up a server that way, I will also configure storage pool entries for all of the file systems designated for Informix chunk use so that if the FS supporting a chunk does fill up, the dbspace is expanded with a new chunk from one of the …
Onbar: Failed to determine archive's encryption mode. Error code 2
Hello Jacob, normaly there should be following messages in bar_act.log when starting logical restore: DATE TIME ONBAR_PID ONBAR_D_PID $INFORMIXDIR/bin/onbar_d -r -l -t DATE TIME ... Using Veritas XBSA ... as the Storage Manager... ... bar_build_timelline: target time XXXX ... ...…
How to verify all the requirements for an onbar restore
Hi Family. I've been mostly quiet on this group because my gigs of late have been Perl with little to no Informix. That has now changed. (YAY!) I have little to no experience with onbar. I performed some backups by rote and used archecker to get back a table my client had inadve…
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 ------------------------------…
Want to DROP an empty rootdbs chunk
David: From the oncheck output it looks like this is an extended chunk table page mapping your last six chunks. The only way that I know of to clear that would be to drop those six chunks, drop this chunk, then recreate those chunks which will hopefully be able to live on reserve…
Informix vNext slides from IIUG/Scott/Karen/Shripad
Hi, Interesting IIUG talk from Scott/Karen/Shripad abhout vNext New Features https://www.iiug.org/wp-content/uploads/2023/04/Informix-VNext-New-Features.pdf "Performance better or equal than prior release: 14.10.xC1 Investigating new compiler impacts, better scaling on Linux, imp…
stat() failed for chunk file
HI, Check the chunk files exist. Check the permissions on the chunk files and all folders related to the chunk files. Regards, David. ------------------------------ David Williams ------------------------------…
How many aio/KAIO
Interesting discussion. I don't agree with a lot of things said here, mostly about hyperthreading and "overloading" cores with Informix CPUVPs, but, whatever works for some (test) environments has a right to be presented, I guess. Some AIX / POWER comments. On POWER you are very …
Index creation strategy when autolocate is set
Hi, AUTOLOCATE is a bit unusual in that even when set to 1 it still creates a round-robin table, just with a single fragment. You can see this because the table itself has no part number and there will be an entry in sysfragments of fragtype 'T', which a non-partitioned tables do…
How to find which dbspaces are set to auto extend?
Ramon: No, there is nothing in sysadmin about extending chunks of expanding dbspaces using the storage pool either. It is all stored in sysdbspaces and syschunks. Witness: dbaccess sysmaster - > select * from sysdbspaces where dbsnum = 4; dbsnum 4 name datadbs_1 o…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
curious about extendable chunks
Hello Mark, you don't need a storage pool to extend chunks. You only need to set that chunk extendable: $ echo 'EXECUTE FUNCTION task("modify chunk extendable on", 4);' | dbaccess sysadmin - # set chunk#4 extendable $ echo 'EXECUTE FUNCTION task("modify chunk extend", 4, "8GB");'…
Table Extent Size calculation
True, Eric. If you want to depend on the storage pool to allocate new space to a dbspace to accommodate new extents, then make sure to set the extend size for the specific dbspace large enough that the whole extent will fit in it. Otherwise the storage pool will add multiple smal…
Logical Logs/Physical logs
why not just monitor the chunk writes to the phys & logi chunks with onstat -D for a definitive period of time ... should know very quickly.…
Decrease Size of Root Dbspace
If there are multiple chunks you can drop any uninhabited chunks. Other than that, you are stuck. Art…
down chunk
Informix 11.50.FC6 on HP-UX 11.31 PA-RISC We're working toward upgrading to 14.10 on Linux, but until then, we're running the environment shown above. Since 11.50 is way past EOL, we're kind of out of luck for support from IBM/HCL. If it was a production system, I might try to …
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…
raw device usage tracking
Hello, To avoid dealing with offsets, I create separate lvols for every dbspace and one of my instances is reaching > 1500 chunks/lvols (22TB). Thinking it would simplify disk usage management, I built a couple of large lvols of 1.2TB ea. and allocated them to the storage pool.…
how to change the default location of rootdbs
I have installed innovator-c 11.7 with default settings. when I do onstat -d /usr1/Informix/ol_informix1170/dbspaces/rootdbs /usr1/Informix/ol_informix1170/dbspaces/plogdbs /usr1/Informix/ol_informix1170/dbspaces/llogdbs /usr1/Informix/ol_informix1170/dbspaces/datadbs /usr1/Infor…
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…
storagepool free space recovery
Hello everyone, I dropped a storagepool dbspace using 'onspaces -d' instead of the function 'drop dbspace to storagepool'. How do I return the free space to the storagepool? Is there a function to list the contents of the storagepool? Thanks, Benoît…
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.…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
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…
Moving Instance
What about chunks? Can you move them to a different directory as well?…
Chunk Files
Where is the best place to put the cooked files? In the informix home directory? This is just an Informix server we are using for training and messing around. Is there a best practice type of thing for this?…
log_full.sh getting Aborted by client.
Looks like the location got turn to read-only - have no idea how or why this happened. informix cars: onpsm -D list Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE HIGHEST --/-- DBSPOOL /opt/informix/backups/infx/spaces FILE R…
onload questions
IDS 11.50.FC5 Solaris 10 I sent this in a couple of days ago, but I never saw it posted. --- I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace infor…
onload - onunload
IDS 11.50.FC5 Solaris 10 I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace information? How does it know to send the tables to the different dbspaces?…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
Chunk symbolic links
Hi, I have a question about creating chunks with simbolic links: I can't figure it out how it's done. Let's assume that my chunks are on a separate storage. I did ln -s for all chunks to $INFORMIXDIR/storage/chunks but Informx doesn't start after I set the rootpath to $INFORMIXD…
storage pool doubt
Hi and thanks beforehand. Is there a way to split between raws or chunks in the storagepool new chunks added for a dbspace? I dont want all chunks added to be from same disk.…
renaming chunks with ontape?
I would like to replace a drive with a larger drive (with larger chunks). Is it legal to create larger chunks on the new drive, and then use the rename option of ontape to do a cold restore, and use the new and larger chunks, in place of the former chunks? Is it legal to combin…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
Adding a chunk
Hi, Is there a problem if I add a cooked chunk to a raw dbspace ? Thanks in advance.…
storage pool feedback
Right now in every ifx server I have, space increase is managed manually. Any of you tried the storage pool options? I have done it in test servers and I'm afraid I will loose control over what is the server doing. For instance I'm thinking about creating a storage pool but not…
Database hanging
Hi, I have 60 chunks, one chunk is being write when I launch onstat -D but why the dbaccess mydb hangs, is that logik if there is a slow IO ?…
informix down
Hi informix is down on a backup node (clr), the logs mention a I/O error I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 the chunk number 9 is member of the log dbspace can you help ?…
Dbspace with 2 chunks
Hi, I have a dbspace with 2 chunks. The first chunk is almost full, the second has a lot of space. What will hapen when the first one is completaly full ? Informix will show a 0 on onstad -d command for this chunk ? Enviado desde mi iPhone…
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)…
Chunks Down Help
Hi restore the dbspace from your last archive, if you don't have an archive you must call the support, they have tools to quickly bring up dbspaces.…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
End chunk mirror on two serves doing er
Hello: Which one is the best way to end chunk mirroring on two database servers? Maybe, end chunk mirror for root space on slave server and them on master server? And end chunk mirror for other space as final stage. Thank you. --001a113ecbee87c9c5052616cb37…
after upgrading to 12.1 log back script not workin
HPUX 11.31 (11iv3) HP BL870c Integrity server IDS 12.10.FC5 Friday I upgraded our ERP with the latest-ish opensource products and Informixto IDS 12.10.FC5 and missed the note about ISM_DATA_POOL and ISM_LOG_POOL being removed. Silly me listened to our ERP that there is nothing e…
RE: after upgrading to 12.1 log back script not wo
Well, maybe more of the psm is setup than I first thought, I found the onpsm command and did a list of the devices, objects and pools. Since I'm getting objects I assume the logs are being backed up, but because of something when I do a onstat -l the logs do not show they are bac…
load-insert with no rollback ?
HI, Folks IDS12.10 FC4 I was loading big amount of data to a table, begin work; lock table hist201511_lin_source in exclusive mode; load from hist_lin_source.data insert into hist201511_lin_source ; commit work; later, it was running of dbspace , and session was terminated by…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
OAT User Question
Morn'n Folks, IDS=11.70.FC8XB8 O/S=AIX 6.1 I am in the predicament of administering Informix on environments that I do not know the informix password on. I do have sudo rights to informix and functions that I need as root. I am setting up OAT and "thought" that by setting ADMIN…
Re: How can I resize a chunk?
Since version 11.70 you can enlarge a chunk by doing the following: dbaccess sysadmin <<EOF EXECUTE FUNCTION task("modify chunk extendable on", 1); -- 1 means chunk number in onstat -d EXECUTE FUNCTION task("modify chunk extend", 1, "400 MB"); -- extend chunk#1 by 400 megabytes …
dbspaces corrupted
We have Version 11.70FC4 sitting on a Red Hat 5.9 server that is, in turn virtualised. All dbspaces are on cooked file systems. We had a process that blocked the server using "onmode c block" followed by a level 0 backup using "ontape s L 0". At some point during the backup,…
Offline a chunk
Hi, How to offline a user space/chunk created. I have tried, onspaces -s testDB1 -p /tmp/testDB1 -o 0 -D. But no use. Flags still shows it online. 45ff1028 13 13 0 1046575 1044760 PO-B-D /tmp/testDB1 I am checking restore scenario using onbar.…
chunk extendable limit.
AIX 6.1 IFX 12.10 xF4 Hi , Today my production run with v11.50 and I'm evaluating the migration to v12.10 . Considering migrate chunks from RAW to Cooked file (with direct_io+concurrent_io) my initial plan would be export/import the database and reorganize tables and chunks. ~ …
Root db space fills up
The instantiated view is approximately 160 MB and the dbspace added is 2GB. It seems that the database doesn't even try to use the new dbspace. I've looked at what is in the different dbspaces during execution of the select query against the view and the temp table appears in the…
Problem with a upgrade 11.7FC7W1
Hello everyone I updated some of my instances : After wards my tempdbs fill up like 40 gigs holy S#$%@ it was th_probe_ffffffffffffffff and th_build_ffffffffffffffff in database HASHTEMP in this instance I got this error from OAT when opening storage : specified table (storagep…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
consolidating dbspaces
HP UX B.11.31 U 9000/800 IDS 11.70.FC7GE Good Day, I want to consolidate a number of 2gb chunks into a single chunk. Can anyone advise me on how to do that ? Thanks…
Dropping a chunk
Hi, Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now I like to drop the chunk in this way: onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 What am I doing wrong? Thanks in advance. Enviado desde mi iPhone…
Problem dropping dbspace
A little more information, in case it is helpful. The cause of the corruption is that the raw devices were accidentally allocated to a second instance while still allocated to this instance. Both instances have flagged these devices as offline. The original plan was to drop thes…
onload question
When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the database came from dbspace 1, write it t…
RE: onload question
Solaris 10 - Sparc IDS 11.50.FC5 When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the databa…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Chunk Size
Hi we are running 11.70.FC7 on Solaris 10 and we just got new storage for our database. For the first time our storage admin asked what size chunks we want for our raw DB storage. HIstorically we have always had 2 GB chunks. Any suggestions on a good chunk size for an OLTP system…
Re: storage pool configuration.
OK, here's the deal: - Chunks are marked as extendable or not extendable. Extendable means it is possible to make the underlying file bigger if needed (so no RAW chunks can be extendable). If it is extendable there is not current limit on the maximum size. The only configurable i…
storage pool configuration.
Hi, ifx 11.70 FC7 . AIX 6.1 I'm studying the best way to use the storage pool at v11.70 . Today we use v11.50 , I'm planning our migration to 11.70 and my desire is allow informix automatically admin my chunks growing and try start with "best" way already configured... I have n…
Chunk Size
Hello Group, Do you have a recommendation on what to set the raw chunk size? Currently we are using raw devices and are split into 2GB chunks. Our storage admins would prefer to give us larger chunk sizes for future disk allocation and want us to recommend a chunk size. Is there…
Warning: The storage pool is out of space
Hello All, I am using the IDS 11.70 FC4, and I am not using the automatic storage pool provisioning feature. But, I have seen this message in the online.log file. I have enough free space available in the dbspaces. Can someone explain that why this warning msg has appeared an…
Warning: The storage pool is out of space
Doesn't SP_THRESHOLD = 0 mean it is the automatic is off ? > Hello All, > > I am using the IDS 11.70 FC4, and I am not using the automatic storage > pool > provisioning feature. > > But, I have seen this message in the online.log file. > > I have enough free space available in t…
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.…
Error: DR: Couldn't send add dbspace/chunk request
hi, 92 % occupied - 8 Gb free (maybe a week). Today I run again the command and suddenly it Works (WT?) DCCPLD02:/ifxpld02/chunks$ onspaces -a datos00 -p /ifxpld02/chunks/datos00_16 -o 0 -s 4096000 Verifying physical disk space, please wait ... Chunk successfully added. Now w…
Storage pool is out of space error
Hi all, I've recently inherited an Informix database, so I'm relatively new to IDS. Today I got at email telling me: Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add space to the pool. Our main databases have extendab…
Why Temp Table created by View using DATA dbspace
Hi, I am using IDS 11.70 FC4. I have a query which is joininig two views to pull more than 100 million data rows and sorting them. I have noticed that whenever I execute it, my datadbs free space gets consumed, instead of tempdbs. I have added sufficient tempdbs engine is not…
Chunk Auto-expanding
Hi , I'm studying about the auto-expanding feature. ifx.1170 FC6 Appreciate any help/explanation . I trying understand how Informix should behave in certain situation and how I see/do the configuration. The situation what is my desire to work : * No storage pool configuration…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Re: Storage pool
I have received this message - at a live site and need to quickly fix - can you help with a pointer…
server migration from windows to linuxu
hello: my doubt is about chunks. can i copy chunk files from windows to linux? can linux manage right chunk files from windows? my doubt is about to export data fully with two informix v11.7 from windows 2008 64b to linux 64b. thank you and regards. --047d7bb04cf2188a3904d02c…
Adding chunks ISAM error 137
Chunk table overflows are virtually impossible to occur in v11 unless you have over 32k plus something chunks allocated. Sounds to me like there is some corruption in the Informix reserved pages , run on oncheck -cr to see if all your chunks are listed/any errors reported and che…
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,…
Storage pool
Today I had the chance to read up a bit about the Storage Pool. We upgraded to 11.7 only very recently, and this morning I found this message in our online.log: 10:38:32 Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add …
LRU Queues - more or less
onstat -F shows 0 LRU Writes 8314165 Chunk Writes…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
Logical Log backup during L1 archive
On Friday, 27 April 2012 18:57:12 UTC+1, Superboer wrote: > Hello Malc, > > Looooonnnggggg shot.... may be way off here... > > > ism has 4 streams max as paralelization and one can configure it how > many are available > and how many per device etc. > > if all of them are used w…
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…
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
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 …
ZFS and Informix
How does Informix stack up against Oracle? I have never heard of any head-to-head private performance benchmark that Informix did not win on performance alone. I have personally witnessed several that Informix did win. Buffer pool performance is not dependent on the filesystem u…
onbar dbspace restore with fragmentation
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver halted at a checkpoint. When I forced it to continue, the instance remained online but an entire dbspace with constituent chunks …
how to get all the instance's chunks free space
I created several informix server on a host. To monitor each server's chunk space,I have to setup environment parameter then run 'onstat -d' to check the chunk's free space. Anyone can write a shell script that get all informix server's information ( like 'onstat -g dis' do) and…
dbpaces
hi, i want to copy using sql a table from 1 dbspace to another dbspace . Is this operation possible with ids 11.50? exemple: insert into dbpace1.database1.table1 from select * from dbspace2.database2.table2 thank's for your help…
Drop DBSpace
Hi experts, I want wo drop a dbspace, which we have been using for some byte columns as blob store. Now, we added a smartblob space and copied all the values to a blob column. The whole table was copied and access to the new table works good. Old table was dropped now. We want t…
Onbar's Handling of "Empty" Chunks
How does onbar handle "empty" chunk files during backup and (especially) restore? Is it intelligent enough to determine that a chunk contains no data at all and can be handled differently (perhaps more efficiently?) than one that contains user data? Or is this an irrelevant co…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
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…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
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.…
need to know when was a dbspace went down.
Hi All, I would like to know when my dbspace went down... I didn't find from the log... is there a way i can find from the systables? 70dc0318 10 10 0 524287 0 PD-- /chunks/chunks024_device0000 70dc0498 11 10 0 524287 0 PD-- /chunks/chunks024_dat0102 70dc0918 14 13 0 512048 0 P…
dbspace planning
Hello, I have only 4-300GB SAS 10K RPM drives that are mirrored across 2 channels. I'm using RAW devices. Any suggestions as to optimal dbspace layout in this IDS 11.7UC1GE instance on RHEL5.5 32-bit for OLTP? I'm planning layout below: disk 1. rootdbspace, phys log, logical …
Performance advantage: fragment across dbspaces vs. in single space
Is there any advantage to fragmenting across multiple dbspaces instead of simply fragmenting in the same space? Aside from performance, are there any other reasons to fragment across dbspaces? Using IDS 11.50.FC4 on HPUX 11.23.…
New System Config and DS8800
Hello Throwing out feelers on some questions regarding the setup of Informix OLTP systems on the new DS8800 Storage. We had drawn up a RAID 10 design for both data and logs and received feedback that RAID 5 would work out just fine. Through the years, the literature, conferences…
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…
onunload dbspace handling
Does onunload/onload handle variations in dbspaces? That is: 1) If I onunload a database which resides in 2 dbspaces, can I onload it into another instance with differently named dbspaces? If so, what is the command line syntax? 2) Can I onload a database which resided in 2 d…
OK Next step: ISM imported restore of onbar -w using disk-based backups
For reasons to complex to go into, we're now backing up to disk (data and logs), using onbar -w and ISM, pool names ISMDiskData and ISMDiskLogs whereas before we used an external storage manager to tape. We do a copy of our live database (300Gb or so) on a regular basis onto our …
Number of dbspaces
Hi, I have a database of 250 GB of user data. How many dbspaces is suitable for optimal performance: - For OLTP transactions ? - For queries ? - For backup using onbar ? Currently, I have 30 dbspaces configured. Is there any strategy or tip that I can use? Please, provide any i…
Cannot open chunk ''
The errno - 2 says there is a chunk that does not exist. Try oncheck -pr. It will either point you to which onw it is or fail if it is the 1st chunk.…
ISM issue.
Hi, I just setup the ISM for the new install of Linux Dynamic Server Version 11.50.FC1, and I have issue with onbar b w in the new ISM setup. Please advise. Here is the ISM setup Modified the onconfig file. ISM_DATA_POOL ISMDiskData ISM_LOG_POOL ISMDiskLogs LTAPEDEV /apps…
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…
Raw Devices
Currently we are using our database on IDS 11.50.FC6 and our dbspaces are on UFS file system.Can we transfer our existing dbspaces on raw disk and how we do it , Also how much down time is expected.…
Extent and DBSpace
Hi, I have a database space issue due to the 2Gb limit on a DBSpace. How do you force the next extent of a table to be on another DBSpace. Thanks Andrus…
Re: RSAM
How come INFORMIX-JDBC has examples of RSAM calls like for rs.next()?, and "...IDS is divided into two parts: a storage manager called RSAM, and a query optimization/execution engine implemented on top of RSAM, and has a well-defined, published API...Implementing Index Stride a…
How to calculate page size + chksize into bytes, m
chknum smallint Chunk number dbsnum smallint Dbspace number nxchknum smallint Number of the next chunk in this dbspace chksize integer Number of pages in this chunk offset integer Page offset of the chunk in its device or path pagesize integer Page size (in units…
Dbspace recovery
Hi, I have started testing revovery of a singe dbspace or all. The senario is that the server that the IDS was running on is completely gone and we have to restore a backup from the backupsystem (we use Veritas NetBackup) to a new server/host running the same IDS version (for ti…
onbar restore hanging
Hi, Do onstat -g iof moving or not on individual chunks? rgds schillache…
Re: On Dropping chunks
Reorg the tables in this dbspace so that all of the free space is in the last chunk which should not have any TABLESPACE entries in it. Then you can drop the last chunk and add it to the other dbspace. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board o…
On Dropping chunks
Hi there. I have the following question. Can I drop a chunk which is not the initial for dbspace, but it's not the last one either? Because I am in this situation: the second of three chunks on the same dbspace is empty according with Server Studio, but with TBLSpace entries …
chunk offline
Hi All, We had a situation were a non-critical chunk went offline. This was a cluster setup and during some testing/disk alignment by Unix, this chunk went offline. It was marked PD. This chunk contains only a portion of one Index.( Checked before using oncheck –pe ). Used onspa…
how can i delete a bad chunk??
ids9.4/linux32 after a chunk bad,i want to delete it i try $ onspaces -d dbs02 -p /spsdb/chunk202 -o 0 WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: Chunk not empty so how can i delete this bad chunk force??…
Re: Large chunks versus small chunks.
> > I'll see if I can rustle up the disk testing tools because it would be > interesting to see the results from contemporary machines or arrays. I can't find my stuff - stupidly entrusted it to a geocities hosted web page which has been absorbed by Yahoo and now thrown away. H…
Large chunks versus small chunks.
All, I would like gauge opinion on whether or not it is better, worse or does not matter if you use fewer larger chunks or more smaller chunks. I am trying to find out if you have any experiences or better still evidence that chunk size matters. I not over concerned about the am…
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…
Raw devices softlink to dbspaces were lost
You can also try to run oncheck -pr - there will be a section that shows all of your chunks and chunk paths.…
Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx…
Curiosu about a message in bar_act.log
What does this message mean in bar_act.log? "n percent of [dbspace name] has been backed up."…
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…
ONBAR woes :-( Advice needed
BRYAN PURKIS wrote: snip.... > > I add valid tapes to the pool and also to the scratchpool and try again. > > Whaddaya know - i get this error in the bar_act.log "XBSA Error (BSAInit): > That object already exists" > > Not good - on interrogating sysutils i see there actually IS …
what is the 0x40000 meaning
0x040000 means Blobspace contains Big Chunks…
Re: Moving dbspaces to larger chunks
Hi Kagel, Is it possible to move/migrate rootdbs(root chunks) also from small chunk to large chunk? rgds schillache…
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
WARNING: Next backup of DBspace rootdbs must be le
Hi, thanks for answering, yeah we add chunks to dbspaces, but we had not added chunks to rootdbs y physical y logical logs dbspaces. For example today and May 26 i added chunks to normal dbspaces and we didnt get the WARNINIG NEXT backup message. What other reason it could cause …
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
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 …
Informix page cleaners (w/ a SAN)
James, are you experiencing any issues, long checkpoints maybe? You have 90ish chunks and 128 CLEANERS. During checkpoint each cleaner gets assigned to one chunk (in the order of chunk creation) so you're on the safe side there, the extra cleaners should just idle. Regards Dav…
how to save the removed chunks by mistake
Someone want to drop a dbspace and remove the chunk file by mistake. Server can not restart owing to the down chunk. Can not drop dbspace or chunk by 'onspaces' or 'onmonitor'. Any way to solve this problem ?…
Esoteric Disk Issues
What's wrong with ZFS for databases is that it was designed for filesystems. From the OpenSolaris ZFS pages ( http://www.opensolaris.org/os/community/zfs/whatis/): ZFS presents a pooled storage model that completely eliminates the concept of volumes and the associated problems …
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…
rename chunk's
Hi all: I need to change the PATH of all my chunks in my body. For this I must do the following: 1. backup online full: $ ontape-s-L 0 2. rename file to create chunks: -- sintaxis: old_chunk old_offset new_chunk new_offset archivo_rename.txt: / usr/informix/devices/chunk1 0 …
Dbspace creation
Hi, I have 3 hard disk partitions hda5, hda6, hda7. I would like to create dbspace in each of this file system partitions. hda5 - dbspace1 hda6 - dbspace2 hda7 - dbspace3 We wish the dbspaces to have the size equivalent to the partition size. I have created the dbspace1 usin…
How can I resize a chunk?
Hello, is it possible to resize a chunk? I know i can do it the long way by exporting the data, drop tables, drop the chunks, create new chunks of smaller size, recreate dropped schema, import data. However this is a very long, convoluted and error prone process. So does anyone …
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Re: Copy Informix Chunks using dd ?
> Jarrod, > How can I change the status of Mirror chunk as Primary > chunk ? > -- D mirror the whole dbspace in question. bring down the chunk you want to move using onspaces.(primary) relink the chunk to be moved to a new unused raw device.(make sure permissions are o…
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Migration to a new storage
We will use a new storage for dbspaces. How I can migrate data from old storage to new the new storage. Can I use ‘dd’ for it? I will move dbspaces by ‘dd’ and re-link my dbspaces on new storage.…
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…
Is there a downside to creating large chunks?
I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 tables. I want to spread these across 8 dbspaces. Is there a disadvantage or advantage to creating 1 chunk per dbspace initially? Thanks, Andy…
Analysis of activities during checkpoint.
"If you are using a few large chunks instead of a larger number of smaller chunks, you will have only one flush thread per chunk running at checkpoint time. More chunks means more flush threads means less time to flush." Dang, is this still true as of 10? We may have caused our …
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.…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
understanding oncheck -pp
Yes, chunks can be shared by multiple instance on same machine. I tested that IDS supports it. My machine is on local disk and there is no chunk sharing. Thanks to you and apologies to Art. vartika.…
chunk is down
My box is aix 5.3 , ids 10 FC3R1. I start my ids and run 'onstat -d' 700000031d801c8 14 10 0 512000 0 PD-B /dev/ rtmpdb1 tmp dbspace is down. $ ls -l /dev/rmptdb1 crw-rw---- 1 informix informix 10, 20 Feb 25 13:39 /dev/rtmpdb1 owner , group name…
Real simple onspaces question?
I have a very simple onspaces question. I know, newbie here. I did try finding out the answer in some manuals and books I have but believe it or could not find a definitive answer. Anyway....with IDS 9.4 to bring up a Primary chunk that is offline the syntax is.... onspaces -s DB…
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…
ONBAR not working
Hello, From the ism commands below, we cannot tell what type of ISM device is this one (tape or file?). I think that, one of the steps missing here, before labeling the ISM device, is to add the device and indicate its type (file, in this case?), using the 'ism_add -device' comm…
Moving a chunk from one logical Volume group to another.
I need to move a chunk from one logical volume group to another. I am running IDS 7.3 on HPUX 11i. My chunks were created using links to logical volume groups. Is there a command I can use to move the chunk.…
windows-1252?Q52=65=3A=64=69=72=65=63=74=69=6E=67=
The storage manager is responsible for archive output location when onbar is used because the storage manager will have to be able to locate the files in case of a restore request. So, you'll have to set that up in netbackup if you can. Art S. Kagel ----- Original Message -----…
directing onbar to disk?
I'm migrating an Informix enviroment to the datacenter of our parent company. They use Netbackup as the storage mgr (we use TSM). The Netbackup agent for Informix is installed and onbar configured to use it. Netbackup is taken down everyday from 1100-1300 for 'maintenance'. This,…
Rename Dbspaces
Hi All: I can rename logs dbspaces online ??? Thanks _________________________________________________________________ Regístrate en el nuevo Windows Live Messenger beta. [1]¡Haz click aquí! References 1. http://g.msn.com/8HMAESAR/2734??PS=47575…
Chunk not dropped. ISAM error: No such chunk
I've performed this drop chunk command and process several times in the past, but this time I'm receiving an error. Do you see anything wrong or is there a bug. Hopefully the chunk will still be written to once the main chunk is full: IBM Informix Dynamic Server Version 7.31.UD8…
Re: Onbar backup using Tivoli Storage Manager
Hi, when you are using ON-Bar as backup and restore tool, then ON-Bar will always send all backup objects to the storage manager (SM) and will retrieve restore objects from the SM. What the SM does with these objects is a configuration matter within the SM. I do not know TSM wel…
Onbar backup using Tivoli Storage Manager
Hi guys, Is it possible to send logs backup of informix to disk using TSM? How can this task be achieved? I understand that ontape uses LTAPEDEV and whenever you use onbar and a storage manager to backup Informix, TAPEDEV and LTAPEDEV are ignored and all the mechanism control i…
Fragment by partition
Version: Informix 10 I have couple of questions regarding fragment by partition in same dbspace: 1. Is there any limitation as to how many partition a dbspace can have. 2. Is partition name unique to dbspace or unique to index/table. Logically it should be unique to dbspace as …
Informix on iSCSI
That is, having the chunks on an iSCSI device. Any thoughts?…
HDR - Adding chunks
You need to add chunk only on primary. But make sure that the chunk path exists on machine where secondary reside. For better performance you should also grow the file on secondary to required size before adding chunk on primary.…
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
chunks overlapping?
Yesterday our system went down with the log file showing this below: quote 16:18:33 Informix Dynamic Server Version 7.30.UC6 Software Serial Number AAC# J540938 16:18:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. 16:18:35 Physical Recovery Started. 1…
TSM and IDS - Any suggestions for best performance?
We are in the planning phases of a Tivoli Storage Manager backup solution implementation for our enterprise to include IDS, SQL Server, MySQL, mail and a collection of other client files here and there. Anyone have any suggestions or pitfalls to avoid that can help make this imp…
renaming a chunk
Hi, We are using IDS10.0FC5 We would like to rename a chunk to satisfy a link checking script that we have running on startup. It seems that the recommended ( apparently only available ) way is to do a rename during restore. That is not an option for us. I was wondering if it wo…
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…
Adding new chunk/free up used chunk
Hi, I am currently having a table that is stored in rootdbs and it almost used up all the available pages inside that space. So I decided to add a new chunk to it but it was unsuccessful. The error given is: Cannot add a new chunk to the DBspace. ISAM error: no free disk space …
Adding a Chunk
I was wondering, when you add a chunk to a dbspace that is already using part of the raw device and need to specify an offset is the offset expressed in pages or kilobytes? Thanks…
Dbspace script
Hi, Is there a script or utility that can review your current layout of dbspaces and then create a script of "onspaces" commands to duplicate the environment?…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
Listing all the tables in using a dbspace in Informix
Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V…
Primary/Mirror Issues
Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this ag…
Veritas Net Backup : on-bar IDS 10.0 AIX 5.3
Hi, what exactly do you mean when you say "we are not able to connect to the new (dummy) instance for backup."? I guess you are able to connect to the new instance using a utility like dbaccess. Is it that when you want to execute onbar commands that they can't connect? How do…
Total length of columns in constraint is too long
Ankur, Sorry about the previous email response. Here is what I meant to send. I am not sure what documentation you refer to, but the IBM Informix Guide to SQL: Syntax for 9.x found at the link listed below clearly states the limitations of multiple column constraints( pag…
Onbar Pools and File System with ISM
Andre, You could start by checking out the following online manuals. The firs= t link is to the IBM Informix Storage Manager Guide and the second is to the IBM Informi= x Backup and Restore Guide, both of which will be helpful to you in answering yo= ur questions. I believe the…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Re: Moving logical logs backup to disk
Hi Robert, The storage manager backup client runs on the database server, the storage manager backup server and tape run on a different server. We actually want to get rid of the storage manager backup software and just use informix to output the logs and database backups to di…
Determine which tables and indexes are in which dbspaces
I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the indexes are in the same dbspace. I know have some indexes in dbspaces that have tables in other dbspaces and want a query that will sh…
Re: Moving logical logs backup to disk
Gerry, You mentioned that the sys admin guys at your site want to retire the seperate server with tape drive. Just for clarification, does this mean that this server also is the storage manager server or is this just the configured backup target with tape devices only? If this …
Moving logical logs backup to disk
Hmmm... thin ice, looong time ago.... for ism you have ISM_DATA_POOL ISMData ISM_LOG_POOL ISMLogs onconfig values where ISM_DATA_POOL points to the name of your pool where dbspaces are sent to and ISM_LOG_POOL points to the name of the where the logs are sent to. if i …
temp dbspace
Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or …
Logical log backups
Hi, the pool thing is a common concept with storage managers. If ISM_LOG_POOL fromonconfig file is not used, then you have to find out (probably at SM end), where the SM puts the log backup objects, i.e. in which pool. That will then also tell you what you have to change so that…
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
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…
mirroring dbspaces
Hi all, anyone having experience with mirroring ? I inherited an informix config from a former collegue, and it looks very strange and insecure to me. In short : system running Solaris 8, 2 disks. All slices EXCEPT slice 6 (used for Informix raw-devices), are mirrored with Sol…
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…
Can't drop down dbspace
I've been restoring a development database from very old backups (long story). Due to errors doing a full DB restore, I restored the critical dbspaces and 1 user dbspace. Logical restore of the next dbspace fails in the same logical log, probably due to a corrupted index. So that…
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…
Quick Ontape -r rootdbs question
Hi, If you attempt to use the ontape -r with redirection of the chunk names parameters for a specific database, is there any effect on rootdbs for the other databases? In other words if we have a 2 server set up described below and restore one dbspace, will ontape also restore th…
TEMP DBSPACE
Hi we have two quries like below create temp table tmp_table_no ( sl_no serial, lang_a char(2), lang_no char(14), rec_cnt integer) with no log second one is insert into tmp_table_no (lang_a, lang_no , rec_cnt) ", select distinct language_a, lang_no, count (lang_no) from ti_lang…
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/…
Chunk space
Hi, Sorry for my poor english. And yes, im newbie width informix. I run this: copy nul filechunck.000 onspaces -c -d namedbs -p c:\\infxData\\infxserver\\filechunk.000 -o 0 -s 2000000 .... and all is ok. But when ... oncheck -pe ... Chunk Pathname …
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…
RAID 5 hardware and different dbspace ?
Is there a interest to separate tables on different dbspaces if disks are managed by a RAID 5 hardware…
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!…
drop a chunk in v10
I understand that enhancements have been made to V10 so that you can control the tblspace tblspace and thereby reduce some of the situations which lead to not being able to drop a chunk. But is that all situations? What about if some extents of one of the system catalog tables …
Increased extent size, but still hit max extents
The table is in a DBSPACE of related tables. Other "schemas" are in their own dbspaces, and each dbspace has its own group of chunks. Can I infer from your question that if Informix can't find a 20M contigous area, it will just choose the next larger? Which would imply that I ne…
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.…
dbspaces/tempspace shows up with a "B" flag
The database server has been enabled to use chunks >2Gb. These dbspaces probably use large chunks (greater than 2Gb).…
Temporary dbspace
Many of my current systems have just one temporary dbspace. Is there any mileage to be gained by adding a second temporary dbspace on a multi-processor system but with only 2 disks which are mirrors of each other? Some reports and queries are not performing as well as they did …
Free space...Clustered Data
Do many companies use clustering indexes...via table data ordered by a key (clustered)? Is there a performance boost in Informix when the data is clustered -- and then retrieved via cluster sequence? If clustering helps, will Informix allow us to specify the % of freespace on a…
Chunk Not empty
Hi, I am trying to drop a dbspace (named conversion). That dbspace originally was consisted from 10 chunks (conv_dat.000 to conv_dat.009). I have dropped successfully up to conv_dat.005 chunk. When I try to drop conv_dat.004 chunk (using the onspaces -d conversion -p E:\\\\IFMX…
Re: ipload hangs
Possibility for errno = 36 in online log could be an operating system error message OR the database server exited without shutting down properly OR a chunk(s) down. Run oncheck -pr and check the chunk reserved page to determine if any chunk is down. Hari…
Relocate Informix database from Raw slices to filesystem
Thats sounds promising. So effectively add a mirrored chunk to each dbspace using onspaces and then drop the original chunk. Can you do this for the rootdbs dbspace too...? Matt…
Re: Failed Import, ISAM 172 Error, Corrupt Indexes
well you are getting I/O read errors on chunk 9... onstat -d ...what is chunk 9? What platform? Can you do dd if=<chunk 9 path> of=/dev/null bs=1024k count=10 ? Are the permissions on chunk 9 ok? Owner informix group informix, mode 660…
Chunks down
Hi, I have a dbspace named calms13_dbs and a number of chunks in that. SOme of which have become down with status PD. I have 3 databases in that dbspace .I have some questions here. 1. How can i know reason for the chunks going down? 2. When i drop the database in that dbspace, …
Re: Change chunk name
on 7.31? thought you could only drop chunks on 9?…
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…
One Chunk vs. Many Chunks
Hello All We finally upgraded from 9.21 to 9.40. We are planning to add two 50 GB dbspaces to an instance. There are already many dbspaces in this instance and most are around 50 to 60 GB. One dbspace is 256 GB and we are trying to rearrange the data so we can reduce the size of…
Database and no dbspace
Help. The dbspace is drop but now the database can't be drop. How do I drop/remove the database. I have created the dbspace but no luck. error: 311: Cannot open system catalog (systables). 135: ISAM error: TBLspace does not exist…
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:…
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…
how to find a dbspace for a table
Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. T…
large chunks
Is anyone running IDS 9.4 on a SAN with large chunks? Is performance satisfactory? sending to informix-list…
large chunks
Is anyone running IDS 9.4 on a SAN with large chunks? Is performance satisfactory? sending to informix-list…
dropping chunk
Hello all, IDS9.40.FC4 HP-UX 11.11 I have successfully dropped an empty chunk from the database and tried to allocate it to another dbspace (after a Level 0 Archive) I am getting the message "The chunk specified already exists.". However, when looking for the chunk using "onsta…
dropping chunk
Hello all, IDS9.40.FC4 HP-UX 11.11 I have successfully dropped an empty chunk from the database and tried to allocate it to another dbspace (after a Level 0 Archive) I am getting the message "The chunk specified already exists.". However, when looking for the chunk using "onsta…
Re: ONBAR backup with only 1 tape drive.
Hi, we do not recommend such a setup. Therefore I never really tried such thing and can't say for sure whether or how it would work, but here are some ideas for a start: Probably you need to define in the storage manager that both pools go to the same media. Alternatively (or …
Re: ONBAR backup with only 1 tape drive.
Hi, we do not recommend such a setup. Therefore I never really tried such thing and can't say for sure whether or how it would work, but here are some ideas for a start: Probably you need to define in the storage manager that both pools go to the same media. Alternatively (or …
chunk access
Hi, The chunks are created with user and group informix. Theoritically only users in this this group should be able to access the chunks. But i have created a user "dummy" which is not in informix group. THis user is still able to access the data in the database. How is this poss…
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: Complete Backup on Windows NT
> Quick question, after adding new chunks, do I have to do anything to > ensure the database server uses them? After you add chunks with onspaces server will use then when needed. You can not really control which chunk will be used by server. Best regards, V.K.…
Big Chunks vs Small Chunks
Hi, All We just upgraded our data warehouse database(1TB) from 7.31FD2 to 9.40FC2, the instance is running on a partition of HP Superdome attached to EMC storage with 8GB memory cache. There over 500 2GB raw logical devices allocated to the instances with in 66 dbspaces right now…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
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: Pool Names ISMData & ISMLogs Not Created
It turns out that because we did not have the Korne shell installed on our machine, ism_startup -init wasn't working properly Many thanks to Savio for his suggestions though. "Savio Pinto (s)" <spinto@cap.org> wrote in message news:cg2okq$4eb$1@news.xmission.com... > > few year…
RE: Pool Names ISMData & ISMLogs Not Created
few years back, when i was backing up the database using ISM, i used to do the following, hope it helps 1. make sure there are no nsr processes running 2. initialize the ism using $INFORMIXDIR/bin/ism_startup -init 3. add informix as the admin user, $INFORMIXDIR/bin/ism_add -adm…
Pool Names ISMData & ISMLogs Not Created
Hi, I am trying to set up ISM on Informix 9.3 and I believe the pool names ISMData and ISMLogs are not being created when I run ism_startup -init. Could anyone tell me how to fix this problem? The steps I followed to setup ISM are as follows: Initialise ISM: ism_startup -…
How to find the creation date of a chunk ? (not a dbspace, a chunk ?).
--0-2003821237-1092088394=:10165 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Tha…
onspaces -m ... -f parameter
Found it myself - by trying a guess at the format, if you are wrong it tells you what the format should be. For every chunk in the dbspace to be mirrored you need a line like this: primary-chunk-path offset mirror-chunk-path offset…
dbspace down
I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore the database and make the engine online. Any inupt is highly appreciated, thanks Mukund sending to informix-list…
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…
How to find the creation date of a chunk ? (not a dbspace, a chunk ?).
--0-504143858-1091557308=:68591 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Than…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Logical logs from rootdbs to own logspace
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?…
Adding chunks
I'm a long-time developer who has suddenly been handed a DBA hat to wear. I understand I should make a link to some raw disk space and use onmonitor to add the chunk. What I'm unclear on is allocating the raw space, and I apologize in advance since this may be more of an OS (AI…
Down chunks
Client is suffering from chunks being marked down due to incorrect ownership and permissions on some of the chunks. Some meathead must have gone in and changed them. Will they be able to get the data back once this has been corrected? Any clues how? (It didn't work when I tried …
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.…
RE: Performance advice
On Thu, 22 Apr 2004 03:00:06 -0400, Willem Roos wrote: > I've been led to believe that all logged temp table activity goes to rootdbs > and all unlogged activity goes to temp dbspaces. Yes, no? <SNIP> If there are no 'normal' dbspaces listed in DBSPACETEMP then logged temp tabl…
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…
Informix data files interchangable btw Unix & Win?
Hi, What kind of Data Files ? (DB Chunks ?). If DB Chunks, it's not possible. Try DBEXPORT and FTP to Windows and DBIMPORT or (table level) Unload to file Load from file or (replicate transactions) Use Replication (CDR)…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? Thanks.…
move a chunk
hi, we have to move location of all chunks (root, tmp, data,...), how can i do that ? thanks…
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,…
dbspace destroyed
Hi! On one machine dbspace was destroyed by unwary sysadmin who repartiioned disk with informix chunks on it (raw devices). Now, informix can be started (it complains about missing chunks though). What is the procedure for removing staled information for chunks? I should remov…
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…
Dropping a dbspace
I have a bad dbspace I wanted to drop (and recreated). But I have some problem. Here is the output form onstat -d: 5010c7d8 1 0x20001 1 1 N informix dbroot_test3 5020dcb0 2 0x20005 2 1 ND informix dbdata 5020de00 3 …
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…
What is in my dbspace
Try oncheck -pe. This will report the contents of all dbspaces/chunks.…
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…
Re: chunk removal
TBP wrote: > > Geezer From Freezer wrote: > > I've added a chunk which I think may be too big. Now the chunk "new" chunk is > > part of an existing dbspace. It seems that 3 blocks are used (this always seems > > the case when adding a chunk anyway) and no other data has been allo…
RE: chunk removal
Yes, this chunk can be removed without corrupting the dbspace. When you add a chunk to the system 1 page is allocated for chunk free list page and 2 pages are reserved. sending to informix-list…
chunk removal
I've added a chunk which I think may be too big. Now the chunk "new" chunk is part of an existing dbspace. It seems that 3 blocks are used (this always seems the case when adding a chunk anyway) and no other data has been allocated to this chunk. Can I remove this chunk without c…
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.…
Re: ISM Startup Errors
Hey, Thanks for your input. I started ISM without -init. It seemed fine. When I try to take a backup, nothing happens. This ithe ISA output ------------------------------------------------------------------ 55638 2003-10-29 10:01:09 Successfully connected to Storage Manage…
IDS 7.3* - Long long long checkpoint !
I've noticed very long checkpoints in the online.log file. What does IDS do in a checkpoint that can take so long ? Environnement: IDS running on NT 2000 or Linux (even SCO !) with at least 128MB RAM, monoproc. IDS is usually the only big apps running on the box. "Small" databas…
chunks down
Hello, I am using Solaris 7 (sun4u sparc SUNW,Ultra-4) and running Informix Dynamic Server 2000 Version 9.21.UC1. In the period from 22nd Sept to 3rd Oct 6 chunks went down - fortunately Informix mirroring switching seamlessly to mirrored chunks (which are now online). Among th…
big dbspace
Hello, I need a very big dbspace (at least 15Gb) for my database (IDS 9.4) but the limit for a single dbspace is about 2Gb. How can I increase this limit? thank you…
DROP Chunk
Hi, We added some weeks ago - successfully, thanks to you all ! - a new chunk to a dbspace. We tried to drop this chunk using "onspaces" command but he said "no such chunk !" ... :-( It seems the corresponding file has been removed in between : is it possible to drop the chunk i…
break one dbspace in to two dbspace
Hi all I have one dbspace where I have all data and indexes I wanted to created one more dbspace one dbspace has the data in it one dbspace has the indexes in it how do that ? regard sending to informix-list…
Mirrored Chunks ....
I need to change my Primary Chunks to Mirrors and vice versa, to get my primary chunks on faster disks. I can always archive, change device links and restore. Is there an easier way? Thanks.…
Dropping chunks
Hi, I have created a copy (gemsnew) of a database (called gems), renamed the = gems database to gemsold and renamed gemsnew to gems. Thanks for your = help. They reside on different dbspaces, protodbspace and gemsdb1. I now = want to drop the chunks from gemsdb1 and also the dbs…
Re: Multiple Temp dbspaces
You might want to check your DBSPACETEMP entry - it looks from your post like there's white space between the dbspace names - Informix will stop parsing at spaces, tabs etc. and will only pick up the first dbspace listed. HTH -- Phil@oninit.com…
Re: dbspace ?
Where do we all begin? A dbspace is an area where databases, tables, etc can be stored. It is not just one file, it is more likely to be a number of files or more likely devices. When a database is created it will have a base dbspace where all tables will be created unless othe…
dbspace ?
Hi, Sorry, I am a little bit new in Informix. We need to modify the structure of a table, and the system allways answer that the disk is not big enough. They say it's because the dbspace is too small. Questions : - is the Dbspace a file or just allocation ? - is there ONE dbsp…
ontape - All pages or just used pages
To calculate the size of a dump, do i take all pages on all chunks or just used pages in chunks ?…
Resizing chunks
Ok I have 6 chunks on a system that use only 25% of an available disk partition. I want to resize to use all of the disk partition Can I do this without interrupting the data. Note: each disk partition is only being used once at the moment. OR do I have to backup, delete, recr…
Is there a 2gb dbspace limit NT 4.0, IDS 7.3?
Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?…
Rename a dbspace
Hi, Does someone know an easy mean which permit me to rename a dbspace contening just a separated index ? Thanks in advance. Best Regards Fred…
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…
Reg: Max size allowed in creation of dbspace
Hi , I need to create a dbspace of abt 5-6 GB. on using onspaces to create the dbspace i am limited in size to about 2.09 GB is there a way to create a dbspaces of about 6 GB or is there a size restriction ? Thanks for any help Sudhir sending to informix-list…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
Re: Multiple instances and ISM
No ;) You can have many instances using the same pools within one Storage Manager. The pools just represent where to shove the data / logs. The unique ids returned from the storage manager and placed in the ixbar.servernum are how a restore identifies what objects are needed. …
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…
Re: backup onbar
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bc5ct1$fn3tr$2@ID-64669.news.dfncis.de... > David Williams wrote: > > > > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > > news:bc52r5$fk9nk$2@ID-64669.news.dfncis.de... > >> DBA-BABY wrote: > >> > >>…
Adding chunks
Hey all -- Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3 chunks totalling 120MB. Plenty of space now. I have also successfully added several 1GB and 2GB chunks to my dbspaces. But now when I try to continue adding chunks to my dbspaces, I am getting this mes…
Dbspaces access
Hi All, Does anyone know how to obtain a report of a dbspaces more accesed, read / write, by sap or informix I really need this information, thanks in advance!! Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
delete down dbspace
Hi, I have a down dbspace, I am not able to do anything with it, there is no needed data inside, how I am able to delete this dbspace. (the dbspace has one chunk). Thanks Sven…
finding the tables within a chunk
hi all, how can i find the names of tables within a certain chunk? Simply, i = want to find which tables or table fragments a chunk contain?is there a = sql statement for it? Thanks in advance.…
reg: configuration of ONBAR
Hi, [ I guess you mean ISM (Informix Storage Manager) and not ISAM (Index Sequential Access Method) ... ? ] OK. ISM needs a minimum setup which for testing purposes I usually do with a script like the following : ism_startup -init ism_add -admin informix@onbarfix ism_add -d…
Migration of Chunk
Hi all, Current I have informix 7.31 running with about 10 active chunks. How to I migrate those chunck to new and faster harddisk space on the same server instead of doing import/export and load/unload. Thanks and Regrads, Tham.…
chunk transplant
> I thought Robert said his server OS mirrored the chunks, so if the > hardware fail, he has other server with the same configuration and > hardware able to bring on-line a new Ifx server by using the mirrored > chunks. It works, but if the IDS get a unrecoverable crash, this sch…
chunk transplant
We have been investigating ways to keep data current on a local and identical backup server. We are aware of IER and HDR. My boss suggested that we keep a mirrored chunk on a cross mounted drive that resides on the backup server. Then in the event of a failure of the primary se…
question on how to list tables in a DBSPACE?
Hi, Does anyone have some type of scripts that list All DBSPACE for an Informixserver, and all tables in each DBSPACE + how much bytes they take? Thanks!…
Tables for a chunk
Hello, I need to find the tables for a chunk. Is it possible with SMI tables? Regards Enrico Sent via Deja.com http://www.deja.com/…
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
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…
bad primary chunk?
I keep encounter this message "Bad primary chunk /s7/mysblobs" when i do a onmonitor mode -> startup or oninit -s. I also noticed that the bad chunk (/s7/mysblobs) is offline. What could cause a chunk to offline? How do i bring the chunk up/online? YFWoi…
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…
Dropping a dbspace
Hello All, Can somebody please help me with this. When I try to drop a dbspace, it says can not drop it. db space not empy. How do I find out what is there in the dbspace. Please help. Regards Aboo…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
��� ������ ������ ����?
�����������! ����������, ��� ������ ������ ���� � ����������� �� ����� � dbspace-�. ______________________ With best wishes, Kirill Solomko, JSC Protoka…
Re: ON-Bar Logical Logs to Disk
you can define a device in your storage manager as a filesystem and set your log pool to use that device only. however no matter WHAT you do, you will always need a storage manager and therefore if your storage manager fails, your entire backup solution fails. we have 2 storage…
RE: OnBar script needed for NetBackup
I use OnBar from the command line, without regard for the storage manager.� How�hard is 'onbar -r'? � Why would you want to use cron to restore??? � Setting up Netbackup is relatively simple with OnBar.� The Netbackup manuals explain it well. � Doug -----Original Message----- Fr…
OnBar script needed for NetBackup
Hi all, Recently, there's a lot of comments on the OnBar & OnTape command. But I can't find the info that I needed. My company is plan to use Netbackup and I'm totally have no idea on the OnBar command. According to my vendor, Netbackup has no scheduler to handle the restore ope…
OnBar/OnTape
To expand on Fred's reply vis-a-vis OnBar.. OnBar does see all the backups as being in "one place". It is the responsibility of the storage manager software (ISM, Legato Networker, Veritas NetBackup, Tivoli Storage Manager, etc.) to place the data on the media and keep track of…
dbspace is down ...
When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstest WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
DBspaces and IECC
I have installed IECC on an NT4 machine with a 36 gig hard drive. I have created a dbspace on the D drive that is currently 7Gig. The D drive has 24 gig of free space, but Informix is not seeing it. When I try to add space to the dbspace it tells me that there is no free space…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
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…
Put on line a dbspace
Hi, a client of mine has compressed some of his chunk:) so the dbspace and the chunk where put down. I have taken on line the chunk (onsapces ....) but now I have the dbspace down. There is a way to force it online? Many, many thanks.…
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…
Down chunk
Il s'agit d'un message multivolet au format MIME. --------------7D33438D52CB1F419DA8B8A5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Recently I had a disk failure on my HP-UX server, and the chunk file of my Informix db went down. I tried …
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…
Creating Dbspace
I am trying to create a new dbspace with a size of ~2Gig. When I specify the path to the cooked file to use it tries to verify the disk free space and always fails at around 1 gig. I know that I have plenty of free space on the disk so I can't figure out what the problem is. I…
Add chunk.
Hello, I am a newbie. Working with AIX 4.3.2 and IDS 7.30 UC7. After adding a second chunk to a dbspace I got the error message: extents overlap(oncheck -ce). Chunk was successfully added and onstat -d shows the new chunk. What is the problem? Thanks in advance, Fredo David…
Altering DBSPACE
Hello group, We have created all of our tables in dbspace "st_ux01_001". Now the "dbadmin" want to move all of our tables to dbspace "st_ux01_002". In Informix dokus we didn't find any command to alter a dbspace. The only way we know to alter the dbspace is, to export all data…
DBSPACE by table
There is a table in sysmaster who contains dbspace for every table. Thanks in advance. -- Francisco Gaspar SISTEL (Servicios Inform�ticos de Software y Telecomunicaciones, S.L.) Avda. Los Jarales, 4 03010 Alicante Tel: 96 593 00 80 Fax: 96 593 01 53…
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Restore Granularity with onbar
I am using Informix 7.31 on Solaris 7. If you have a dbspace with 50 chunks, you lose three chunks, so they are now marked down by informix, when you restore from tape (using onbar) will it only restore the 3 down chunks or all 50 chunks for that dbspace? Thanks…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
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…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
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…
Dropping a chunk by force
how do u drop a chunk by force in IDS 7.31…
Bad Chunk
Hi, When I am trying to initialize the shared memmory using oninit -s. I get the following message in the online.log: shmget: [EEXIST][17]: key 526a4801: shared memory already exists 00:11:21 mt_shm_init: can't create resident segment 00:11:38 shmget: [EEXIST][17]: key 526a…
TEMP dbspaces
Hi I have peculiar problem with temp dbspaces on IDS 7.22 UC1 and HP-UX 10.2. We defined tempdbs1,tempdbs2 as TEMPDBSPACES and 50000 pages for each dbspace. This system was configured two years back and using for development. This IDS server never be shutdown until necessary. …
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
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…
Recover a bad chunk
Hi If one chunk goes bad, what are the various methods to recover the chunk or how to copy one chunk to another. Any suggestions? regards usman musman@iffco.com Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
Chunks and Offset.
Hi Gurus, I have a query, what will happen if I add another chunk (cooked file) and the offset is not zero. Regards. Jojo…
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…
Dropping a chunk
I want to drop the chunk featured below, but it has a phantom tblspace in it. Does anyone have a foolproof method of eliminating the recalcitrant tblspace, with recourse to informix Tech Support? thanks Neil Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size …
use of ISM and ONBar
This article should guide you in setting up ISM with onbar. In order to get IECC to work, you might need to install and start the serveragent on the Unixware box. --Anil Tech Info Article Title: INFORMIX STORAGE MANAGER (ISM) 7.3 INSTALL/CONFIGURATION The following is an e…
When IDS need reinstall.
My IDS on sco .My chunk is use raw disk.no backup.When My IDS need reintsall ,How can I reuse the chunk,restore the data? Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
DBSPACE / DBSIZE
I am forced to inherit and maintain and Informix database for now. I studied the Informix book(s) over the weekend and have yet to find what I need. I hope to be a master some day as well, but for now I need immediate help with these questions: How do I determine the c…
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…
dbspace not empty
Hi Thanks for all the suggestions about the database reorg - when I finally managed to export all the data I ran an oncheck -pe and 5 of my chunks had data in them and they weren't related to any of my databases - see attached oncheck -pe. Any idea how to clear them out as I ca…
Re: move dbspace/chunks on NT
Jay Walters wrote: > Is there any way other than backup/restore to move a chunk on NT to > another disk. Can I move the root dbspace this way? > > TIA, Sure. Save data from the dbspace containing your chunk (dbexport, unload, onunload). Remove all data from the dbspace. Drop …
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…
DBSPACE Problem.
Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online…
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…
Restore to different chunk-paths?
Art S. Kagel wrote in message <37F28C5D.377EF0BE@bloomberg.net>... >I suppose Informix could give us an option to recreate the chunk list >using some file containing the new chunks ... Well, quite! But thanks for the reply. Neil…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
Re: How to do disk slicing on Sun stroEdge A3500 Boxes
--- "Art S. Kagel" <kagel@bloomberg.net> wrote: > sanjeev sagar wrote: > > > > SINGLE E10000 with 7 A3500 storage array which has > 14 internal > > controller and 24 GB RAM over 6 coserver. > > In other words have you divided the E10000 into six > separate CPU Domains > treating …
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…
which tables are in a specific dbspace?
Hello! How can I get, which tables are in a specific dbspace? thanks Gabor…
dbspaces on NT
Hello, somewhere I read :-)) that IX DBSPACE is limited to 2GB and NTFS to 4GB. I have 10GB HDD for Informix only (IDSWE 7.30) and PII server. Exists better solution than 5x 2GB NTFS? Thanks Leos…
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…
altering DBSpaces
I will be adding some chunks to a BLOB space this evening. In the past I had been told by Informix to run an oncheck command after changing DBSpaces but I cannot recall what flags for oncheck. Can anyone help me out?…
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.…
# of chunks for a dbspace !
Hi Users, In an Informix IDS 7.3 / SAP 4.5B environment what is the maximum number of chunks that can be assigned to a growing dbspace. Thanks in advance Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
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…
Contentets of a chunk
Hello, we are working with IDS 7.24.UC7 for AIX4.1.5. We use DBSPACETEMP=temp different of root dbspace. We have a problem with a chunk in root dbspace. Sometimes it grows until: chunk/dbs offset size free flags 6/1 0 25000 377 PO- a…
dbspace sizes
I am configuring a 7.3 IDS engine on a SUN box. I configured a 4 GB volume on 1 disk. I created a dbspace on the volume with the first chunk at offset 0 and a size of 2 GB (approximately). I try to add a second chunk, with an offset of 2GB and a size of 2GB but Informix won't …
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…
Drop chunks.
How can i drop a chunk. regards.…
Re: ISM on Informix 7.3UC8
Benny, ism installation is pretty straightforward and extremely simple if you go by the article attached below....I suggest you remove the following two directories /nsr and $INFORMIXDIR/ism and start from scratch with an ism_startup -init...;-)...if you yet have problems post th…
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
Sequencing chunk population in dbspace
Tom Smith wrote: > > I am using IDS 7.23 on Solaris 2.5.1. I have defined a dbspace with > three chunks and create a table in that dbspace. I then proceed to load > the table using a migration utility. How will the engine decide in > which chunk to store the data? It begins u…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Down Chunk
Gentlepersons: My understanding of Down Chunks is less than complete! I would invite comments or further explanations. On p. 13-15 of 7.3 Admin Guide, it says "You can prevent the database server from markng a dbspace as down while you investigate disabling I/O errors." 1) Ho…
No primary chunk
Hi, When restarting Informix, I received the following message, no primary chunk / bad primary chunk Does anybody know what the problem is? What procedures do I need to recover the data in the database? Many thanks. Sunny…
dbspace and the table
How can I identify in which dbaspaces the table is located?…
DBSPACE
Author : T.Jalaludeen E-mail : jala@hpsgm99.sgp.hp.com Hai, I created a database in INFOMRIX 7.23 - HP UX. I created tables also. But later I found thatthe transaction logging has not been turned ON for this database, so droped the database and created using "CREATE DATABASE <d…
Re: DBSPACE
"T.Jalaludeen" wrote: > > Author : T.Jalaludeen > E-mail : jala@hpsgm99.sgp.hp.com > > Hai, > I created a database in INFOMRIX 7.23 - HP UX. > I created tables also. But later I found thatthe > transaction logging has not been turned ON for this database, > so droped the databas…
Deleting a chunk
Dear Jonathan, Art, and Informix list friends: I saw a recent post to the list regarding deleting a chunk. My situation is this. We decided not to use a certain table in a dbspace any more. The dbspace now requires much less space. How do I get rid of a chunk or two? or is there…
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…
DBSPACE size
It is possible to create a rootdbspace during instalation larger than 30 Mb ?…
Cleaners
Please forgive me if this is posted twice ----------------- Online 7.24UC3 Solaris 2.5.1 Given that Cleaners are assigned to chunks in the order that the chunks are created (and I don't know the order) how can I determine which cleaner from onstat -F) is assined to which chunk? …
Re: Onbar and storage pools
When using ADSM, you define two management classes, with different storage pools on the ADSM side. Then, in the include file, you specify the databases (normally of the form /$INFORMIXSERVER/$INFORMIXSERVER/*/0) and list one management class. And specify the logs (of the form /…
Onbar and storage pools
Hi, I was wondering if it is possible to configure onbar to use different storage pools for data and logical logs when using onbar with ADSM (or anything else but ISM). The parameters ISM_DATA_POOL and ISM_LOG_POOL in the onconfig file certainly look like ISM specific. How does …
DBA problems
How long have you been a DBA Mukund??? The mirrored chunk always takes up the entire allocated size of the primary chunk, regardless of how much free space exists in the primary. You never look at the mirrored chunk for space usage metrics, use the corresponding primary chunk. …
follow up-- rename chunks
What do mean rename chunks? Do you want a new path for a chunk? The supported way of doing this would be to empty the chunk and then drop it and create a new chunk. Any other way could be dangerous leading to some corrupted chunk information. Brandon David Grove wrote in mes…
change chunk name
Could one change chunk name by editing the appropriate reserved pages (primary and mirror chunk pages-- 8th, 9th, 10th, & 11th reserved pages, I believe). David Grove…
Rename Dbspaces
Does anyone know of a safe way to rename a dbspace? I can't drop and recreate the dbspace, because it's the "home" for a database, and the database is too large for dbexport/dbimport.…
Dbspaces and indexes
Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI …
Chunk writes
Hi, I am in the process of creating the layout for a database. I will have 6 physical disks to work with (plus another 6 for mirroring). I understand that CLEANERS should be set to the number of disks, in this case 6. I also gather from messages that this scheme would perform op…
Empty dbspaces.
When I clear a dbspaces, solely in use for tables from tables with "alter fragment ...." then I see with onstat -d that the dbspace isn't completely empty however looking in the sysfragments tables for the datbases I found the dbspace isn't in used. Also oncheck -pt shows me that…
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…
Rename a dbspace
v7.24 UC6 on HP-UX 10.20: Does anyone know if this is simple? The reason I want to do so is that I need to move a large database from one server to another, with onunload/onload. There is a (glaring) bug in onload whereby you must load the database into a dbspace with the same…
tables in dbspace
Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
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…
Offline Chunks
Besides a bad spot on a disk what are others reasons for an informix partition to be put offline? Thanks -- Kenny Broezell Motorola Cellular Support Center e-mail: broezll@cig.mot.com 1501 Shure Drive phone : (847) 342-5633 Arlington Heights IL. 60004 …
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?…
Create DBSpace...
Hi folks, We're trying to automatize our database installation throughout hundreds of sites and it is straightforward to use onspaces command to create desired dbspaces. In an NT 4.0 (SP3) box with Informix 7.23 TC1, a 500 MB of dbspace can be created in as long as 20 *MINUTES*.…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
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…
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
unloading a dbspace
I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database which has tables spread across 9 dbspaces and two of them are smart blob spaces. What I would like to do is to unload each dbspace, copy the file to another instance of online to restore into a dbsp…
Re: Cooked Files
Go ahead and specify the offset. The additional chunk will overwrite neither files on the existing file system nor the tables in the existing cooked files so long as the chunk you are adding is for the same instance of Informix that you created the initial cooked file. Rene…
Re: Strange error in Informix
Try to put the name of the chunk in big LETTERS. Pascal…
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: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
Adding a Chunk
We are doing the rather mundane task of adding a chunk to a dbspace. Unfortunately we have very little experience with Informix because we only use it for one application called Permits by Sierra. Additionally since Informix runs so well, we rarely have any problems and we only h…
Re: Onbar
I understand your confusion --- took me a while to work thru this error. You have to: 1. create a directory on your hard drive. 2. go to ISM and define a device of type file, and point it to the directory 3. then hilite the device in ISM and 'label' the "volume" as belonging…
Re: Onbar
I understand your confusion --- took me a while to work thru this error. You have to: 1. create a directory on your hard drive. 2. go to ISM and define a device of type file, and point it to the directory 3. then hilite the device in ISM and 'label' the "volume" as belonging…
Re: Onbar
I understand your confusion --- took me a while to work thru this error. You have to: 1. create a directory on your hard drive. 2. go to ISM and define a device of type file, and point it to the directory 3. then hilite the device in ISM and 'label' the "volume" as belonging…
Onbar
We face a problem for which we don't know the solution. We are using Informix Dynamic Server 7.30TC3 on a Win NT 4.0 computer. Whenever we try to use onbar -b -w -L 0 the Informix Storage Manager gives the following error message: media waiting event: bachup to pool 'ISMData' wa…
chunk permissions
Hello Everyone, Im getting the following message in my server log, but the file permissions are set to informix, informix. Any ideas ? The chunk '/u3/GAP/informix/dbspaces/rootgapdbs' must have owner-ID and group-ID set to informix. -rwxrwxrwx 1 informix informix 0 S…
Re: Moving Chunks
Perhaps a "hindsight". I use Unix/AIX llinks for all my chunks, including root space. Then If I need to move, you only have to change the link after physically moving the chunk. Works great for cooked space.…
Moving Chunks
I have an Informix Database on cooked disk space. Now I would like to change the path to the chunks (datafiles). Is there any way except unload/load the whole data? Yours Sigrid Ehrenreich seh@carus.de…
Chunk down
The Online Admin guide for Informix says that if a chunk is down, to "Use UNIX utilities to determine what is wrong with the down chunk and then to correct the problem and bring the chunk back to on-line mode." Can someone expand on this and suggest what UNIX utilities are perti…
Re: rearranging chunks
In article <6rjg9i$obl$1@news.uni-lj.si>, zdravc@fe.uni-lj.si (Zdravko Balorda) wrote: > Hi, > > is there a way to rearrange disk partitions and > chunks once dbspaces are initialized and data > loaded? I am not quite happy with what i did. > I want to, say, copy a chunk to ano…
rearranging chunks
Hi, is there a way to rearrange disk partitions and chunks once dbspaces are initialized and data loaded? I am not quite happy with what i did. I want to, say, copy a chunk to another one so that the first one could be dropped. Or is this chunk layout frozen, once you created i…
Move chunks
Hi all, I have IUS 9.x on an Ultra 1 box, running Solaris 2.5. I want to move the chunks of all of my dbspaces to another disk. Chunks are stored into cooked files. I thought that if I move them to my new disk and create some symbolic links (with same names as the original cooked…
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 …
Re: Help on Onbar
Nicola Terenzi wrote: > > Hello, > when trying to use ONBAR from IECC client we are getting the following > error: > can't find /usr/lib/ibsad001.so. > Where can we get it ? Do we have to buy an additional backup software ? > We are using IDS 7.3 on Solaris 2.5.1 > What storage …
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: onbar and legato
Hi David I had similar problems about 6 weeks back with IUS 9.13, Informix were saying it was Legato and vice-versa, I now have it working, my problems centered around setting up the pools, label templates etc on the Legato server. Once these are done, there are many more enviro…
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: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
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…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
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…
dbspace question
Currently my dbspace is spread over 5 different chunks on several small and slow hard-disks. After replacing these disks with a larger and faster one, is it a good idea to merge the small chunks into one large chunk ? If yes, is there an easy way to do that ? Detlef Liem…
Down Chunk
Is there a way to drop a down chunk from a dbspace which has only one chunk? The down chunk is a cooked file which has been removed from the file system. When I tried to drop the dbspace which contains only one chunk, onmonitor returns with an error (ISAM error: Unexpected inte…
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: +…
Coalesce Chunks
Hi, A dbspace has 3 chunks.These three chunks are on different disks.I want to place the three chunks contiguosly on another disk.How to go about doing this ? Dbexport/Dbimport works at Database levels only i believe. TIA, Sathish _____________________________________________…
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…
Sizing dbspaces
Does anyone have any recommendation or guidelines we can use in determining a base sizing strategy for rootdbs and physicaldbs. I am most conerned about physicaldbs. I used the formula in the Admin guide to determine a size for physicaldbs but I am not sure if the result was in…
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…
corrupt dbspace
I am running Informix ODS 7.22 on AIX V 4.1. I accidentally removed a file from AIX that Informix ODS had listed as a chunk in a dbspace (that I was about to remove anyway). I don't back the system up since it is our test system. All I want to do is remove the dbspace and all…
Create Index Problem.....
Hi, I've created one databse in a perticular dbspace with one table. If I create an index on that table using 'in dbspace' clause, sysextents table in sysmaster database reports it But if I create the same index without 'in dbspace' clause, it doesn't report it. Why ? ? Abhay …
dbspaces question ....
Hi, Environment : OSD 7.23uc4 HP-UX 10.20 We have all 2Gb disk chunks ( told by Unix Admin to me ). I tried to run onspaces command for the size more than this and I found that I can allocate 2.048Gb Also existing allocation of disk space leaves gaps of few Mb in be…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Dbspace Question ----
Hi, If there are 2 informix servers on one machine and I create a dbspace for the first server which overlaps one of the dbspaces for the second, what will happen ? Does it gives error or I'll loose the data ? Thanks in advance. Abhay Mannur.…
Re: How can I create DBSCAPES in 20GB RAW partition
: Anyway a dbspace can have as many chunks as needed and the 7.xx engines : support 1024 chunks or 2TB. Chunks can be less than 2GB and the actually, the limit is much larger. i'm not sure that there is one. as you allocate more chunks, the system allocates more pages to the…
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.…
Database DBSpace
I have a database created in a non-root dbspace. I would like to relocate the database, not any tables, to another dbspace without unloading/exporting the database. Is it possible to relocate a database to another dbspace? Mark Baumgartner Cardinal Health…
chunk archiving
hello everybody!! i've got the very common problem of archiving out of date data, let's say the production data older than 3 years. my plan was like this: grouping the data onto yearly changing dbspaces like ar1997, ar1998 ... each dbspace is designated to a distinct chunk, whic…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
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: the new bie with the share memory problem
SaTriGuy wrote: > > Is the chunk's name /work/data or /work/data/root_chunk ? > Madison Pruet Can you 'dd' this chunk as informix?…
Re: the new bie with the share memory problem
Is the chunk's name /work/data or /work/data/root_chunk ? Madison Pruet…
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…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Chunk Writes
Hi, I have been reading the "online Dyn. Server Sys. Adm 1" training mtrl -by Cindy Lee Dowling,Elizabeth Suto. Chapter 10 -270 which discusses Chunk Writes. it says " All modified buffers are flushed to disk.The page cleaner threads read thro' the buffer headers looking for…
Deleting Chunk..
Hello Everybody., We are working on Informix Online 5.03 on HP-UX 10.10. I have a DBSpace which has a chunk. I need to remove this chunk from the DBSPACE. Is there way do that. -------------------------------------------------------------------- RSAM Version 5.03.UC5X1 -- On-Lin…
invalid dbspace
I have been receiving this message for awhile..it hasn't seemed to affect normal functionality...but, I still would love to know what this message means: Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. lrwxr-xr-x 1 informix informix 19 Oct 16 1996 tmpdbs -> /d…
Re: Changing size of RAW space
Curt Narvesen wrote: > > I inherited an Informix database that has a large chunk of space allocated as > raw. Is there any way decrease the amount of space allocated as raw without > unloading the database? I am running version 7.1 No there is no way to reduce the size of a sing…
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…
Tables on a particular chunk.
I'm looking for a query which will list all the tables which spill over onto a particular chunk. I am able to list all tables on that dbspace, but this dbspace has two chunks to it, and I want to know which tables are on the second chunk. Any help would be greatly appreciated. …
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: Droping an unused chunk
Hi Chris, Winson Kwok wrote: > > Dear Gurus, > > If I have a chunk that's not used (but added to the dbs) is it possible > to drop it to free space. Starting with version 7.x there is a way to drop unused chunks, if the chunk to be dropped is not the primary chunk of a dbspace …
Where is dbspace?
On a raw disk(instance product) I created a database test. On other instance(training) on the same raw disk and fisical area other database with thehe same name was created. I deleted the second database and dbspace but on the first instance I can't access, drop the database tes…
Patching Chunks
I am looking for a tool or utility that informix seems to have. I need to be able to patch chunk headers on the raw devices. Platform: DEC ALPHA os: 3.2G db: On-line 7.12uc1x8 Please email me : mdeegan@logistix.com -------------------==== Posted via Deja News ====-------------…
Re: Cleaners-Mirror and Temporary Chunks
Milan Vesely wrote: > > According to Informix chunks should be added to system > in a successive way - to be cleaned correctly by > CLEANERS. The number of CLEANERS should be the same > as the number of disks to be cleaned. > But: How to consider TEMPORARY and MIRROR chunks? > …
Re: 48 out of 58 chunks down
Is it possible that the CHUNKS paramater in your tbconfig file got changed to 10 during the upgrade? This parameter sepcifies how many chunks the instance will support. HTH, Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com…
root dbspace
I have a test machine running Online 7.1. On performing a VERY large query I received an error message saying that there was no free disk space to write sorted rows into a temporary table. On examining the space available in the rootdbs 32252 pages remained out of 575000. I sh…
Dropping a dbspace.
We are trying to drop a bad chunk. The chunk is a cooked file and is the only chunk in that dbspace. When I try to drop the chunk I get the following message. % onspaces -d ch_dbspace1 WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The…
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
creating a chunk
system: sco unix 3.2.4.whatever db: informix online 5.03 usage: testing system Problem: system had recent disk problem. Reinstall started but no recent system backups could be located - at least not complete. root filesystem pieced backed together. Now missing cookedspace…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
Re: Online V7 and Parallel Queries
> > Is it true that PDQ, parallel queries in OnLine V7.x will use both > primary chunks and mirror chunks to retrieve data concurrently when > performing a query expected to return large volumes of data??? > It is true Michael Strother…
Drop db chunk
At one time, I accidentally add a chunk to a wrong dbspace. Is there a way to remove this wrongly added chunk so that the chunk may be allocated to the right dbspace? Edmund To an Informix novice Chinese University of HK…
AW: What happens when ?
Hi, One possible solution is to dump the correct dbspaces with dd on tape. After restoring the correct archive, it might be possible to overwrite the restored dbspaces by dumping the dbspaces back.(This works with Infomix 5, maybe with 7) Robert…
Fraged Tables/Onunload 7.13uc1
If a table is fraged across multiple dbspaces, and the indexes are created in a different dbspaces of its own, will onload work successfully if the table was droped and then reloaded? I know I can specify the dbspaces in which I want to load the table on the command line, but wh…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Informix v7.x Problem on Digital Unix: 2GB Limit
I think that you can solve the problem by creating a dbspace composed by 2 or more chunks of 2 Gb. Then, when you create the database you must specify this special dbspace. The load of the information will work fine! Bye Paulo Nunes (p.nunes@mail.telepac.pt)…
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
Re: Primary chunk - a misnomer
Keith Fang (fang@netcom.com) wrote: : >The chunks are known as primary chunk for the first chunk : >in a dbspace and secondary chunk for any additional chunks added. : >(This is not an exact quote, to avoid possible copyright infringements.) : > : >Bunk. Bull. Incorrect. : > : >…
Primary chunk - a misnomer
I was reading in the "Informix Systems Journal" dated July/August 1995. In particular, I was reading the excerpt from Joe Lumbley's book in this issue. He makes the following claim: The chunks are known as primary chunk for the first chunk in a dbspace and secondary chunk for an…
Re: Online 5.1, How to remove a chunk
Hi, You have to drop the dbspace in order to free up the chunk and the dbspace has to be empty when you drop it. Thanks Ryan…
Re: Online 5.1, How to remove a chunk
You can't remove a chunk in version 5.x. This is possible in version 7.x. If the chunk is in a non-rootdbs dbspace, you could remove all data from the dbspace, then drop the dbspace to reclaim chunks.…
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…
down chunks
Dear Calvin, About your question below. I have had a similar thing happen when a chunk was marked as down due to the UNIX file table overflowing. I was able to change the chunk status using dd and writing over the reserved pages. Hope this helps. But - this should only be done …
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?…
Find names of all databases in a DBSPACE
Is there a way to get a list of all of the databases in a dbspace? My dbspace is very dynamic and I need a way to get this list. Using Informix Online 5.x on Sun Sparc SunOS 4.1.3c David Clough…
dbspace Q
i am looking for any pgms that might help monitor "space hogs". it would be nice to be able to get a listing of databases found under a specific DBSPACE along with its owner and size. i thought i saw a news thread along this topic a few months ago. thanks, jim ________…
Re: Mirroring
Ti Lian Hwang writes: |We have a new HP9000 machine with 2 fast SCSI disks and 2 slower |disks. | |We are using informix mirroring on them. | |Is there advantages or disadvantages if the mirror copies are both |in the in the slow disks, or a mix of slow and fast disks ? | |I mea…
Mirroring
We have a new HP9000 machine with 2 fast SCSI disks and 2 slower disks. We are using informix mirroring on them. Is there advantages or disadvantages if the mirror copies are both in the in the slow disks, or a mix of slow and fast disks ? I mean Disk A (slow) Disk B …
remote dbspace
Is anybody define a dbspace on a remote machine...!!! with online 5.0. Thanks...…
mirrored chunks
Help please. We are running Online 5.02 for Interactive Unix. All of our database chunks (we have 11) are mirrored. Twice in the past four months, chunks have gone off line and we have had to restore from tape. Why would the mirrored chunk not have been used instead? When the c…
pathname of chunk
I recently changed the disk array which makes up my 1 raw device (1 chunk) with my rootdbspace and another dbspace. The chunk is slightly bigger than the one it replaced. 2 gig now instead of 1.8 gig. I dbexported the database before replacing the disk array, then re initialized …
dbspace lost
Platform: Everex 486 running Interactive 3.2 and Informix Online 4.00.UE1. Recently, we took a power hit that caused some damage to our file system. Specifically, the device file Informix writes to was lost. Should I reinstall Online or can I just re-create the device file? Al…
Prevent users from creating databases?
Is there any way to prevent users from creating databases? Or at least to prevent them from creating databases in the system dbspace? Or even a way to change the default place for databases from system dbspace to another dbspace? Thanks in advance. -- Rick Hamel Database Admi…
tables in dbspace (Online 5.x)
Is there a simple way to find which tables are in a dbspace? (Or, what dbspace a table is in?) -Brian ------ brena@hcia.com…
DBspace Question
I'm looking for a way in a sql statement to have on-line return me based on a given table name the dbspace name that the table is located in. The following sql statment returns the dbspace number the table is located in but what I need is the actual dbspace name. select h…
dbspace for database
Yes I know I have antique software, and yes I am sure you've answered this before...but I need to know now, and cannot find it in Walt's excellent archives... On a UNisys 5000 platform, running Turbo with 2.10.03G SQL... 2 databases were created. tbmonitor shows rootdbs, and 2 o…
Default dbspace?
This has probably already been discussed to death, so please reply by e-mail. Is there a way with OnLine v4.0 or v4.1 to make the default dbspace something other than the root dbspace? Thanks. -- +--------------------+-------------------------------------------------------+ |…
Re: Performance in chunk vs. chunks?
>From: uunet!neptune.dsc.com!jbh (J. B. Hendrix) >Message-Id: <jbh.705287859@neptune> >Subject: Performance in chunk vs. chunks? >Date: 8 May 92 01:17:39 GMT >X-Informix-List-Id: <news.1216> > >My boss from the old school is concerned that a heavily used >DB spread across multipl…
Performance in chunk vs. chunks?
My boss from the old school is concerned that a heavily used DB spread across multiple chunks on separate partitions in the same disk will suffer performance degradation as compared to a single chunk for the whole DB (obviously a large chunk, about 150 Meg). My cohorts and I hav…
dropping a chunk
>A client of of ours was playing with OnLine, and created a chunk on the >cooked file system. When he was done, he decided "Okay, I'm through." >and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace >inside of OnLine. So now he has a dbspace that OnLine thi…
Cooked dbspace...
A client of of ours was playing with OnLine, and created a chunk on the cooked file system. When he was done, he decided "Okay, I'm through." and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace inside of OnLine. So now he has a dbspace that OnLine thinks …
Dropping a dbspace
Hello, I am currently using the Informix Turbo engine. I tried to drop a dbspace the other day and couldn't do. Does anybody have info on how to do this? Thanks ! Brian MacWilliams USAMC - SIMA LEAD CHAMBERSBURG PA…