SAP Note 85067 - Accelerating 'Create index' using PDQ

Component : Database Administration with Informix - Informix

Solution : https://service.sap.com/sap/support/notes/85067 (SAP Service marketplace login required)

Key words :
table fragments setenv pdqpriority 100 setenv psort_nprocs  <number numcpuvps> execute, ds_max_queries  <max-dss queries parallel im system>  # maximum number, max_pdqpriority <max-pdq priority>maximum allowed pqpriority, <max pdq priority allowed>sets max_pdqpriority onmode -, <max # ds_queries>sets ds_max_queries onmode -, <max # ds_scans>sets ds_max_scans solution, pdqpriority  <max-pdq priority>, ds_total_memory <max-dss memory>, ds_max_scans <max-scan threads>, kb>sets ds_total_memory onmode -

Related Notes :

607638
548943FAQ: Avoiding disk space problems
510019
83183Fragmentation: Basics - decision help
79191Creating 'detached indexes'
79070Table fragmentation: procedure