Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tm88gt

    Informix Remote Disaster Recovery

    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...
  2. tm88gt

    how do I figure possible extents and used extents to avoid running out

    ...the number of extents allocated to your tables: database sysmaster; select dbsname[1,10] database, tabname[1,15] tablename, count(*) num_of_extents, sum( pe_size ) total_size from systabnames, sysptnext where partnum = pe_partnum group by 1, 2 order by 3 desc, 4 desc;
  3. tm88gt

    Defragmenting Systables

    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
  4. tm88gt

    informix space usage

    it looks better on a bigger window:
  5. tm88gt

    informix space usage

    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...
  6. tm88gt

    Hot Standby help

    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...
  7. tm88gt

    Recovering data from a tape(with ontape)

    Unfortunatey I don't think that's possible
  8. tm88gt

    Informix error 25572

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

    Informix error 25572

    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...
  10. tm88gt

    Cannot attach shared memory errno=156

    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...
  11. tm88gt

    ports used by informix

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

    ports used by informix

    What version of Informix are you using?
  13. tm88gt

    Is there anything in Informix that

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

    dbspace allocation for database objects

    <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%...
  15. tm88gt

    Data Migration

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

    Data Migration

    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
  17. tm88gt

    IDS install and configuration on Solaris

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

    Data Migration

    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...
  19. tm88gt

    Could increasing BUFFERS increase the checpoint time?

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

    Monitor DB Health.

    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

Part and Inventory Search

Back
Top