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.
...
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...
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...
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.
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)=...
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...
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%.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.