ASCII Packing

Reduce the stable queue storage space consumed by packed commands in the inbound queue by using ASCII packing with the asynchronous parser.

Instead of the default binary packing mode for commands in the inbound queue, set ascii_pack_ibq to on for Replication Server to pack the commands using ASCII packing which consumes less stable queue storage space than binary packing. The default is off. Although binary packed commands consume more stable queue storage space, Replication Server inteprets binary packed commands more quickly than ASCII packed commands.

Setting ascii_pack_ibq on only packs the commands for the inbound queue. You cannot change the packing mode of the commands in the outbound queue as Replication Server already packs the commands using ASCII packing. You must enable the asynchronous parser feature for Replication Server to benefit from ASCII packing in the inbound queue, and you must set the Replication Server site version to 1571 or later before you can set ascii_pack_ibq on.

Example

To set the packing mode to ASCII packing for the connection from the pdb1 primary database in the TOKYO_DS data server:

alter connection to TOKYO_DS.pdb1
set ascii_pack_ibq to on
go