Hello,

where is the "trace control file" of the XML Extender located please?

I think I need this information in order to attack the following problem:

When calling the procedure dxxEnableColumn via JDBC, I get no exception, but the column is *not* enabled for XML and the message code and text are -49 and 38X03, respectively. (If I call the procedure directly from the DB2 command line interface, everything works correctly.) The description for SQLSTATE codes of XML Extender says:

SQLSTATE 38X03
DXXC003E
The XML Extender is unable to write data to the file.

DXXC011E
The XML Extender is unable to write data to the trace control file.

Since, at least to my knowledge, dxxEnableColumn doesn't explicitly write on a file, the second description seems to be applicable. But I can't find any information on the trace control find. I tried to switch db2trc and dxxtrc on and off, with always getting the same result.

I'm using DB2 version 7.2 Fixpak 9 with XML Extender Fixpak 7 and JDBC 2.0 on Linux.

The code is the following:

System.out.println("Enabling fits_tab...");
call = con.prepareCall("call db2xml.dxxEnableColumn ( ?, ?, ?, ?, ?, ?, ?, ?, ?)");

// IN:
call.setString(1,"fits");
call.setString(2,"fits_tab");
call.setString(3,"fitsXML");
call.setString(4,dadString);
call.setString(5,"USERSPACE1");
call.setString(6,"fits_view");
call.setString(7,"ffile");

// OUT:
call.registerOutParameter(8, Types.INTEGER);
call.registerOutParameter(9, Types.VARCHAR);
msgCode = 0;
msgTxt = "";

call.execute();

msgCode = call.getInt(8);
msgTxt = call.getString(9);

System.out.println(msgCode);
System.out.println(msgTxt);
System.out.println("fitsXML enabled.");

(The variable dadString is a String variable containing the dad-File as a String.)

The output generated is:

Enabling fits_tab...
-49
38X03
fitsXML enabled.

Has anyone got a clue where to look?

Yours,
Holger