SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—544536-007
5-37
Rollback of DP2 Large Block
Rollback of DP2 Large Block
The SQL/MX 2.3.3 release provides large block support. The large block support
feature enables you to create objects of block size 32768 bytes (32 KB). NonStop
SQL/MX depends on DP2 for large block support.
To fall back to an earlier SQL/MX version, you must use the minimum DP2
SPR— T9053H02^ASI (available in H06.09 or later H-series RVU) or T9053H02^ATZ
(available in J06.03 or later J-series RVU).
The NonStop SQL/MX objects created with large 32 KB blocks on systems running
J06.08 or later J-series RVU or H06.19 or later H-series RVU cannot be accessed
through systems running an earlier J-series or H-series RVU. The DROP operation is
the only operation supported on such objects with 32 KB block size on the downgraded
host running on an earlier J-series or H-series RVU. NonStop SQL/MX will continue to
work normally on the 4 KB objects.
If the system running J06.07 or H06.18 RVU is used for any operation on the SQL/MX
objects with large 32 KB blocks, DP2 returns error 1189. Otherwise, error 1188 is
returned.
The following message is displayed when error 1188 or 1189 is returned:
The operation could not be performed because a software component does not
support the block size used by the table.
The following example shows the predictable errors produced by NonStop SQL/MX
after fallback.
>>delete from TAB32K;
*** ERROR[8551] Error 1188 was returned by the file system on CAT.SCH.TAB32K
(partition \DMR11.$DATA11.ZSDM92LZ.QHKDJK00).
--- 0 row(s) deleted.
>>insert into TAB32K values ( 1,'DDF','DFD');
*** ERROR[8551] Error 1188 was returned by the file system on CAT.SCH.TAB32K
(partition \DMR11.$DATA11.ZSDM92LZ.QHKDJK00).
--- 0 row(s) inserted.
>>select * from tab32k;
*** ERROR[8551] Error 1188 was returned by the file system on CAT.SCH.TAB32K
(partition \DMR11.$DATA11.ZSDM92LZ.QHKDJK00).
--- 0 row(s) selected.
>>update tab32k set b='dd' where a=1;
*** ERROR[8551] Error 1188 was returned by the file system on CAT.SCH.TAB32K
(partition \DMR11.$DATA11.ZSDM92LZ.QHKDJK00).
--- 0 row(s) updated.