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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bgfarmer

  1. bgfarmer

    Hardware specification for Informix Dynamic Server

    Very vague question, but look into your release notes or get with hardware vendors to see what is best for your company.
  2. bgfarmer

    INFORMIX CRASHING

    Please send copy of config file.
  3. bgfarmer

    AIX Version 5 and Informix 7.2

    Are you using 32 bit or 64 bit. If 64, then NO, Informix 7.x will not work with AIX version 5x. You will need to upgrade both AIX and Informix at same time.
  4. bgfarmer

    failing to run informix service

    Please give more information in af.40b74a9 file.
  5. bgfarmer

    why checkpoints blocked?

    Check time interval of checkpoint in onconfig file. May need to set differently depending on your system. Check size of logical log files. As stated above, they could be filling. Might need to increase the size or number. If you have the performance tuning manual, there are several things...
  6. bgfarmer

    Possible Transaction Cut

    If application, they may have amount set to commit. Example could be commit after say 10,000. I would check that first.
  7. bgfarmer

    Newbie question on volume groups

    Can someone tell me where I can find some information on how to rename a volume group? I am trying to rename a volume group from appsvg to appsold. Any help in this would be greatly appreciated!!! TIA
  8. bgfarmer

    Windows ODBC Client setup

    Do you have the entry in the /etc/services file on the system? Check sqlhosts against it
  9. bgfarmer

    How can I configure the Logical log backup

    Here is a small script that we use # Backup Informix Logical Logs to disk file export INFORMIXDIR= export PATH= export TERMCAP= export INFORMIXTERM= export TERM= export INFORMIXSERVER= export ONCONFIG= export DBSPACETEMP= CONS="/dev/console" BACKDIR="/backup&quot...
  10. bgfarmer

    IDS VERSION numbers

    7.31.FD2X2- the X means you have a patch put on the 7.31.FD2. I have never heard of 7.31.FD23. I can only assume that it is another patch of 7.31.FD2. To insure, call tech support! Regards
  11. bgfarmer

    Rowid on fragmented tables

    Thanks Shriyan, I appreciate your insight. I know all about going to primary keys instead of rowid, but right now we have several hundred apps that look at it this way. We will need a huge effort from apps to change this. It is going to be happening one of these days, but there is so much...
  12. bgfarmer

    Rowid on fragmented tables

    I have joined a company that has written all of their applications using rowid. Right now, all tables reside in single dbspaces. I want to fragment these tables by expression, but know that when this happens then rowid is thrown out. My question is, if tables are created in fragmented spaces...
  13. bgfarmer

    onperf

    Well, with onperf you can try to set your DISPLAY like DISPLAY=%ip:0.0% export DISPLAY You will need an x-windows type enviroment. Telnet will not work. Are you doing this from system console or desktop? Your question on monitoring performance every 10 minutes is rather vague. What...
  14. bgfarmer

    Help with moving volume groups

    I really appreciate all of the good info you have given. One thing I want to point out is that the ssa drives are 9gig and the scsi drives are 18gig so I am not sure I can do as the second post suggests. Here is what I was thinking of though: 1. Create a new volume group, apps2vg on the...
  15. bgfarmer

    Help with moving volume groups

    Please forgive me, but I am not an AIX admin, even though my managers have given me a title. OH, for a little training. Anyway. Here is my situation and questions. We have added some scsi drives to our system. Management wants to move one of our volume groups, appsvg, to one of these disks...
See more

Part and Inventory Search

Back
Top