Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:troubleshooting-guide:informix:export-conversion:data:cannot-sort-rows [November 13, 2018, 12:53:31 PM]
alexandr.kirpichny
sqlways:troubleshooting-guide:informix:export-conversion:data:cannot-sort-rows [May 03, 2019, 08:15:19 AM] (current)
darya.prikhodkina
Line 4: Line 4:
 \\ \\
  
-====== [Informix] Cannot sort rows. ======+====== [Informix] Cannot Sort Rows ======
  
-===== Symptoms =====+===== Description =====
  
-When migrating from huge Informix database, during the conversion stagesome tables may fail with the following error:+When migrating from huge Informix database, during the conversion stage some tables may fail with the following error:
  
    <<<<SQLError    <<<<SQLError
Line 16: Line 16:
 ===== Cause ===== ===== Cause =====
  
-Usually this is a problem with the temp dbspace of the informix server. Not enough space. +Usually it is a problem with the temp dbspace of the Informix server. Not enough space. 
-Also this situation may appearduring the conversion stagebecause our tool uses only select query with ORDER BY clause to get the information about all the columns in all selected tables. +Also this situation may appear during the conversion stage because our tool uses only select query with ORDER BY clause to get the information about all the columns in all selected tables. 
  
 ===== Solution ===== ===== Solution =====
  
-You can open the options fileby clicking "Edit Options File" buttonon the "Review the Selections" page in SQLWays Wizard tool. And in the opened file, in the [_WZD_COMMON] section set PRECACHE_OBJECTS option equal to "No".+Please open the options file by clicking "Edit Options File" button on the "Review the Selections" page in SQLWays Wizard tool. In the [_WZD_COMMON] section of the opened file please set PRECACHE_OBJECTS option equal to "No".
  
-If the solution with the PRECACHE_OBJECTS option didn't solve the issue, then please check the amount of free space in the temp dbspace. Run **ccmsrv status -all -s <dbserver>** to get the status of the servers dbspaces. If the free space is less than half the total there may be a problem.  Taking the server offline and back online will free up space in the temp dbspace:+If the solution with the PRECACHE_OBJECTS option doesn't solve the issue, please check the amount of free space in the temp dbspace. Run **ccmsrv status -all -s <dbserver>** to get the status of the servers dbspaces. If the free space is less than half of the totalthere could be a problem. Taking the server offline and back online will free up space in the temp dbspace:
  
 **ccmsrv offline -s <dbserver>** **ccmsrv offline -s <dbserver>**
Line 29: Line 29:
  
  
-If the problem continues, increase the size of the temp dbspace with the **ccmsrv expand** command.+If the problem is not resolvedplease increase the size of the temp dbspace with the **ccmsrv expand** command.
  
 \\ \\
 //__**Ispirer Notification:**__// //__**Ispirer Notification:**__//
  
-If you want to set PRECACHE_OBJECTS option equal to "Yes"in order to improve the performance of conversion stage, please note that the number of selected tables should be greater than 50% of all the table created in the database. Only in that case it will improve the performance.+If you want to set PRECACHE_OBJECTS option equal to "Yes" in order to improve the performance of conversion stage, please note that the number of selected tables should be greater than 50% of all the tables created in the database. The performance will be improved only in this case.
  
 ====== ====== ====== ======
sqlways/troubleshooting-guide/informix/export-conversion/data/cannot-sort-rows.txt · Last modified: May 03, 2019, 08:15:19 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement