DPROPR - change qualifier to run subscription in a higher address space

If you wish to run an important subscription in a high priority address space, and assuming that you have the subscription running in a lower priority address space, then create a new apply qualifier that is associated with this higher priority address space and run the following SQL...(make sure you deactivate the subscription before doing this)

UPDATE ASN.IBMSNAP_SUBS_SET
SET APPLY_QUAL = 'NEW_QUALIFIER'
WHERE
APPLY_QUAL = 'OLD_QUALIFIER' AND
SET_NAME = 'SET_NAME' AND
WHOS_ON_FIRST = 'S';

UPDATE ASN.IBMSNAP_SUBS_MEMBR
SET APPLY_QUAL = 'NEW_QUALIFIER'
WHERE
APPLY_QUAL = 'OLD_QUALIFIER' AND
SET_NAME = 'SET_NAME' AND
WHOS_ON_FIRST = 'S';

UPDATE ASN.IBMSNAP_SUBS_COLS
SET APPLY_QUAL = 'NEW_QUALIFIER'
WHERE
APPLY_QUAL = 'OLD_QUALIFIER' AND
SET_NAME = 'SET_NAME' AND
WHOS_ON_FIRST = 'S';

UPDATE ASN.IBMSNAP_SUBS_STMTS
SET APPLY_QUAL = 'NEW_QUALIFIER'
WHERE
APPLY_QUAL = 'OLD_QUALIFIER' AND
SET_NAME = 'SET_NAME' AND
WHOS_ON_FIRST = 'S';

UPDATE ASN.IBMSNAP_PRUNE_SET
SET APPLY_QUAL = 'NEW_QUALIFIER'
WHERE
APPLY_QUAL = 'OLD_QUALIFIER' AND
SET_NAME = 'SET_NAME' AND
TARGET_SERVER = 'tgtserver';

UPDATE ASN.IBMSNAP_PRUNCNTL
SET APPLY_QUAL = 'NEW_QUALIFIER'
WHERE
APPLY_QUAL = 'OLD_QUALIFIER' AND
SET_NAME = 'SET_NAME' AND
TARGET_SERVER = 'tgtserver';