Dell EMC Solutions Enabler 9.2 SRDF Family CLI User Guide

If a split operation impacts the access integrity of a database, additional operations such as freezing may be necessary. The freeze operation suspends writing database updates to disk.

Use the freeze operation in conjunction with the split operation.

Use the symioctl command to invoke I/O control operations to freeze access to a specified relational database or database objects.

Freeze access to a database

To freeze all I/O access to a specified relational database:

symioctl freeze -type DbType Object Object

SQL Server allows some or all databases to be specified. Oracle and Informix allow you to freeze or thaw an entire DB array.

If you have set the connection environment variables, the syntax is:

symioctl freeze Object Object

To freeze databases HR and Payroll:

symioctl freeze HR Payroll

Thaw access to a database

Once the freeze operation is complete, the split can proceed.

When the split operation is complete, use the symioctl thaw command to resume full I/O access to the database instance.

To resume I/O access:

symioctl thaw

Oracle databases: Hot backup control

For Oracle only, you can perform hot backup control on a list of tablespace objects. Hot backup control must be performed before and after a freeze/thaw command.

The steps required to split a group of SRDF pairs are:

1. Use the symioctl begin backup command.
2. Use the symioctl freeze command.
3. Split the SRDF pairs. This may involve several steps depending on your environment.
4. Use the symioctl thaw command.
5. Use the symioctl end backup command.