Oninit® Archive
Results for “AUTOLOCATE”
EMC Data Domain and Informix
Mark, Good morning. I use Informix IDS 12.10.FC5W with EMC Networker 8.3.2 with a EMC Data-Domain DD670. I use onbar to backup to the Data Domain via Networker. The Data-Domain itself isn't a storage-manager, I use Networker as the storage-manage and the Data-Domain as the stor…
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…
Encryption/compression of backups
Is onbar the only informix tool that will do compression and/or encryption of the data being backed up? Can onbar do that with the basic ISM, or do you have to purchase a storage manager from another vendor (Legato, Tivoli, etc.)? What type of encryption does the base ISM use?…
Table /fragment size monitoring
That is correct, if you want the partition name and/or the fragment expression. That info is not in sysmaster but only in the sysfragments table in each individual database. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com --------------------------…
Columns in ixbar file
Hi, The ixbar file does not have to be empty. Be aware though if onsmsync cannot access any of the storage manager entries it finds (Not sure if that is in the sql tables or the ixbar file) e.g. if security on the storage manager is misconfigured and blocks access then it will e…
Onbar: Failed to determine archive's encryption mode. Error code 2
HI Jacob, Try BAR_DEBUG 5 and if that does not help then BAR_DEBUG 9!! Also check the storage manager logs for a clue. Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Flutter London ------------------------------…
How to verify all the requirements for an onbar restore
Well, that sounds like progress! You still have the logical recovery to go, but fingers crossed it works. If you have no visibility into the storage manager itself then the process can be frustrating. Note that you can use BAR_MAX_RESTORE to restore multiple spaces in parallel …
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 ------------------------------…
sysmaster/systabnames not refreshing
There are some situations where temp tables are not physically deleted from storage when they are dropped. In those cases bouncing the engine will cause the engine to clean them up during fast recovery. Art ------------------------------ Art S. Kagel, President and Principal Cons…
Want to DROP an empty rootdbs chunk
Server Studio (see screen shot pasted below) shows a fair amount of fragmentation (disk fragmentation, not Informix fragmentation) in the rootdbs (i.e. chunks 1 & 8). Since table extents are contiguous, to avoid having to create dozens or hundreds of small tables, should I repac…
Index creation strategy when autolocate is set
Hello All, If autolocate is set to a value greater than 1, the table is created with a round-robin schema, but indexes cannot be created with a round-robin schema. I would like to know if there are any best practices on how to create indexes in a database that is set to autolocat…
How to check autolocate settings ?
Hello All, After setting AUTOLOCATE of onconfig to 3 as shown below, I set the location of the database using the administration API. The table seems to be successfully created in the specified dbspaces, but sysmaster:sysautolocate does not show the specified dbspace list. Is thi…
A bit more clarity on LEVEL 1 backups
Quite generally, as the backup side falls into two parts, the 'physical' spaces backup (a snapshot of the used parts of your chunks - as simple as that) and the 'logical logs' backups, also the restore would first perform so called physical restore which is copying back that snap…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
Index page size recommendations
Mark: Oh, say it isn't so! Deduplication storage of database chunks? AAAAAAAAAAAAAAAAA Not only is this less than safe, because of the way databases are stored and updated, the likelihood that deduplication is saving you even a small percentage of storage cost is so small that I …
Validate backup : archecker –tdsv and CommVault
Validation is far more involved than a restore is, so it should be faster. However, look at the IO rate! 41gb/hour is about 0.7gb/min or 130mb/sec which is about half the transfer rate of a single 5000rpm spindle drive. So the storage itself or the storage manager you are using a…
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…
Autolocate
I have written a deep-dive blog post, which you may be interested in reading, on the relatively new AUTOLOCATE feature. It is a lot more far-reaching than it seems from just reading the manual. (With thanks to HCL Support for initially pointing out its use.) https://informixdba.w…
Table and index defragment
@Sergio Peres I haven't read the parallel thread, but doesn't "ALTER FRAGMENT <table name> INIT IN < dbspace name>;" not do it for you? ------------------------------ Kirit Rana ------------------------------…
RE: The rowid column does not exist in the user table.
Oops ... I was mistaken because AUTOLOCATE was set to 3 and created as a fragment table. Thanks for the reply. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------…
The rowid column does not exist in the user table.
Yes Paul. The table is fragmented by AUTOLOCATE feature. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------…
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…
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…
row limit for fragment table with rowids
Hi, What is number of rows limit for fragmented table created with rowids option? I'm using IDS 11.50FC. Regards, Direk…
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.…
storesdemo
see new AUTOLOCATE configuration parameter - in docs as well as in your onconfig.…
XBSA Error: (BSAGetObject) during restore
Hi John, I think you never mentioned which storage manager is being used - can you elaborate on this? Please also include Informix version and platform information. Andreas…
Retoring the onbar backup
onbar sends its backup data to a storage manager system of some kind, so first onbar on target system must get access to that storage manager and data. I'd say search the web for 'onbar imported restore', that's basically what you're trying to achieve. From: "KAMALAKARA YADAV" …
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…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Informix Storage Manager
Hi all, I am trying to configure ISM (Informix 11.70.FC4 on AIX 6.1) to use ON-Bar. After ISM startup (# ism_stratup -init), I have the following error when I execute "ism_add -admin username@servername" : ism_add: RPC error, Program not registered. Could anyone help me solve …
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…
dbimport don't use all available dbspace
OK, you have two problems: 1 - You probably did not use the -ss flag when you ran dbexport so the correct dbspaces for the tables and indexes are not included in the schema file. That's OK if you want to load the database into different dbspaces than the original one(s). 2 - Yo…
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…
onbar and IBM primary storage manager
IDS12.10 FC4, RedHat Linux . We have bee using Ontape for backup successfully and happily since the beginning . Because databases are growing larger and larger, I am looking for Onbar now. Just want to confirm a understanding concept, PSM ( Primary Storage Manager) is just a …
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…
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.…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
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,…
Error -225 when configuring RSS
Jose: The error codes indicate that one of the system catalog tables (probably systables) could not be created because of a problem with the dbspace it was being created in. Check to see that the root dbspace has sufficient space to hold the sysha database if you do not have AUT…
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. ~ …
Attach fragment from a table in another database
Hi Folks (capitalized! :-) My client just asked me the wildest question: > if there is a fragment associated with one database like dbase_1@my_server, > can that fragment be detached and moved to another table on another database > like dbase_2@myserver? Actually, he asked if…
query to find partition size in fragmented table
How can we find the size of a partitioned table in term of extents or pages allocated. For non-fragmented tables we can get the results as provided in following link: http://www.informix.com.ua/articles/sysmast/sysmast.htm But these queries do not work for fragmented tables.…
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…
Informix V12 Fragmentation
In previous versions of Informix IDS - I believe that if you included a 'remainder' clause in a table fragmentation statement, that queries over that table would not have any fragment elimination (assuming that a where clause has filters that matched fragmentation scheme). Is tha…
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…
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?…
alter fragmented table
Hi, We have a table with 105 million records and is fragmented across 4 dbspaces. We are trying to alter 3 columns in the table from char(12) to char(15). when we run the alter statement, it runs for more than an hour but doesnt complete. Can you please suggest alternative to al…
Optimising index builds
>> How are the tables fragmented? How much memory can PDQ 100% allocate? 1. Round-robin 2. I assume it is constrained by SHMVIRTSIZE, which is 24000000? Thx Neil…
external restore 9.40.FC8X3
Reinhard, The answer to your question is going to be that you cannot mix onbar level 0 with logical logs backed up using ontape. This IDS version should have the built in ISM (Informix Storage Manager)...so you could backup the logs to disk using onbar/ISM. Mark…
Logical logs - push or pull?
Thanks for the responses. Personally, I wouldn't do it any other way than to use ALARMPROGRAM and push the logs to the storage manager as they fill. But I'm the "new guy" here so it helps to have other opinions to back up my decisions. Thanks.…
onbar -v
IDS 11.50FC6 on AIX 5.3. I've taken over management of a newly-migrated system. It's not that big, perhaps 300GB distributed across a bumper 106 dbspaces. It's backed up with onbar using Netbackup. A level 0 takes about an hour. We're required to run a "verify". This is taking…
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.…
informix 11.70 growth edition features
Hi, i have installed informix 11.70 growth edition, is there any possibility to use the remote database query feature and fragment tables feature with this version. Thanks Pushpa…
lock table on a fragmented table
Hi, I have some fragmented tables (by round robin and by expression) I realized that the sentence: lock table <table> in exclusive mode; locks only one fragment. For example: database sysmaster; select hex(a.ti_partnum) from systabinfo a, systabnames b where a.ti_partnum = b.par…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Dual Onbar Archive
Is there a way to stream onbar output to multiple storage manager nodes? We'd like to redundantly store Informix backups. Using IDS 11.70.FC4 on RHEL5.8 with Tivoli Storage Manager (version unknown).…
Fragmented tables
Hi, Is there a way (a sql script maybe) that would create a list of all tables in a database that are fragmented and what fragmentation expression was used without going through dbaccess,table,info,fragment menu? I can do this using dbschema on a specific table but only for tho…
Table Partitioning
Is it possible to partition/fragment a table while keeping it in a single tablespace.…
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…
WHere did my data go?!
IBM Informix Dynamic Server Version 11.50.FC8W2XB on Solaris: I fragmented a table into multiple dbspaces to see how long it would take. No problems with all this, all 64 million rows fragmented, about 16m into each database: set pdqpriority 95 ; alter fragment on table <tablen…
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 …
Best way to move table contents to another
can i attach the fragment to another table? afterwards? Thanks…
Segregation of indexes in separate dbspaces still valid?
As a budding Informix DBA in the last century, I was told that placing indexes in a dbspace dedicated only to indexes and apart from the table's data enhanced performance. Is this still true? Even with the advent of SAN technology? and using Informix fragmentation (data partiti…
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 …
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…
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…
Advantages of Fragmenting Across DBSpaces
Is there any advantage to spreading table fragments across distinct dbspaces if bulk storage is managed via SAN?…
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 …
can't attach fragment if surviving tab has primary
is it true that I can't attach fragment if surviving table has primary key? it it seems like I must do drop, attach fragment & recreate a primary key. Is there a way to bypass that? it is time consuming and cumbersome…
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.…
Fragmented Tables Information
Hi all, i m new to informix, i have many fragmented and non fragmented tables in my db. Requirement 1: i want to just display the fragmented tables Requirement 2: i want to display only those fragemented tables which are closed to finish their fragments For example i have follow…
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.…
FInd Row Id in Partition Table
Hi, How can we identify RowId for a Partition/Fragmented Table in IDS 11.50.FC6. Thanks.…
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…
Explanation of performance improvement
Paul Ridding Wrote: ============================================================================= ...snip... So, finally to my question... Could the moving and fragmenting of this large table (about 1/3 of the overall database size) account for such a massive response time improv…
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…
Can I Move a Fragment?
Good Morning people, Is it possible to detach a fragment from a fragmented table and reattach it to another dbspace? IDS 11.50.FC5 on AIX 5.3. thanx, dan…
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…
storage manager options
Hi, We've just found out that our storage manager (Netbackup) doesn't suport IDS 11.5 on Solaris X64 (even though we were verbally assured by their sales rep that they did at the time we purchased the new hardware platform). Would anyone know of any possible alternative? Maybe …
Table Fragmentation
Hi! I have an historic table (5 months) with about 30 millions record per month. Our primary problem is that deleting old data takes too long (we have some indexes in that table). So I start making some tests with fragmentation. I fragment my table with a date expression (monthly…
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…
Move table from rootdbs to a different dbspace
Thank you very much Art. I will check this command.. ALTER FRAGMENT ON TABLE tablename INIT IN dbspace1;…
Fragmentation of Table
Hi All, We have huge table that will save old data into that table. How should i fragment that table so that it will have any bottleneck on the DB?…
Commvault Storage Manager
IDS 10.00.UC8 Solaris 10 Commvault 8.0 We just changed storage managers, moving from Netbackup to Commvault. Our backups and restores run fine when started from the Admin Console on a Windows server but when I try to start a backup or restore from the cmd line on my Sun box the …
Extents Monitoring
Hi, Can we increase the number of pages for a single fragment ? Or is it the only way to survive this type of scenario by having our table in multiple fragments ! Regards Kasi…
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…
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."…
dbspace utilisation in Informix 5x
Hi Bob, Thanks for your advice. But in case the table is fragmented among multiple dbspaces in v7 or v5 (dont know whether fragmentation is supported in v5), how can we identify that? Prabal…
TABLE AN INDEX REORG
Fragmenting a table by month using 12 fragments to hold 24 months of data is not the most efficient method. I have a much larger table with many more fragments. When it comes time to purge data, I delete all rows from the fragment and then drop the fragment. The released fragment…
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…
Storage Managers for onbar
Hello to all. My last post to this forum dealt with using ontape to perform archives to disk. My management decided that no point in time restores with ontape is too much of a sacrifice and said we needed to continue using onbar. We have used BMC's SQL-BackTrack (now known as Re…
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 …
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 ?…
Re: retrieving data from the table in chunks for paging
If the table is not fragmented then use the hidded "rowid" column. select * from invoice where rowid between 0 and 100; If the table has fragments you might be lucky in that it was created "with rowids". L.S.…
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…
Tivoli with IDS 10FC9 and IDS 11.5 on aix
Hi everyone. In the release notes for IDS 10FC9 and IDS 11.5 (for AIX) there is mention of the "recommended" version of Tivoli as in... "Recommended versions of other IBM products that work with IDS, but are distributed separately: Tivoli Storage Manager 5.4 and Tivoli Storage M…
Anyone had IBM storage to mirror informix data experience?
IBM storage reseller told me that use two storage system can be separated at the distance of 5 kilometers. That is why I intend to use it for DR. I am wondering If I use Volumn Copy and then Diaster happen , all the data will be same as the before. By the way, I don't like to …
Remove onbar expired images
Informix DBA wrote: > Hello theBP, > > Yes I got your other email/post and I have read up on the > documentation. However, none of those onsmsync commands work. Informix > support is still looking into. > > Which Storage Manager have you seen the onsmsync work with? We are > u…
fragmented table and pdq
In testing we want to play with testing of setting pdq to 5 across the board, we have always run pdq at - except when indexing or updating stats. What we found when pdq is set this sql does not stop at the first 5000 records. IDS is 11.5.FC3 Os is Solaris 10 set pdqpriority 5;…
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…
Informix Storage Manager ISM
Recently I was speaking with some one from IBM who mentioned that ISM (aka Legato Lite) will be removed from IDS sometime in the future. Does anyone know when and what IBM plans on replacing it with? Thanks Peter…
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…
insert performance on fragmented table
I'm running IDS 10.0.FC6. I fragmented the glpca table in my SAP database into 2 fragments by round robin. The fragments started to reach the 32 GB limit. So I added another dbspace. Now the first two fragments have reached the 32 GB limit and are no longer being written to. The …
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Expansion of round-robin fragmentation
Hi all, we have to change the fragmentation strategy of a fragmented table. The present strategy is round-robin with 5 fragments. Because the limit of 16777216 pages per fragment of the table in question will be reached soon we consider to change the round-robin strategy to e.g.…
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…
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…
Re: Moving a table
I think this is what your looking for... alter fragment on table <mytable> init in <newdbspace>…
onbar portability issues?
It depends on the capabilities of the storage manger you are using. If you are using a storage manager, the steps are listed below: 1) install storage manager client on new host 2) register client with storage manager 3) restore or copy the following files $INFORMIXDIR/etc/ixbar…
Informix backup fails.
Hi, I am trying to take backup of my Informix database using the Onbar but the backup fails, I cheked the bar_act.log file I found the following :- BACKUP & VERIFICATION ===================== For IBM Informix Dynamic Server: -b [-L <level>] [-w | -f <filename> | <spaces>] [-O]…
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…
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…
WARNING: BAR_TIMEOUT Storage Manager Progress may
I've been using Legato as storage manager to back up Informix 10 and i've been finding the warning below, but when this come up, the backup doesn't go on any more, any body know what is happening and what can i du to solve this problem. It is happening very frequently, 2007-09-…
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 …
fragment by parent table
HI, Folks, We face this problem, We have two big tables : tab_p and tab_c tab_p( id serial, create_dt datetime year to seconds, ...... ) tab_c( id integer , /*foreign key reference tab_p's id*/ ...... ) Challenges, (1) the tables grow fast, 50 million rows/year, it will k…
Re: Research into onbar
Tivoli Storage manager for Databases : http://www.ibm.com/software/tivoli/products/storage-mgr-db/ Note it works with a number of well known databases…
IDS 9.4
Dear Mr. Clifton, I have checked the table with oncheck -cIx and the following is the response, which is repeated many times. Validating indexes for baj:swx.log_record... Index dev_pri_tran Index fragment in DBspace bajdbs Index duptran Index fragment in DBspace bajdbs Ind…
Research into onbar
In my experience of "emergencies" onbar is find but ISM has its limitations. ISM is "legato light" and is really only intended for backup and recover on a standalone system If clients have other business requirements then they should look at "proper" archive and storage managers…
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/…
Re: Should I wait for IDS 11?
[snip] > > All I really need is a version of ontape that can backup dbspace in > parallel. > > Sybase can use multiple stripes. > I believe DB2 can backup in parallel > > Why can't Informix without the complexity of a Storage Manager? > what, are you asking for onarchive?! that a…
TSM and IDS - Any suggestions for best performance?
These are all just my opinion, right? "Andrew Ford" <aford@networkip.net> wrote in message news:mailman.105.1180990147.13675.informix-list@iiug.org... > 1. Backup IDS directly to the tape storage pool or backup to disk and > have TSM migrate to storage in the background? Most…
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…
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…
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…
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…
Moving logical logs backup to disk
gsturkenboom@lic.co.nz wrote: > Hi, > > Does anyone know how to redirect our logical logs backup from tape to > disk? We currently use a storage manager and onbar and a seperate server > with tape drive for this purpose. The sys admin guys want to retire the > seperate server wit…
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 …
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Fragment by expression and extent size
Hi, When I try to fragment a table, how to specify the extent size and next extent size. Thanks Sven…
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…
Re: onbar without storage manager?
Desmodromic wrote: > Can I use onbar to backup an Informix instance without using a storage > manager? The Informix instance uses raw device for dbspaces. What I > want to do is use onbar to backup the raw devices to regular UNIX files > and then back these files up to tape. The …
Re: onbar without storage manager?
Hi, you may also want to look at external backup and restore (see the "Backup and Restore Guide" manual for more info). If you do log backup, then external backup and restore with onbar offers you a more consistent interface for the restore scenario. However you cannot use onb…
onbar without storage manager?
Can I use onbar to backup an Informix instance without using a storage manager? The Informix instance uses raw device for dbspaces. What I want to do is use onbar to backup the raw devices to regular UNIX files and then back these files up to tape. The reason being is that a thir…
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…
Fragmented tables with ROWID's and HPL
How do I configure HPL to import an HPL generated unload file into a table that is now fragmented with rowid's? Everything I have tried just gives me errors. Thanks Peter…
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…
refragging a table
We have a table that is fragmented by the token, which is a serial datatype. The last fragment has grown too big so we want to make more fragments. Can I just get the max(token) and add a fragment with the expression: (( token > maxtoken ) AND (token <= some other number) ) or d…
RE: Fragmentation questions involving Primary Keys and unique indexes
There are restrictions on creating indexes on fragmented table: it is only possible to create a unique fragmented index if it contains the fragmentation column (columns). There are three possible approaches to creating Primary key on a fragmented table: 1. create Primary key wit…
Re: Fragmentation questions involving Primary Keys and unique indexes
Zev Berezin wrote: > Hi All, > > > > Tech Specs: O/S Solaris 9 � IDS 7.31.FD7 > > > > I was playing around with fragmentation recently when I came across a > couple of interesting questions. > > > > Question 1) > > I came across a seemingly inconsistency when fragmenting a t…
Re: Fragmentation questions involving Primary Keys and unique indexes
Zev Berezin wrote: > Hi All, > > > > Tech Specs: O/S Solaris 9 – IDS 7.31.FD7 > > > > I was playing around with fragmentation recently when I came across a > couple of interesting questions. > > > > Question 1) > > I came across a seemingly inconsistency when fragmenting a tab…
Fragmentation questions involving Primary Keys and unique indexes
Hi All, Tech Specs: O/S Solaris 9 - IDS 7.31.FD7 I was playing around with fragmentation recently when I came across a couple of interesting questions. Question 1) I came across a seemingly inconsistency when fragmenting a table that contained a Primary Key using a fragment…
alter fragment question
actv20@gmail.com wrote: > Hi all > > I have a table that is currently fragmented across two dbspaces and has > reached the page limit for a single dbspace (16,000,000 pages). I need > to add additional dbspaces to the fragmentation scheme and I was > intending to fragment across …
compaer LOAD and ALTER... ATTACH
HI, I am using IDS9.4 and attaching a fragment to a fragmented table. The table has two indexes are fragmented by default. I found, (1) ALTER FRAGMENT ON table ATTACH... is very resource consuming, slow and failed (complained : No More Space). I also found it wrote and read many…
Fragment data and idx
Hi gurus: I have IDS 7.31.UD7 I have a table with high reads and inserts, this table have fragment by expression on 4 dbspaces. The 7 index for this table, must be fragment on other dbspaces or must be on 1 dbspaces. What say the expertise ?? Thanks in advance…
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 …
Indexes on a Fragmented Table
Hi, If a table is fragmented by expression, should all of its indexes be fragmented (regardless of whether they're unique or non-unique)? At one time, I was told to keep any unique indexes non-fragmented in a separate dbspace. Platform: IDS 9.40.FC3 / AIX 5.1 Thank you.…
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Informix Storage Manager ISM
Hi everybody I'm playing with ism and onbar, in order to establishing an onbar policy of backups. Im very confused with some ism topics. I defined a directory on disk (apart from the database disks box) where I direct data backups and another directory for logs backups. ism_ad…
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!…
Re: Informix manuals - imported restore
Thanks for that. I was looking at http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.bar.doc/barmst156.htm "To perform the imported restore... Storage-manager configuration files, if any The storage-manager configuration files might need updating." "The stora…
AW: Problem with Table fragments
Dear Aash, Sorry , nothing in Informix like automatic fragment creation based on expression. The problem or better one of the problems, is, that IDS does not have a sematic understanding of your sexpressions used for fragmenting , so it would have a hard time to guess what expre…
Re: Problem with Table fragments
I think this can be done with version 10 of IDS J. -----Original Message----- ... Can I also add all the fragments to the same dbspace so that all I have to do is alter the Expression statement and not go about creating new table spaces every time a new fragment is generated? …
Problem with Table fragments
Hello Gurus of the Informix World, My ignorance of Informix system had brought me to your doorsteps yet again. My Problem: I have 3 huge huge fact tables in my warehouse design and am trying to fragment them. I want them to be fragmented monthly i.e. each month for each year will…
Release of space in a table
alter anindex_from_that_table to cluster, alter fragment on table <yourtable> init in ..... warning if the remaining table is huge then be aware of long trx rollbacks Superboer.…
Mixing Storage Managers with onbar
I was wondering if anyone had experience using onbar to back up a database with different Storage Managers for the same instance on the same day. For example I have a need to do a whole system backup using onbar and Veritas Netbackup. Then later in the day we need to perform a se…
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: Onbar physical followed by onbar logical...then...ontape ?
What can I say but "it's always fun to play around with your backups and try risky unsupported stuff. It's always fun until the restore doesn't work!" I'd hate to think what situation this would leave you in if you then backup logical logs via onbar and the instance fails befo…
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.…
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 …
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…
Using Informix Storage Manager (ISM)
Greetings, My group is considering using ISM for archiving our XPS 8.5 instances. I'd like to configure it so the archives are written to disk and I can run a filesystem backup to store the images to tape. Does anyone have any experience using this product who could give m…
Re: ISM restore to different machine
ISM is a limited functionality storage manager aka Legato Light which is intended to allow you to back up and restore on the same server using Informix Onbar. There are workarounds that allow you to do restores on a other servers (imported restore). If you have a requirement to…
ROWID functionality
rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?…
partitioning
Does anyone have an example of fragmenting a table into the same dbspace ... using the new v10 feature of naming a partition ...…
Re: SERIAL8 on a Fragmented Table
Sometimes I just have to ask the question so I can find my own bonehead mistake. At least I didn't spend to long on it. :-)…
RE: SERIAL8 on a Fragmented Table
DOH! I've never done something like that - lol -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Chris S Sent: Tuesday, August 02, 2005 1:05 PM To: informix-list@iiug.org Subject: Re: SERIAL8 on a Fragmented Table…
SERIAL8 on a Fragmented Table
Here are my software versions: AIX 5.1.0 Informix Dynamic Server 2000 Version 9.21.UC4 I have a table that is fragmented round robin over 10 dbspaces. It currently stores over 1.2 billion rows and is expected to grow, hence the reason to use the SERIAL8 data type for my SERIA…
Re: Enough of the "DB2" thread, let's talk about Fragmented Tables
Hi, depending on your fragmentation schema and the queries, you may get "fragment elimination", i.e. IDS finds out that it may not need to read certain fragments at all, since there will not be any data in these fragments that match the query. If fragment elimination happens, yo…
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…
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:…
Re: Onbar and Storage Manager Backup to different server mpossible?
Robert A. Reissaus said: > Ben Thompson <ben@nomonitorsoftspam.com> wrote in message > news:<11b34p05l206ob8@corp.supernews.com>... >> Obnoxio The Clown wrote: >> >> > A smile is a gift that is free to the giver and precious to the >> > recipient. But giving someone the finger is…
RE: Onbar and Storage Manager Backup to different server mpossible?
I hesitated to respond to this thread since I am not an onbar expert. I assisted in setting this up on IDS7.31 and Solaris 8 a few years ago. We have since moved to Solaris 9 IDS 9.40.FC5. We routinely do imported restores from our production instance to a test box. We had so…
Re: Onbar and Storage Manager Backup to different server mpossible?
Robert A. Reissaus said: > [SNIP] > Jonathan Leffler <jleffler@earthlink.net> wrote in message > news:<42B0F689.6070107@earthlink.net>... > [SNIP] > > DR stands for Disaster Recovery. Since I came across it again and > again and again in the past 15 years a well enough known abbr…
Re: Onbar and Storage Manager Backup to different server mpossible?
Hi, if you are using ISM (IBM Informix Storage Manager), then you have to use a procedure called "imported restore" to restore a backup on a different machine. This is mainly because the hostname is different, as you have already noticed. The "imported restore" procedure is desc…
Onbar and Storage Manager Backup to different server mpossible?
Hi guys. We have 2 IBM P570 servers, one production one as DR. Both machine run IDS 9.4.FC6 and are exactly the same EXCEPT for the hostname. Policy of the datacenter here we have the production server makes and the fact that the program running on it doesn't usetransaction log…
Re: ONCHECK -CI
herbO via DBMonster.com wrote: > Can the message "Index fragment in DBspace" that is returned from the > execution of "oncheck -ci" be eliminated? Dropping the table or the index > and recreating in new dbspaces has not done so for me. Huh? What's the problem? It's just tellin…
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…
Re: ONBAR tape setup
Informix novice, This is really a limitation of the storage manager, and not onbar. You didn't mention what storage manager you used, but any storage manager worth its salt can backup multiple jobs at the same time to the same tape. During a full instance backup ("onbar -b -L 0…
ONBAR tape setup
Informix novice, This is really a limitation of the storage manager, and not onbar. You didn't mention what storage manager you used, but any storage manager worth its salt can backup multiple jobs at the same time to the same tape. During a full instance backup ("onbar -b -L 0…
Re: Informix Parallel Backup Question
Hi, a couple of things got confused. I try to clarify: a) - ON-Bar does support parallel backups and restores. The onconfig file parameter to configure this is BAR_MAX_BACKUP . - having set BAR_MAX_BACKUP to 1 will in fact make ON-Bar operate serially. - recommend…
Re: Informix Parallel Backup Question
Hi, a couple of things got confused. I try to clarify: a) - ON-Bar does support parallel backups and restores. The onconfig file parameter to configure this is BAR_MAX_BACKUP . - having set BAR_MAX_BACKUP to 1 will in fact make ON-Bar operate serially. - recommend…
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: Unloading to two destinations
How would range-based fragments do the trick without needing to add a column to the table to determine whether or not the row is to be kept? The deletion rules are complex (and involve more than one column) so to-keep fragmentation couldn't be achieved with the existing schema. A…
Adding rowids to fragmented table
Hi, When adding rowids to a frag'd table, should I drop all the indices first before altering the table? (the rebuild indices afterwards) If I drop the indices before alter table, am I just making work for myself?... Does adding rowid change the indices in any way (I could jus…
Adding rowids to fragmented table
Hi, When adding rowids to a frag'd table, should I drop all the indices first before altering the table? (the rebuild indices afterwards) If I drop the indices before alter table, am I just making work for myself?... Does adding rowid change the indices in any way (I could jus…
Re: Rowids in Informix Databases
Art S. Kagel wrote: > On Tue, 12 Oct 2004 07:32:44 -0400, Vijay Kumar wrote: > > ROWID is not a REAL column in the table (unless the table is fragmented that > is). It is the relative address of the row which is simply treated as if it > were a column. If your table is fragment…
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'?…
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automati
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Wo…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
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: ONBar Restores and Tivoli Storage Manager
> -----Original Message----- > From: Neil Truby [SMTP:neil.truby@ardenta.com] > Sent: Thursday, August 05, 2004 2:12 PM > To: informix-list@iiug.org > Subject: Re: ONBar Restores and Tivoli Storage Manager > > > "Eric Herber" <eric@i-hate-spam.org> wrote in message > news:cess2p$…
Re: ONBar Restores and Tivoli Storage Manager
You could turn on debugging in your $ONCONFIG by setting BAR_DEBUG to 9 and BAR_DEBUG_LOG. This might give you a clue what is happening. What versions of TSM, TDP/Informix and IDS are you using and on what platform ? Have you enabled the COMPRESS option in TSM ? What are the s…
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…
RE: ONBar Restores and Tivoli Storage Manager
Versions? I have IDS 9.40.FC3 on AIX 5.2, TSM 5.1. I do a level 0 every day. I do a point-in-time restore of that level 0 to a report instance daily and to a QA and test instance weekly. No problems with it. Regards, Bill Dare > -----Original Message----- > From: PEEK, CHRIS…
ONBar Restores and Tivoli Storage Manager
I am having problems with restores from ONBar via Tivoli Storage Manager (TSM). I can perform backups that complete fine according to the logs, and the verification using "onbar -v" reports successful with no errors. However when I go to attempt a restore, I get one of two situa…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
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?…
forms on a fragmented table
Hi all, I'm having a little issue with fragmented tables and forms I build on them. This is the senario, I have a table XYZ which is fragmented by months (5 mths) over 5 dbspaces. Now I want to build a form (isql dbname) forms generate and then run the form on the table XYZ but w…
backup with ISM
Hello world Is there anybody worldwide doing backup on 64-bit AIX 5.x with IDS 9.xx.FCx & Informix Storage Manager, please? Let me know please. Regards Rasto sending to informix-list…
RE: onbar performance
> "Murray Wood (IList)" <ifxmaillist@quanta.co.nz> wrote in message > news:<c95jpu$54l$1@terabinaries.xmission.com>... > > Adrian > > > > onbar sends its data to a Storage Manager. Which storage manager are > you using? Does it reside on the database server or elsewhere? Where…
Alter Fragment on a table in syscdr
Hallo, I have a large table "trg_send_sbuf" in dbspace "cdrquedbs" belonging to the database syscdr (Enterprise Replication). The table has 1 GB with no rows. Can I do an ALTER FRAGMENT ON trg_send_sbuf INIT IN <cdrquedbs>; to reclaim the space without any trouble with ER. Mus…
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…
TSM - TDP for informix
You have latest version of TDPI. 133 (BAR_NO_BSALIB) is an onbar error code. This indicates that the storage manager has been incompletely or improperly installed or that the BAR_BSALIB_PATH parameter in the $INFORMIXDIR/etc/$ONCONFIG file has not been set properly. Ensure that t…
RE: ontape vs onbar - the gospel according to malcolm
"malcolm" <malcolm.weallans@btopenworld.com> wrote in message news:3efc1745.0404160223.7b9bbe77@posting.google.com... > I think Neil has hit the nail on the head. The main difference > between ontape and onbar is the integration of onbar into the > enterprise storage manager. >…
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…
Table fragmentation
Hi all. We're preparing to roll to a new version of our application software. The process will entail creating a copy of our current database for them to use as they install/test the new software. This seems like an opportunity to make some adjustments. Are there any good/bad e…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? Thanks.…
Re: Where is that index?
On Sun, 14 Mar 2004 23:30:38 -0500, Peter Harris wrote: If the table is fragmented or the index is either detached or fragmented: select dbspace from sysfragments where index_name = 'myindexname'; If the index is attached to a non-fragmented table: select dbinfo('dbspace', pa…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Table has no rows but has lots of pages
> ALTER FRAGMENT ON mytable INIT IN <dbspacename or fragment expression>; Does this rebuild the table? OK, not exactly an issue with no rows, but could be if you still had some left ... Andy…
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…
RE: Third party Informix storage managers
This is a multipart message in MIME format. --=_related 0070C96185256E30_= Content-Type: multipart/alternative; boundary="=_alternative 0070C96385256E30_=" --=_alternative 0070C96385256E30_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printab…
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 …
EXE - ISQL on Fragmented tables
I am migrating to 9.3 from 7.3.on EXE. Many of the support groups tools still use ISQL which does not work on fragmented tables. At least not in 32-bit mode. My question is A) Does anyone know if ISQL in 64-bit can see across fragments? oan B) If not, are there any tools like …
RE: starting up ISM
I have TSM running on the same server that I am in the process of testing using ISM. Don't know if the below comments will help with your problem but have you performed the following: The below parameter change is critical, this parameter informs user Informix to use the Inf…
starting up ISM
I have TSM installed on a machine - I shutdown all the TSM processes and issued $INFOMIXDIR/bin/ism_startup -init and got the following error *** The ISM setup script detected that another storage manager is installed in /nsr, which conflicts with ISM. If you want to setu…
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.…
Onbar without ISM
Jimmy Chen wrote: > can informix back'ed up using ONBAR without install ISM? Yes - you can use any compatible storage manager (which needs to comply with the XBSA standard). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@u…
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…
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.…
ISM GUI
From where can I download the GUI console for the informix storage manager? Thanks…
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…
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…
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…
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…
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: Onbar and Veritas Netbackup?
Hi BAR_TIMEOUT is the amount of time onbar waits if its in XBSA api/Server api (communicating with the storage manager) Following warning generally means that storage manager needs attention. Maybe some configuration with storage manager that its taking long time to transfer dat…
RE: Onbar and Veritas Netbackup?
Hi BAR_TIMEOUT is the amount of time onbar waits if its in XBSA api/Server api (communicating with the storage manager) Following warning generally means that storage manager needs attention. Maybe some configuration with storage manager that its taking long time to transfer dat…
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.…
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…
adding new fragment to a table
All, I'm having a little problem with adding a new dbspace to a frag'd table. The statement I'm trying to run is below. I get a syntax error when trying to run the statement below. Could someone give me a hand with the correct statement? The table is frag'd by expression using a…
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…
Table Fragmentation
Hi, thanks for your suggestions, I was run the update statistics but the problem continues. Somebody know some tools for view table distributions on disks? Thanks again.. Paola Quoting "Jonathan Le...." <jleffler@us.ibm.com>: > > > > > Yes -- RTFM. > > ALTER TABLE ADD (newcol…
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.…
Fragmentation on a column type datetime
Please include the where clause of the fragmentation and the where clause of the query. "mohamed.afe...." <mohamed.afeilal@ To: ids@iiug.org meditel.ma> cc: Sent by: Subject: Fragmentation on a column type datetime [163] forum.subscriber@ iiug.org 01/29/2003 02:16 PM We fragme…
Indexing large fragmented table
I have a table with a row size of 104 bytes containing approximately 800 million rows. The table is fragmented across 51 dbspaces where each fragment uses upto a maximum of 450,000 of the allocated 524,197 pages. I would like to place some indexes on the table. Since there is lit…
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!…
FRAGMENT privileges - no SELECT?
IDS 2000, 9.21.UC2, Linux. One of the (several) objectives of FRAGMENT(ing) a table BY EXPRESSION can be to enhance the granularity of security permissions over table data, providing row-group-level security. CREATE TABLE employee ( employee_id INTEGER NOT NULL PRIMARY KEY,…
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…
Onbar and Veritas Storage Manager
I am running IDS 7.31 on a SUN Server. We have a SUN enterprise backup system that uses Veritas as the storage manager. I currently use ontape for data and log backups. I have a DLT tape drive for data and a DAT drive for tapes. I want to use onbar to backup up to the SUN/Ver…
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…
Data stored by fragments.
Let's say you need to roll out data from 6 months prior. Add a month column and fragment based on it's value. Each month you add a new fragment for the coming month and after the new data are loaded you drop the oldest fragment: Create table rolling_data ( ... data_month small…
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…
OnBar/OnTape
Onbar and Ontape are two different animals when it comes to logical logs. Remember that onbar is Storage manager based and the recover file it creates (ixbar.x) assumes that all the recovery media is in one location - the storage manager. With ontape, you could "mix and match" a…
ON-Bar Logical Logs to Disk
I am looking for any remarks, comments, how-to information on how to use ON-Bar with the logs going to disk (in case of a storage manager failure) and archives going to the storage manager. We are using 7.30, about to migrate to 7.31, Digital Unix.…
Re: onbar -l hangs
What storage manager are you using? Are there any error messages in the storage manager logs? Anything in /var/adm/messages? Anything in the online log? -FPL >>> <mark_bowman@my-deja.com> 08/29/00 07:37AM >>> I am trying to do a level 0 backup to get around the fact that all…
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…
Re: MS Access performed faster than Informix in 800000 row tests
How fragmented is the Informix table, disk space wise? The same question for Access table.…
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…
On-Bar to ADSM
Hi Guy s I'm an AIX bod so excuse my lack of knowlege on Linux. Has anyone out there managed to find the Tivoli Storage Manager ( ADSM ) libraries that allow Onbar to work on Linux yet. We have linux adsm client level 3.1.0.1 on what ADSM says is linux 2.2.14-5.0 Please copy …
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…
Informix ISM and 7332
Platform:RS/6000-B50 AIX 4.3.3 Informix IDS 7.31.UC6 Informix Storage Manager:2.2 Atape.driver: 5.0.2.0 Tape Drive: IBM 7332-4mm DDS2 12 tape autoloader I am attempting to get the Informix OnBar backup utility installed and running on my …
Re: migration using onbar
hi, we are using netbackup for our storage manager and the machine's hostname is used as part of the backup id. i tracked down what file needs to be modified to get around this and i am now able to copy an instance from one machine from another. thanks for the reply! ty o'kel…
Re: copying databases with onbar
hi, yes, i was talking about an entire instance. more specifically using onbar to create the secondary database in a hdr pair. we are using netbackup for our storage manager and i finally tracked down what files need to be modified. thanks for your reply ty o'kelly tokelly@no…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Fragmented tables
"Richard E. Hassler" wrote: > > For non-fragmented tables ROWID is the physical location of the row in > the database. Can SE 7.2 have fragmented tables? If so how do you know > when the table is fragmented? SE does NOT support table fragmentation you need to move to IDS. Art…
Re: Fragmented tables
Hello Richard, the feature "Fragmentation" is not available in SE Richard E. Hassler <Hassler.1@osu.edu> schrieb in im Newsbeitrag: Hassler.1-F91F23.10461826062000@nntp.service.ohio-state.edu... > For non-fragmented tables ROWID is the physical location of the row in > the data…
Fragmented tables
For non-fragmented tables ROWID is the physical location of the row in the database. Can SE 7.2 have fragmented tables? If so how do you know when the table is fragmented?…
Simple Question
Hello, group I want to get the following attributes of all tables in a given dbspace, tablename, owner, database name in this given dbspace, I only have non-fragmented tables, but in other dbspaces, I might have fragmented tables. How should I write the SQL statement? Tha…
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…
Posting from the Informix-list
In article <8h31p7$nn$1@news.xmission.com>, Lewis, Keith A. <Lewis@timken.com> writes > >We are moving to IDS 7.31 FC4 from 7.30 UC3. Currently we use ON_BAR and >ADSM to manage our backups but with 7.31FC4, ADSM and ON_BAR do not work >together yet. I am looking for some revie…
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…
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.…
Detaching Fragments
We have a very large table that is fragmented by expression over 12 dbspaces. There is 1 Primary Key and 6 Indexes. Is there a way to detatch one of those fragments without locking the table due to spending hours on an index rebuild? =( Thanx, query_gurl Sent via Deja.com ht…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: Need for Speed...
The query, query plan and schema for the tables would be good too (including fragmentation strategy) Will Sent via Deja.com http://www.deja.com/ Before you buy.…
ON-BAR basic question
sveiga@my-deja.com schrieb: > Is it possible to make a remote backup using On-Bar ? On-Bar doesn't care about where the backup is going to. It interfaces with a storage manager that handles the actual backup. So what you need is a storage manager that can handle remote backups…
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…
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…
Problems with logical log backup
looks like a storage manager problem, call omniback. Nona…
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…
best procedure for table moving one dbspace to other
echo "alter fragment on table TABLE init in DBSPACE" | dbaccess -e DB…
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…
Fragmented table
Hi, all Is there anyone who can give me some advices on how to check if a table is a fragmented table, and the table is createt in which dbspace(s)? Thanks a lot. Harry…
Error Code -786
Hi all, When I run an SQL like: Alter fragment on table A attach B; (my table B is not fragmented. ) I get an SQL error code of -786, whhich says Non fragmented table being attached is not in the attach list. What does this imply and how do I overcome this. Thanks Manoj…
Informix extents
Hello Gurus, I have a fragmented table with approx 10 million records ( 20 fragments) . Data portion of the table has only one extent per fragment after i did the reorg. But the indexes extents look so weird .. One of the unique index has got 17 extents in one of the fragments. …
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…
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…
Re: onspaces Offsets
Lucent wrote: > > The max offset is 2097150? Does this mean that you can not use a drive > larger than 16 gig with informix for database storage? No. It means that if you use Solaris and drives larger than 16GB you have three choices: o Waste the space o Use the balance of eac…
Posting from the Informix-list
I have Informix Workgroup version 7.30.UCB8-1 installed on an RS/6000 AIX version 4.3.3. I would like to check into the possibility of getting "onbar" working to do my archiving, but I can't find the Storage Manager on my system. Does anyone know what the Storage Manager is for A…
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…
best way to fragment existing large table?
Problem: 1 table containing in excess of 19,000,000 rows that is contained in one dbspace, not fragmented(obviously), and with more extents than I care to mention. I need a way to slowly (over the course of several days so as not to interfere with production) fragment the table …
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…
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…
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…
Speed of "alter fragment"?
I'd like to fragment two large tables in three or four fragments, based on dates -they're 20.000.000 rows * 18bytes and 43.000.000 rows * 54 bytes. (The rest of the tables are too small to bother with) There's two large indexes on both tables and I'm planning on detaching them, …
Linux: IDS LE replication, IECC & DBCockpit agents - WHEN?
Richard Spitz wrote: > > "Art S. Kagel" wrote: > > The problem with porting OnBar is that none of the Storage Manager vendors, > > including Legato which provides Informix with the delivered Storage Manager > > in IDS 7.3x, currently support Linux. > > According to the Legato Sof…
RE: Onbar using ADSM as storage manager
sorry for delay, I just would like to point out that IBM still can't provide a 64-bit Xbsa library, I would not recommend to use ADSM for 64-bit Informix releases (onbar to ADSM simply doesn't work) regards, Ivars > -----Original Message----- > From: Doug Agnew [mailto:dagnew@c…
Onbar using ADSM as storage manager
Does anyone out there have any experience or comments on the choice of ADSM as the storage manager used by OnBar?…
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…
Re: OnBAR & Storage Managers
It does. The ISM is bundled in IDS Workgourp Edition on UW7 (and I think it is bundled in the standard edition too). Best Regards, Octav On Wed, Aug 25, 1999 at 03:18:44PM +0200, Willem Roos wrote: > All, > > Can someone recommend a storage manager to be used with > onbar on Un…
OnBAR & Storage Managers
All, Can someone recommend a storage manager to be used with onbar on Unixware 7. Does IDS 7.3 bundle a storage manager on Unixware 7 (i was under the impression it was only on NT)? TIA -- /* ----------------------------------------------------- * * Willem Roos …
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?…
OnBar and ADSM
We use ADSM as the storage manager for onbar. I was wondering when, and if, the client ever deletes backups of log files or the databases? Does anyone more familiar with onbar than myself have any insight? Thanks, Dan Ehrlich…
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.…
on-archive / on-bar
If you're not already using on-archive, DON'T!!!!! At least, that's the word I get from some SAP/Informix DBA classes. On-Bar relies on a storage manager software product (Legato, ADSM, or a basic system supplied with Informix) to actually write the backup data to a storage medi…
# 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…
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…
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…
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…
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…
ALTER FRAGMENT
I could find ALTER FRAGMENT on my on-line Informix manual but again dbaccess and older manuals did not seem to have this SQL construct. Q: Does IDS 7.2x support ALTER FRAGMENT?? Thanks in advance! "A" > >IDS 7.2x does not support view containing UNIONs. IDS version 7.3x >does…
Re: create view as table unions - Syntax Errors?
I could find ALTER FRAGMENT on my on-line Informix manual but again dbaccess and older manuals did not seem to have this SQL construct. Q: Does IDS 7.2x support ALTER FRAGMENT?? Thanks in advance! "A" > >IDS 7.2x does not support view containing UNIONs. IDS version 7.3x >does…
Re: Win interface for Informix
Manoj Nanda wrote: > Hi - Im wondering if there is a similar product to oracle enterprise > manager for informix > I intend to use a windows platform such as nT to interface to an > informix database giving full functionality > of schema, worksheet ,storage and instance manageme…
Re: Win interface for Informix
The closest you'll get is IECC. Manoj Nanda wrote: > Hi - Im wondering if there is a similar product to oracle enterprise > manager for informix > I intend to use a windows platform such as nT to interface to an > informix database giving full functionality > of schema, workshe…
Win interface for Informix
Hi - Im wondering if there is a similar product to oracle enterprise manager for informix I intend to use a windows platform such as nT to interface to an informix database giving full functionality of schema, worksheet ,storage and instance management...does such a tool exist? …
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 ?…
Re: Extent doubling/Fragmented table
The doubling is every 17th extent per dbspace...has nothing to do with fragments. > In the IDS 7.30 manuals it appears to say that regardless of other > settings IDS will double your next extent size after 16 extents in a > single table. I am planning on a fragmented table, mos…
Extent doubling/Fragmented table
In the IDS 7.30 manuals it appears to say that regardless of other settings IDS will double your next extent size after 16 extents in a single table. I am planning on a fragmented table, mostly for management of the data - ease in dropping a fragment, etc, but I expect to have m…
Re: Physical sizing of tables
How about using ALTER FRAGMENT ON TABLE <table> INIT IN <the same dbspace name> ? HTW, Harinath Venkata Svenska Handelsbanken New York…
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 …
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…
Experiences with Informix's OnBar and Storage Managers
We are looking for products which can be used to backup Informix databases to an IBM 3575 tape library in the UK. At our corporate headquarters, we use IBM's ADSM and a 3494 robotic library. However, we are looking for less costly solution with less administrative issues for ou…
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…
cluster and table size
When creating a cluster on an index, is there also a way to extend the table size by a few percent so the table doesn't become fragmented as soon as new rows are added?…
Re: Which Storage Manager to use?
Sanjeev, We run IDS 7.23 UC1 on Solaris 2.5.1. Our SM is Legato v5.1 build.103. We backup to a DLT/7000. All things considered, we have not had any problems with this environment. Specific to our environment, there are Solaris patches needed to solve some performance problem…
Which Storage Manager to use?
Hello Everbody, I am using IDS 7.30.UC2 on Solaris 2.5.1. Also i use XPS 8.21.UD1 on Solaris 2.5.1 My company went for Alexandria SM for Backup and Recovery Startegy. But it is full of bugs and it is not supported for xps yet. I recently tested with Alexendria 4.50.12. Can som…
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…
Problem doing ALTER FRAGMENT...ATTACH
Ugh. Platform: DG/UX R3.1, ODS 7.12.UC1X7. Will be upgrading soon, don't worry :). Problem: I have a huge table that I am trying to attach a fragment back into. This table has 53 fragments based on expressions. I am using the ALTER FRAGMENT...ATTACH...AFTER syntax to do my A…
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*.…
OnBar/DLT (was Logical Logs to Disk?)
>One last thing...Onbar is really what you should be talking about. I know >many sites are still using ontape, but one of the things that onbar (with a >robust storage manager) does very well is to automate the continuous backup >of logical logs to tape. I couldn't imagine life…
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.…
Re: Informix Storage Manager
I've recently gone through some headaches w/ISM and On-Bar running in conjunction with OnLine XPS 8.21.UD1. Have you run the following as root: ism_startup -init This performs some very necessary setup. The '-init' parameter is only required the first time. Afterward…
Informix Storage Manager
I'd like to have some pointers on setting up the Informix Storage Manager, shipped along with IDS 7.3. Our platform is IBM RS 6000 with AIX 4.3.1. The "Informix Storage Manager Administrator's Guide" is almost entirely for managing ISM from the IECC interface of Win NT, with jus…
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…
Choosing Primary key DBSpace
Is there a way to choose which DBspace the primary key of a table gets loaded to? I am doing a CREATE TABLE.......FRAGMENT AS ROUND ROBIN..... since it is a fairly large table.…
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: OnBar and Third Party Storage Managers
Hi Douglas, Look in the release note directory, search for example on Legato and you will find some files. One of this will list all the supported storage managers. Greeting and succes, Rob Prop…
OnBar and Third Party Storage Managers
Maybe I'm just blind, but could SOMEONE point me to the location at www.informix.com that identifies the validated combinations of OnBar and third party storage managers. I've wandered all over the place and can't find it. (or point me in a better location) TIA Doug Agnew DBA…
Re: Informix database reorganization
You can reorganise your tables one at a time using ALTER FRAGMENT. You don't actually have to fragment your table across multiple dbspaces when you do this. Neil Truby Londis Holdings London, UK…
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 "…
Re: Finding busy tables
Mario Estrada wrote: > You can fragment your tables in Informix-SE and then watch > their activity using the sar command in unix. You can fragment tables in SE? How? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http…
Re: altering extent sizes
Kate_Tomchik@homedepot.com wrote: > > What does it mean to alter fragment init? It's an SQL command that initiates fragmentation across dbspaces or removes fregmentation from a table. However, if you use it on an unfragmented table so: ALTER FRAGMENT ON table1 INIT in dbspace1…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: 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…
V7.3X Attach/Detach Fragment - Avoiding Index Rebuild
Hi, Informix proclaims that IDS V7.3X is smarter when it comes to Attach/Detach of a fragment using 'Alter Fragment On Table x Attach/Detach...'. They claim Index rebuilds can be avoided when Detaching if the index fragmentation is identical or highly parallel to the table fra…
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: +…
Memory locked fragments in 7.23
Has anyone worked with locking table fragments in memory in 7.23?? How does it work? What is the command?…
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…
Re: Onbar/Informix Storage Manager question
Alex Dron wrote: > > > Forgive me this stupid question, but I don't know > where can I find so called "Informix Primitive Storage Manager"? > I can't use onbar because it requires XBSA library for my UNIX (I use > SCO v5.0.2 and Informix ODS v 7.22) - ibsad001.so. Of course I ha…
Re: Onbar/Informix Storage Manager question
You need to use a third party Storage Manager product in order to use Onbar. Check with your local Informix support person and/or Tech support for a list of vendors that are certified by Informix. However, release 7.3 will include a scaled down version of Legato's Networker and…
Re: Onbar/Informix Storage Manager question
Alex Dron wrote: > Forgive me this stupid question, but I don't know > where can I find so called "Informix Primitive Storage Manager"? > I can't use onbar because it requires XBSA library for my UNIX (I use > SCO v5.0.2 and Informix ODS v 7.22) - ibsad001.so. Of course I haven…
Onbar/Informix Storage Manager question
Forgive me this stupid question, but I don't know where can I find so called "Informix Primitive Storage Manager"? I can't use onbar because it requires XBSA library for my UNIX (I use SCO v5.0.2 and Informix ODS v 7.22) - ibsad001.so. Of course I haven't it, but Informix tells …
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…
Re: ONBAR's use of XBSA
Should come from whoever has provided your storage manager (adsm, etc.). Without a storage manager, you'll have to wait for 7.3, which is alleged to have a simple storage manager provided. Vic Marc Chance wrote: > One of the software requirements for use of onbar is a shared l…
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: Storage managers for use with ONBar
Seth Grimes wrote: >What (XBSA compliant) storage managers work with ON-Bar and what >experiences have list members had with them? The only one I know >about is dbBRZ from SCH Technologies. I haven't done any research; >they were at the WAIUG Forum last week. > >This is for IDS…
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.…
Data replication and 3rd party Storage Manager
I would to hear from anyone who is using Data Replication and 3rd party storage manager software. Would like discuss problems and how to tackle them. Thanks in advance. Nilesh Kunvarji…
Re: Storage managers for use with ONBar
Seth Grimes <grimes@access.digex.net> wrote: > What (XBSA compliant) storage managers work with ON-Bar and what > experiences have list members had with them? The only one I know > about is dbBRZ from SCH Technologies. I haven't done any research; > they were at the WAIUG Foru…
Re: Storage managers for use with ONBar
At 12:33 PM 2/25/98 -0500, Seth Grimes wrote: >What (XBSA compliant) storage managers work with ON-Bar and what >experiences have list members had with them? The only one I know >about is dbBRZ from SCH Technologies. I haven't done any research; >they were at the WAIUG Forum la…
Storage managers for use with ONBar
What (XBSA compliant) storage managers work with ON-Bar and what experiences have list members had with them? The only one I know about is dbBRZ from SCH Technologies. I haven't done any research; they were at the WAIUG Forum last week. This is for IDS/UDO 9.12 on Solaris 2.5.…
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…
Re: Appending/Overwriting!?
Are you using ON-Bar on UNIX or NT? If ON-Bar is running on a UNIX box then it is up to the storage manager to append to the data on tape or overwrite the data on tape. Which storage manager are you using? Doug b. >Hello. > >I'm using ONBar to do backups of our single Informi…
Fragments vs location of tables
In article <bagqaewygiirvxooeapyneuki.pminews@natserv.com>, Francisco Reyes <francisco@?.Spam> writes >I have several tables which I fragmented. i.e. in db1, db2, db3 and >db4. >I placed all my small non fragmented tables in db1 and to balance >some of the biggest ones NOT in db1…
Re: Fragments vs location of tables
Francisco Reyes > I have several tables which I fragmented. i.e. in db1, db2, db3 and > db4. > I placed all my small non fragmented tables in db1 and to balance > some of the biggest ones NOT in db1. > Today while looking at table info I noticed the tables which are NOT > suppo…
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: onbar on its own
Jon, Tech support says that OnLine will have its own storage manager bundled in starting with 7.30. Andrew Shadle Jon Myatt wrote: } Hi all } } I've seen references (rummaging back through old news on Dejanews) to } onbar running without a storage manager, ie } just backing u…
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…
onbar on its own
Hi all I've seen references (rummaging back through old news on Dejanews) to onbar running without a storage manager, ie just backing up to a local tape device. Is anyone using onbar like this? The docs from Informix say "... Informix provides a simple device manager called In…
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…
RE: non fragmented tables
bala peddi <bala.peddi@fmr.com> wrote: > What is the best method to find non fragmented table and > fragment those non fragmented tables > > Thanks in advance > > BALA > bala.peddi@fmr.com > The way to find them is to look at systables and sysfragments (where = fragtype =3D "T"…
non fragmented tables
What is the best method to find non fragmented table and fragment those non fragmented tables Thanks in advance BALA bala.peddi@fmr.com…
Re: Do I must buy "On-Bar" utility?
OnBar may well work standalone with OWS (I have no direct experience), but I just attended the OnBar class for ODS/Unix and the instructor said in no uncertain terms that a storage manager was required, and that Informix would be including a version of Legato Networker with this …
Re: fragmentation and sqexplain
> The Question : what does fragments: 0 vs. fragments: 1 mean ? This indicates that only one fragment will be searched in executing this query. If it required multiple fragments, you would see something like "fragments: ALL" or "fragments: 0,1". The number of the fragment that…
Re: Difference betw. ONBAR / ONTAPE / Command Center tools?
In article <654o31$904$1@arctic.discover.net>, "Eric R. Gavin" <Eric_Gavin@maf.org> writes >As a new ODS DBA, I'm beginning to examine backing up this beast of burden. >But I see all these different tools! ONTAPE, ON-BAR, and the Command Center >Backup and Resore tools. > onta…
fragment by date expression
Hi, in one of our table 'dta' , the old records are not physically deleted , we have a field 'dtadte' that might content the date of the suppression. This table is now growing very fast, and I want to cut the number of rows to scan by fragmenting the table in the following way:…
Re: Archive utilities: autoloaders supported?
Cosmo Lee wrote: > > We would like to be able to use one of the new tape storage solutions > such as the HP DAT 24x6e, which holds multiple 12GB tapes. Do any of > the Online archive utilites support any such autoloaders?? I don't see > any mention in the 7.2 "Archive and Backu…
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: Finding dbs for table
Mark D. Stock wrote: > > Bill Ennis wrote: > > > > With fragmentation a table can belong to more than one dbspace. > > I belive the first 3 chars in partnum contain the dbspace number > > for the table. You can view partnum in the systables table. > > My guess is that if you do f…
Adstar storage manager on AIX
Hi, I would like to use ADSTAR storage manager with OnLine7.23 on AIX4.2. Anybody using it? What is suggested method (onbar, ontape or onarchive) for backing up my database (about 6 GB mirrored data) which is located on 12 SSA disks? Thanks in advance. +----------------------…
Re: aix 4.1.5 / onbar / storage manager
junet@informix.com (June Tong) wrote: >tobias@tempel.hh.eunet.de wrote: >: don't want to use onarchive (!) and can't use ontape (not >: supported by informix for backups on disks). >Ontape DOES support backup to disk. I've had this discussion with Tech >Support management and …
Re: aix 4.1.5 / onbar / storage manager
Try ADSM from IBM, Networker from Legato, Alexandria from Sectra Logic, etc. ------------------------------------------------------------------------- Herb Blacker Cimarron, Inc. Database Administrator - DOL Job Corps San Marcos, Texas --------------------------------------…
Re: aix 4.1.5 / onbar / storage manager
tobias@tempel.hh.eunet.de wrote: : don't want to use onarchive (!) and can't use ontape (not : supported by informix for backups on disks). Ontape DOES support backup to disk. I've had this discussion with Tech Support management and with QA. June ---- June Tong …
aix 4.1.5 / onbar / storage manager
hi there, we need to make backups of our online ds 7.23 to disks, don't want to use onarchive (!) and can't use ontape (not supported by informix for backups on disks). so we tried onbar and (surprise, surprise) now are in need of a storage manager for aix 4.1.5. is there any xbs…
RE: Fragmenting tables/indexes
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_000_01BCD897.B8EF19B0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit What is your "optimizer o…
Re: Fragmenting tables/indexes
Cosmo advises: >Are you sure that your queries are _actually_ using the fragments to >eliminate data from the searches? We had a similar situation where data >was fragmented by dates. But when we ran certain queries, the optimizer >ignored the fragmentation scheme altogether, p…
Re: Fragmenting tables/indexes
Are you sure that your queries are _actually_ using the fragments to eliminate data from the searches? We had a similar situation where data was fragmented by dates. But when we ran certain queries, the optimizer ignored the fragmentation scheme altogether, performing searches …
Re: Fragmenting tables/indexes
} Hi. We have a system that we have fragmented based on Date so that when we } purge our system on a daily basis we simply drop the oldest fragment. This } part works } superbly, but retrieval of records seems to be unneccesarily slow. I } believe that } what we need is a sepa…
Re: Fragmenting tables/indexes
Kate_Tomchik@HomeDepot.COM wrote: > > Hi. We have a system that we have fragmented based on Date so that when we > purge our system on a daily basis we simply drop the oldest fragment. This > part works > superbly, but retrieval of records seems to be unneccesarily slow. I > b…
Fragmenting tables/indexes
Hi. We have a system that we have fragmented based on Date so that when we purge our system on a daily basis we simply drop the oldest fragment. This part works superbly, but retrieval of records seems to be unneccesarily slow. I believe that what we need is a separate dbspace…
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…
XBSA API
We are running Solaris 2.51 and have SOLASTICE as our storage manager. Has anyone used this with On-Bar?…
Online/Optical problem.
I'm having a big problem trying to put to work Informix Online/Optical whith Plexus' Storage manager. I've got a IBM RS/6000 and a 3995 jukebox, running AIX 4.2 with Informix 7.22.UC2 and Plexus' Storage Manager 2.2 The storage manager runs ok, and Informix al runs ok. The only…
Re: Onbar & Storage Managers
Emilio wrote: > > I am new to the Informix Online and I am trying to provide a way > to manage backup and restore with On-bar. Here are some of the > questions that I have: > > o Do I really need a storage manager (networker, netbackup). Yup - I'm using ADSM. It works great. Inf…
RE: Onbar & Storage Managers
Hi Emilio, Here are some answers 1) Yes, unless you are using NT with OWS or ODS , Informix has a Storage Manager included " A simple one :) " 2) This funcionality is present in all the storage managers 3) I don't understand what do you mean here. But they communicate to ea…
Onbar & Storage Managers
I am new to the Informix Online and I am trying to provide a way to manage backup and restore with On-bar. Here are some of the questions that I have: o Do I really need a storage manager (networker, netbackup). o Since onbar is a command line application, is it practical to wr…
Re: 7.2x...RAID...SUN
MS CARLEEN C AVANT wrote: > > From: Carleen Avant > > Would be very interested in knowing of experiences, knowledge, information > regarding RAID levels for Informix 7.2x on Sun Enterprise 4000 utilizing > SPARCstorage Array Model 112. Thanks. > > Internet < cavant@safecen…
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: Initial ON-Bar / Storage manager configuration
Funny when you answer your own questions - thought I'd post my workaround in case anyone else is interested. I deleted ALL the text from sm_versions file apart from the line containing the record to be loaded into the bar_version table. It then worked - the /tmp/bldutil.<PID> fi…
Initial ON-Bar / Storage manager configuration
All, There are two methods one can use to tell ON-Bar which storage manager you are using. 1. Insert a record into the bar_version table using the following SQL: insert into bar_version values ('1','2.1.5','adsm','2'); {values will differ depending on storage manager, etc.} T…
Informix 5.08 and Plexus Optical Storage manager
--openmail-part-002d2ecf-00000002 Content-Type: text/plain; charset=ISO-8859-1; name="Informix" Content-Transfer-Encoding: quoted-printable Hi Everybody, We are using Informix 5.08 and Plexus Optical Storage manager v. 2.3. We= are getting following problem: When we have over…
Re: Fragmented system tables
JohnSchore@aol.com wrote: > > How is one supposed to rebuild a fragmented "system" table (i.e. syscolumns). > I have been unable to add a clustered index even as user "informix". I can't > drop and reload it either (I'm not sure I'd want to anyway.) > > Thank You. John, How did…
Fragmented system tables
How is one supposed to rebuild a fragmented "system" table (i.e. syscolumns). I have been unable to add a clustered index even as user "informix". I can't drop and reload it either (I'm not sure I'd want to anyway.) Thank You.…
Fragmented system tables
How is one supposed to rebuild a fragmented "system" table (i.e. syscolumns). I have been unable to add a clustered index even as user "informix". I can't drop and reload it either (I'm not sure I'd want to anyway.) Thank You.…
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…
Re: npused in fragmented tables
}>From ilist@rmy.emory.edu Fri Mar 14 00:35:16 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO) }> for <settler@dbintellect.com> id AAA10903; Fri, 14 Mar 1997 00:35:15 -0700 }>Received: (from ilist@localhost) by rmy.r…
Re: npused in fragmented tables
And what version of Informix databases does this work on? It returns no rows found on both OnLine 7.10.UC1 on SCO Unix 3.2.4.2 and 7.12.UC1 on SCO Openserver 5.0.0d It would be a nice statement if it worked. Any ideas? settler@hobbes.dbintellect.com (Jeff Craig) wrote: :You cou…
RE:npused in fragmented tables
Robert Donat wrote: >>Does anyone know the exact details of the columns in each? What I need >>it to know the following: >> >>Of a given extent, for a given fragmented table, HOW MUCH IS USED? (not >>just how much is allocated). >> >>The best I've been able to determine is the t…
Rowids on fragmented tables
In Informix On Line 7 you can have the system simulate rowids in fragmented tables just to enable your 4GL and other programs to continue working with the rowid value. You do not see a column rowid in the table definition so it is completely transparent to the applications You f…
Re: ONBAR anybody use it?
This is a multi-part message in MIME format. --------------4E6B160F7CF5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit rcyrus@promarkone.com wrote: > > We have 7.22 in house. Has anybody used 'onbar'? How do you use it. Do > you any other tools or X-…
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…
OnBAR and X/BSA interface
Hello. I would like to write a custom Storage Manager (ISM) for the OnBar utility (OnLine v7.2). Does anyone have info/experience with the X/BSA interface? Thanks. Henry Weiser Siemens-Nixdorf Software (Belgium) Henry.Weiser@swn.sni.be…
Fragmented Table
I have recently taken over a project with over 300 stored procedures. Because of this, sysprocbody and sysprocplan are tremendoulsy interleaved/fragmented. Is there a way to correct this? I wasn't sure about running index clustering or dropping and re-creating system tables. TI…
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 …
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…
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: DSA 7.1X and ADSM Storage Management
We have had major problem doing it with our present 5.x engine. Support for the Informix 7 engine to do it will not be avialble officially until 7.2 with "ON BAR". We did finally get our IBM guys to get it going with 5.X engine, yet they wrote a special script to do it and first …
DSA 7.1X and ADSM Storage Management
Hi Is anyone successfully using IBMs Adstar Distributed Storage Manager for archiving DSA databases and backing up logical logs as well as restore? Any tips appreciated. Also, what are Informixs plans for integration with 3rd party distributed storage managers?…
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)…
How To: multi threads, Fragmentation in Online 7.1.
Informix Gurus, I have fragmented a few tables in our schema, and have updated statistics on those tables. I set the PSORT_NPROCS variable in the onconfig to the largest level of fragmentation (10). Now when I run queries on the fragmented tables, and monitor them using ons…
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: Fragmentation and Extent Size
Well, actually I didnt specify extent size in my ALTER FRAGMENT SQL. Apparently the default for a table must be 1/2 the original size (even though I fragmented across six disks). The original included indexes, the new fragments didn't. They too were (grossly over) allocated se…
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.…
Table Fragmentation
We are currently running Informix 7.1, and are more than a little disappointed with the 'improved' performance we were promised when migrating from Informix 6 to 7. We are now hoping that by implementing some of the new 7.1 features, we will at least get back to the same performa…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: fragementing a table w/ unique indx
I belive that the problem is that you cannot fragment a unique index. Since you can operate against a fragmented table when one of the fragments is down, the unique index cannot be enforced. When you created the table without fragmentation, then fragmented it, the unique index …
Informix Disk Offsets on SPARC Storage Array Volumes?
When defining a database space on a Sun Storage Array volume, is it necessary to specify an offset so that Informix will not overwrite disk label information? Or can one feel reasonably comfortable that the Veritas Volume Manager drivers will not allow that to happen? Sal.…
7.1 table and index fragmentation
We just received our development copy of 7.1 and have noticed a very nice feature which allows tables to be stored in separate dbspaces from their respective indexes. We were trying to figure out how much room to allocate to an index dbspace. Can anyone recommend a strategy for…
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...…
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. -- +--------------------+-------------------------------------------------------+ |…
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…