File switch can be controlled using below properties.
max_records=number Maximum size of the active file, measured by the number of records, before switching files.
Default value 50,000
Ex:
sp_ctrl> target x.file queue <queue_name> set file max_records=200000
Restart post process.
max_size=megabytes Maximum size of the file, measured in megabytes, before switching files.
Default value 50
Ex:
sp_ctrl> target x.file queue <queue_name> set file max_size=4096
Restart post process.
max_time=seconds Maximum number of seconds to wait before switching files.
Default value 300
Ex:
sp_ctrl> target x.file queue <queue_name> set file max_time=1800
Restart post process.
These three properties values are required for to restrict file switching. File switch can happen on any of the above value met and it is not possible to set unlimited.
Note: A single big transaction writes only to active file alone until it receives commit.