Question & Answer
Question
Why are there SRT files in the $INFORMIXDIR/tmp ?
Cause
The files srt* stored at $INFORMIXDIR/tmp are files used for sorting when the temporary dbspace used by session listed in the DBSPACETEMP is full or when nor DBSPACETEMP is not set.
Answer
In order to avoid the creation of srt* files the recommendation is to increase the size of the temporary dbspaces listed at DBSPACETEMP onconfig parameter.
Even when the files srt* can be used instead a temporary dbspace, it is preferred to use temporary dbspace for performance purposes.
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"}],"Version":"11.1;11.5;11.7","Edition":"Developer;Enterprise;Express;Workgroup;Ultimate;Growth;Innovator","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21574134