Hi,

When using a Java client with IDS 9.3 on Windows 2k server, I am encountering error code -567. Iam using the Informix JDBC 2.21 JC3 driver.

The problem comes when I am trying to get the columns information via a call to getColumns(..) method of java.sql.DatabaseMetaData.


The stack trace is:
=============================
at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:348)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav a:3000)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3310)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2263)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2183)
at com.informix.jdbc.IfxSqli.sendStatementQuery(IfxSq li.java1400)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java1353)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java1283)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxRes ultSet.java:219)
at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:815)
at com.informix.jdbc.IfxStatement.executeQuery(IfxSta tement.java:171)
at com.informix.jdbc.IfxDatabaseMetaData.getColumns(I fxDatabaseMetaData.java:3504)
=========================

I am using a transactional database(created with log).


Does anyone have any idea of why it should occur?

Thanks,
Sumanto

Make sure that you have a temporary dbspace
in your IDS server. You can check this with
'onstat -d' and look for a 'T' in the 'flags' column.

Also make sure that this temporary dbspace is specified
in DBSPACETEMP in your $ONCONFIG.

Thanks a lot for the help !!

How do I do a level-0 backup? When I do a:

"ontape -s"

I get:

"Please enter the level of archive to be performed (0, 1, or 2) 0

Please mount tape 1 on \\.\TAPE0 and press Return to continue ..."

How do I do the mounting? I am using a Win2k server.

Thanks in advance,

Regards,
Sumanto

Hi,

I was able to do it after changing the TAPEDEV in $ONCONFIG. I also had to change TAPESIZE so that it doesn't ask for a second disk.

Is there a more elegant way?

Thanks in advance,
Sumanto