Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    9

    Unanswered: Error code -567 when accessing via Java client

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Apr 2003
    Posts
    9

    Level-0 backup in Windows

    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

  4. #4
    Join Date
    Apr 2003
    Posts
    9

    Was able to do level-0 backup

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •