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!

  • Congratulations Mike Lewis 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. roelwe

    Problem linking Informix to MS Access via ODBC

    I assume this is an MS Access issue. Aren't there options you can click? Try a connection with another tool. You can download several SQL tools for windows platforms. Check your connection with Ilogin Demo. ...
  2. roelwe

    dbdump taking very long time after fiber upgrade

    First of al: How do you do your dbdump? You should check I/O queues. Is your kernel I/O on? check onstat -g ioq and onstat -g iof. to see what thread is performing the i/o. I checked your onconfig parameters: Since you have 3 CPU VPs, you don't need a NETTYPE on a NET VP. I would set it to...
  3. roelwe

    ODBC And Informix Sessions

    You could use sqldebug. An environment variable that traces your communication between server and client. You can also trace the parsed sql statements with onstat -g sql <sess-id>. An existing session is already assigned to a userthread, sqlexec. check onstat -g ntt. A session is never the...
  4. roelwe

    Multiple databases

    I'm not really sure about oledb, but it wcertainly works with odbc. Every connection creates a sqlexec thread, which you can monitor with onstat -g ntt or onstat -g sql or onstat -g ses.
  5. roelwe

    table statistics

    In the sysmaster database, you find the table sysptnhdr. This table contains three fields of your interest: npused, nptotal, npdata. Just to make myself clear: TBLspace is the total amount of extend allocated by a table or table partition. It is uniquely identified by a partnum. hex(partnum)=...
  6. roelwe

    how to append logical log backup to full system backup tape?

    You could backup your logical logs to file and append them manually to tape. Usually if you define the same tape-device in the %ONCONFIG% for LTAPEDEV and TAPEDEV (assuming you work with ontape), the server should append it automatically. If you do your backups with onbar and a storage manager...
  7. roelwe

    New to informix

    The Informix GUI installer creates a shortcut in the startmenu. This shortcut opens a dos window with the correct environment variables. It launches a .bat file that resides in the %INFORMIXDIR%.

Part and Inventory Search

Back
Top