SAP Note 857348 - DB6: TBSCAN with SELECT * ORDER BY PRIMARY KEY

Component : DB2 Universal Database for Unix / NT -

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

Key words :
prerequisites r3load exports table data sorted, alter table <table> volatile-- exportalter table <table>, overhead> / 100-- db2stop/db2start-- exportalter tablespace <tablespace, db2 optimizer prefers index accesses, alter tablespace <tablespace, overhead>-- db2stop/db2start, make index accesses, dbslexeread failed  rc = 99, sqlstate=57011 dbsl trace, db2 explain tools

Related Notes :

857081Unicode conversion: downtime estimate