JDBC/MX 5.0 Driver for SQL/MX Programmer's Reference (SQL/MX 2.x)

2. At an SCF prompt, enter the following SCF command to stop all filesets on your system:
STOP FILESET $ZPMON.*
This command begins with the last fileset mounted and stops the filesets in the reverse order in which they were
last started.
3. Stop the OSS Monitor process:
If the OSS Monitor is running as a standard process, enter the STOP command at a TACL prompt:
STOP $ZPMON
If the OSS Monitor is running as a persistent process, enter the ABORT command at an SCF prompt:
ABORT PROCESS $ZZKRN.#ZPMON
4. At the SCF prompt, enter the following set of commands for each disk volume in the fileset:
STOP DISK diskname
ALTER DISK diskname, OSSCACHING ON
START DISK diskname
diskname
is the name of a disk volume that contains OSS files.
5. Restart the OSS Monitor as a normal or persistent process with the appropriate command.
6. Restart the OSS file system by entering the SCF command:
START FILESET $ZPMON.filesetname
where, filesetname is the name of each fileset that contains OSS files, beginning with the root and specified in
the order in which mount points occur.
Known Issues
Scenario 1
MFC plans become obsolete when the base table is altered or dropped. The following sequence of operations illustrates
the issue.
Operation
Expected
Result
Actual
Result
Remarks
Create table testing(info int);
Success Success Table testing is created.
Stmt1 = Prepare("select * from testing")
Success Success Stmt1 is prepared with MXCMP.
Stmt1.execute()
Success Success Stmt1 is executed.
Stmt1.fetch()
Success Success Data in the table testing is retrieved.
Stmt1 = Prepare("select * from testing")
Success Success Compiled plan is retrieved from MFC.
Stmt1.execute()
Success Success MFC statement works as expected.
Stmt1.executeUpdate("drop table testing")
Success Success The table testing is dropped.
Stmt1.executeUpdate("create table testing
(mycol varchar(10))")
Success Success
The table testing is created with varchar
column.