Administrative API Reference

Change Isolation Level

Changes the way that DB2 isolates data from other processes while a database is being accessed.

Authorization

None

Required Connection

None

REXX API Syntax

CHANGE SQLISL TO {RR|CS|UR|RS|NC}

REXX API Parameters

RR

Repeatable read.

CS

Cursor stability. This is the default.

UR

Uncommitted read.

RS

Read stability.

NC

No commit.

Sample Programs

REXX

\sqllib\samples\rexx\chgisl.cmd