Search results for query: *

For automatic failover look into using a shared storage array for both server that is managed by Veritas Cluster Server. The only problem with this is the disk storage is shared by both servers. HDR (High-Availability Data Replication) offers the same failover capabilities, with each server...

I don't remember off-hand the maximum number of extents a table can have (i think it's 220+), but here's a query to determine the number of extents allocated to your tables: database sysmaster; select dbsname[1,10] database, tabname[1,15] tablename, count(*) num_of_extents...

The sysmaster database is not a "physical" database - it's only views into shared memory segments. That being said, NEVER, EVER, EVER do any sort of db admin maintenance on the sysmaster database. You can possibly corrupt your entire instance

it looks better on a bigger window:

Send me an email and I can send you a perl script that I use to monitor space usage. The output shows the dbspace#, dbspace name, # of chunks, # of pages allocated, # of pages free, and % full. The output looks similar to this: DB spaces report Thu Oct...

I'm using oracle 8.1.6 on Sun Solaris8. I'm tryin to set up a hot standby database server, but it seems as if my standby server is "hung". I started the standby instance (no mount).....mounted the standby database.....and issued the recovery command (recover managed standby...

Unfortunatey I don't think that's possible

1566 is the process id for dbaccess 1475 is the parent process of 1566. Probably the process id for the shell.

Something is still attached to the port, probably the a user running dbaccess or the application. Shut down the application that connects to the database, and run 'ps -aef | grep dbaccess' to see if any dbacces sessions are out there. Kill them if they are. Run 'ipcs' to make sure no shared...

The informix engine already initialized. When you ran 'oninit -ivy' you initialized it. oninit: Unknown option -- Usage: oninit { -[ipsvy] } -i Initialize disk space and shared memory, leave in online mode. -p Do not reclaim temporary tables. -s Initialize shared memory, leave in...

onstat -g ntt will show you which port the sqlexec thread is connectinr to

What version of Informix are you using?

Actually, HDR (High-Availability Data Replication) is very similar to Oracle's "hot-standby". It's also very easy to setup.

<How to find in which dbspaces database objects is created?> database sysmaster; select s2.name dbspace,s1.tabname tablename,s1.owner from systabnames s1,sysdbspaces s2 where s2.dbsnum=trunc(s1.partnum/1048576) order by 1,2,3 # This will work in version 7.x and version 9.x - I'm not 100%...

what is the dbimport syntax you using? should be: dbimport <database> -d <dbspace> -l {buffered or leave blank for unbuffered}

dbimport will look into the <dbname>.exp directory for an sql file. You have to run the dbimport cmd from the directory where the .exp sub directory resides. In other words, run dbimport from the sfatest_db directory not sfatest.exp

is $INFORMIXDIR in you $PATH? ex export PATH=$INFORMIXDIR/bin:$PATH

If the dbspaces have the same path names and sizes on both servers and you have enough filesystem space you can do the following : on Server A: 1.set TAPEDEV to file (ex - /myfs/tmp/server_lvl0) - make sure the TAPESIZE is bigger than instance size 2.run ontape -s -L 0 3. compress...

What do the rest of your onconfig parameters look like??? How long are your checkpoints? What does the output of 'onstat -p' look like?

That just means the application has had to wait for buffers - a lot. Looking at your onconfig parameters, the BUFFERS are set pretty low. I would increase them to around 50000 (or higher) and see how your pct changes. For IDS.....lots of buffers are good, if you have the memory