Hello,
In 10.2A, what is the max key size for an index in a temp-table ?
I'm being hit by error 11353 when copying records from a table to a temp-table (define tt like table). An indexed character field contains more than 180 characters, which is not a problem in 10.2 as max key size is around 1900 characters, but it seems to be a problem for temp-tables. Is there a way to fix this problem ? Apart from removing the offending index in the temp-table definition…
Gilles
Check your -tmpbsize setting. PSC defaults this value to 4K to accomodate longer keys, but if your client's running w/1K, this error could be the result.
Try a larger -tmpbsize (and adjust -Bt down as well to keep the memory usage the same), and see what happens.
Excellent, that's it !
Thanks a lot Tim !