Database Error Messages

PGA-20935

synclevel number is not allowed when PGA_CAPABILITY=string

Cause

The synclevel parameter sync passed to PGAINIT was incompatible with the setting of the PGA_CAPABILITY gateway initialization parameter, cap.


Action

If the synclevel passed to PGAINIT is correct, then the gateway initialization parameter PGA_CAPABILITY must be changed to allow the desired synclevel to be supported. If the synclevel is not correct, the TIP should be changed to specify the correct sync- level in the call to PGAINIT. If the TIP was generated by PGAU, the SYNCLEVEL keyword of the DEFINE TRANSACTION statement should be changed to specify the correct synclevel and the TIP should be regenerated. The table below shows which synclevels are valid with each PGA_CAPABILITY setting.

PGA_CAPABILITY Value SYNCLEVELs Allowed ---------------------- ------------------ READ_ONLY 0 SINGLE_SITE 0, 1 COMMIT_CONFIRM 0, 1