Can not cluster index...

Hi, Environment: windows 2003, IDS 9.4 While importing a database, it throws error - *** execute sqlobj 502 - Cannot cluster index. The dbspace and tempdbspace shows lot of free pages in onstat -d What can be the problem? Also it is very slow.... Any guidelines about configuration settings while importing a big database (more than 4 GB)? Regards, Nandkishor

Note that to build a cluster index IDS requires to create another copy of the tables sorted by the index columns. Thus if your table is xG then you need at least xG free in the same dbspace. (to check the size of the table use oncheck -pt <dbname>:<table>). You can also be running out of temporary dbspacetemp. Try re-execute the statement and monitor the free space for both (onstat -d -r 1 > onstat_d), so you can determine which dbspace is running out of space. Kenneth Penza Technical Services Officer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailpolicy.mitts.gov.mt P Please consider your environmental responsibility before printing this e-mail. END OF TEXT -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Nandkishor Singare Sent: 24 January 2007 07:01 To: ids@iiug.org Subject: Can not cluster index... [8296] Hi, Environment: windows 2003, IDS 9.4 While importing a database, it throws error - *** execute sqlobj 502 - Cannot cluster index. The dbspace and tempdbspace shows lot of free pages in onstat -d What can be the problem? Also it is very slow.... Any guidelines about configuration settings while importing a big database (more than 4 GB)? Regards, Nandkishor ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Edit the schema file and uncluster the index. If you need the data loaded clustered, then for now you can sort the data in the table's unload file into the correct order. The loaded table will effectively be clustered. If the table becomes too unordered later you can always recluster the index/table. Art S. Kagel ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 1/24 1:11:28 Hi, Environment: windows 2003, IDS 9.4 While importing a database, it throws error - *** execute sqlobj 502 - Cannot cluster index. The dbspace and tempdbspace shows lot of free pages in onstat -d What can be the problem? Also it is very slow.... Any guidelines about configuration settings while importing a big database (more than 4 GB)? Regards, Nandkishor ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.