SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)
4. Verify the status of the fileset:
info fileset mxc1,detail
5. Start the fileset:
start fileset mxc1
To enable OSS caching, perform the following steps:
1. At a TACL prompt, enter:
SCF
and then enter:
assume $zpmon
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.
RemarksActual ResultExpected ResultOperation
Table testing is created.SuccessSuccessCreate table testing(
info int);
Stmt1 is prepared with
MXCMP.
SuccessSuccessStmt1 = Prepare("
select * from
testing")
Stmt1 is executed.SuccessSuccessStmt1.execute()
Data in the table testing is
retrieved.
SuccessSuccessStmt1.fetch()
54 Starting, Configuring, and Managing MXCS










