Kbase 18384: DBE: How Do I Make a Single-Volume Database With 8k Blocks?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/6/2004 |
|
Status: Verified
GOAL:
How to make a single-volume double-byte enabled database which uses an 8k blocksize.
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FIX:
The following example uses traditional Chinese, but can also be applied to simplified Chinese, Korean, or Japanese.
1) prodb newdb $DLC/empty8 ==> newdb will be 8k block with code page iso8859-1
2) proutil newdb -C convchar convert undefined
3) proutil newdb -C convchar convert BIG-5 ==> newdb now is with code page BIG-5, but the collation is still iso8859-1/basic.
4) Invoke Data Administration with parameters -cpinternal BIG-5 -cpstream BIG-5, then load $DLC/prolang/tch/_tran.df to change the collation to BIG-5/basic
5) proutil newdb -C idxbuild all -cpinternal BIG-5 -cpstream BIG-5 ==> changing the collation table will require an index rebuild.