INFORMIX数据库技术手册
正在加载中...
资料简介:
目 录
数据库对象
数据块 —————————————————— 4
数据空间 ————————————————— 4
数据库 —————————————————— 4
数据表 —————————————————— 4
索引 ——————————————————— 6
视图 ——————————————————— 7
查询 ——————————————————— 7
存储过程 ————————————————— 8
触发器 —————————————————— 10
组合 ——————————————————— 11
性能调节语句分析
Set Isolation ——————————————— 11
Set Optimization ————————————— 11
Set Pdqpriority —————————————— 12
Set Lock Mode —————————————— 12
Set Log ————————————————— 12
Lock Table ———————————————— 12
Set Transaction —————————————— 12
常用命令
Set Explain ——————————————— 12
Unload to ———————————————— 12
Load —————————————————— 12
常用实用程序
onmonitor ———————————————— 13
dbaccess ———————————————— 13
dbschema ———————————————— 13
dbexport、dbimport ——————————— 13
onstat ———————————————— 13
oncheck ———————————————— 13
onmode ———————————————— 13
其他 ————————————————— 13
Esql语法
头文件的引用 ——————————————— 13
嵌入式语法 ———————————————— 13
执行动态语句 ——————————————— 14
游标使用分析 ——————————————— 15
ESQL数据类型 —————————————— 19
UNIX编译命令 —————————————— 20
环境和配置文件sqlhosts ------------------------------- 20
系统安全 ------------------------------------------ 21
配置文件(onconfig) ---------------------------------- 21
1 ADTERR ---------------------------------------- 21
2 ADTMODE -------------------------------------- 21
3 ADTPATH ---------------------------------------- 21
4 ADTSIZE ----------------------------------------- 21
5 AFF_NPROCS ----------------------------------- 22
6 AFF_SPROC ------------------------------------- 22
7 MULTIPROCESSOR ---------------------------- 22
8 NUMCPUVPS ------------------------------------- 22
9 NUMAIOVPS ------------------------------------- 22
10 SINGLE_CPU_VP --------------------------------- 23
11 ALARMPROGRAM ------------------------------- 23
12 CONSOLE ---------------------------------------- 23
13 MSGPATH ---------------------------------------- 23
14 BUFFERS ---------------------------------------- 23
15 SHMADD ---------------------------------------- 24
16 SHMBASE --------------------------------------- 24
17 SHMVIRTSIZE ---------------------------------- 24
18 SHMTOTAL -------------------------------------- 24
19 STACKSIZE -------------------------------------- 24
20 CHUNKS ----------------------------------------- 25
21 DBSPACE ---------------------------------------- 25
22 DBSPACETEMP --------------------------------- 25
23 TBLSPACES -------------------------------------- 25
24 ROOTNAME-------------------------------------- 26
25 ROOTOFFSET ------------------------------------ 26
26 ROOTPATH --------------------------------------- 26
27 ROOTSIZE----------------------------------------- 26
28 SERVERNUM ------------------------------------- 26
29 DBSERVERNAME -------------------------------- 27
30 DBSERVERALIASE ------------------------------ 27
31 NETTYPE ---------------------------------------- 27
32 MIRROR ----------------------------------------- 27
33 MIRRORPATH ----------------------------------- 28
34 MIRROROFFSET -------------------------------- 28
35 LOGFILES -------------------------------------- 28
36 LOGBUFF ---------------------------------------- 28
37 LOGSIZE ----------------------------------------- 29
38 LOGMAX ---------------------------------------- 29
39 DUMPDIR --------------------------------------- 29
40 DUMPCNT -------------------------------------- 29
41 DUMPCORE ------------------------------------- 29
42 DUMPGCORE ------------------------------------ 29
43 DUMPSHMEM ----------------------------------- 30
44 TAPEDEV ---------------------------------------- 30
45 TAPEBLK ---------------------------------------- 30
46 TAPSIZE ---------------------------------------- 31
47 LTAPEDEV -------------------------------------- 31
48 LTAPEBLK -------------------------------------- 31
49 LTAPESIZE -------------------------------------- 31
50 CHPTINTVAL ------------------------------------ 31
51 CLEARNERS ------------------------------------- 31
52 DATASKIP ---------------------------------------- 32
53 NOAGE -------------------------------------------- 32
54 FILLFACTOR -------------------------------------- 32
55 OPTCOMPIND ------------------------------------ 32
56 RESIDENT ----------------------------------------- 33
57 STAGEBLOB --------------------------------------- 33
58 TXTIMEOUT -------------------------------------- 33
59 USEOSTIME -------------------------------------- 33
60 TRANSACTIONS ------------------------------ ----- 33
61 LOCKS ------------------------------------------ 34
62 DEADLOCK_TIMEOUT ------------------------- 34
63 USERTHREADS ---------------------------------- 34
64 PHYSDBS ---------------------------------------- 35
65 PHYSFILE --------------------------------------- 35
66 PHYSBUFF --------------------------------------- 35
67 MAX_PDQPRIORITY ---------------------------- 35
68 PDQPRIORITY ---------------------------------- 36
69 DRAUTO ---------------------------------------- 36
70 DRINTERVAL ----------------------------------- 36
71 DRLOSTFOUND ----------------------------------- 36
72 DRTIMEOUT ------------------------------------- 37
73 DS_MAX_QUERIES ------------------------------- 37
74 DS_MAX_SCANS --------------------------------- 37
75 DS_TOTAL_MEMORY ---------------------------- 39
76 LRUS ------------------------------------------- 39
77 LRU_MAX_DIRTY ------------------------------- 39
78 LRU_MIN_DIRTY --------------------------------- 40
79 LTXEHWM --------------------------------------- 40
80 LTXHWM ----------------------------------------- 40
81 OFF_RECVRY_THREADS --------------------------41
82 ON_RECVRY_THREADS ---------------------------- 41
83 RA_PAGES ---------------------------------------- 41
84 RA_THRESHOLD --------------------------------- 42
数据库对象
数据块 —————————————————— 4
数据空间 ————————————————— 4
数据库 —————————————————— 4
数据表 —————————————————— 4
索引 ——————————————————— 6
视图 ——————————————————— 7
查询 ——————————————————— 7
存储过程 ————————————————— 8
触发器 —————————————————— 10
组合 ——————————————————— 11
性能调节语句分析
Set Isolation ——————————————— 11
Set Optimization ————————————— 11
Set Pdqpriority —————————————— 12
Set Lock Mode —————————————— 12
Set Log ————————————————— 12
Lock Table ———————————————— 12
Set Transaction —————————————— 12
常用命令
Set Explain ——————————————— 12
Unload to ———————————————— 12
Load —————————————————— 12
常用实用程序
onmonitor ———————————————— 13
dbaccess ———————————————— 13
dbschema ———————————————— 13
dbexport、dbimport ——————————— 13
onstat ———————————————— 13
oncheck ———————————————— 13
onmode ———————————————— 13
其他 ————————————————— 13
Esql语法
头文件的引用 ——————————————— 13
嵌入式语法 ———————————————— 13
执行动态语句 ——————————————— 14
游标使用分析 ——————————————— 15
ESQL数据类型 —————————————— 19
UNIX编译命令 —————————————— 20
环境和配置文件sqlhosts ------------------------------- 20
系统安全 ------------------------------------------ 21
配置文件(onconfig) ---------------------------------- 21
1 ADTERR ---------------------------------------- 21
2 ADTMODE -------------------------------------- 21
3 ADTPATH ---------------------------------------- 21
4 ADTSIZE ----------------------------------------- 21
5 AFF_NPROCS ----------------------------------- 22
6 AFF_SPROC ------------------------------------- 22
7 MULTIPROCESSOR ---------------------------- 22
8 NUMCPUVPS ------------------------------------- 22
9 NUMAIOVPS ------------------------------------- 22
10 SINGLE_CPU_VP --------------------------------- 23
11 ALARMPROGRAM ------------------------------- 23
12 CONSOLE ---------------------------------------- 23
13 MSGPATH ---------------------------------------- 23
14 BUFFERS ---------------------------------------- 23
15 SHMADD ---------------------------------------- 24
16 SHMBASE --------------------------------------- 24
17 SHMVIRTSIZE ---------------------------------- 24
18 SHMTOTAL -------------------------------------- 24
19 STACKSIZE -------------------------------------- 24
20 CHUNKS ----------------------------------------- 25
21 DBSPACE ---------------------------------------- 25
22 DBSPACETEMP --------------------------------- 25
23 TBLSPACES -------------------------------------- 25
24 ROOTNAME-------------------------------------- 26
25 ROOTOFFSET ------------------------------------ 26
26 ROOTPATH --------------------------------------- 26
27 ROOTSIZE----------------------------------------- 26
28 SERVERNUM ------------------------------------- 26
29 DBSERVERNAME -------------------------------- 27
30 DBSERVERALIASE ------------------------------ 27
31 NETTYPE ---------------------------------------- 27
32 MIRROR ----------------------------------------- 27
33 MIRRORPATH ----------------------------------- 28
34 MIRROROFFSET -------------------------------- 28
35 LOGFILES -------------------------------------- 28
36 LOGBUFF ---------------------------------------- 28
37 LOGSIZE ----------------------------------------- 29
38 LOGMAX ---------------------------------------- 29
39 DUMPDIR --------------------------------------- 29
40 DUMPCNT -------------------------------------- 29
41 DUMPCORE ------------------------------------- 29
42 DUMPGCORE ------------------------------------ 29
43 DUMPSHMEM ----------------------------------- 30
44 TAPEDEV ---------------------------------------- 30
45 TAPEBLK ---------------------------------------- 30
46 TAPSIZE ---------------------------------------- 31
47 LTAPEDEV -------------------------------------- 31
48 LTAPEBLK -------------------------------------- 31
49 LTAPESIZE -------------------------------------- 31
50 CHPTINTVAL ------------------------------------ 31
51 CLEARNERS ------------------------------------- 31
52 DATASKIP ---------------------------------------- 32
53 NOAGE -------------------------------------------- 32
54 FILLFACTOR -------------------------------------- 32
55 OPTCOMPIND ------------------------------------ 32
56 RESIDENT ----------------------------------------- 33
57 STAGEBLOB --------------------------------------- 33
58 TXTIMEOUT -------------------------------------- 33
59 USEOSTIME -------------------------------------- 33
60 TRANSACTIONS ------------------------------ ----- 33
61 LOCKS ------------------------------------------ 34
62 DEADLOCK_TIMEOUT ------------------------- 34
63 USERTHREADS ---------------------------------- 34
64 PHYSDBS ---------------------------------------- 35
65 PHYSFILE --------------------------------------- 35
66 PHYSBUFF --------------------------------------- 35
67 MAX_PDQPRIORITY ---------------------------- 35
68 PDQPRIORITY ---------------------------------- 36
69 DRAUTO ---------------------------------------- 36
70 DRINTERVAL ----------------------------------- 36
71 DRLOSTFOUND ----------------------------------- 36
72 DRTIMEOUT ------------------------------------- 37
73 DS_MAX_QUERIES ------------------------------- 37
74 DS_MAX_SCANS --------------------------------- 37
75 DS_TOTAL_MEMORY ---------------------------- 39
76 LRUS ------------------------------------------- 39
77 LRU_MAX_DIRTY ------------------------------- 39
78 LRU_MIN_DIRTY --------------------------------- 40
79 LTXEHWM --------------------------------------- 40
80 LTXHWM ----------------------------------------- 40
81 OFF_RECVRY_THREADS --------------------------41
82 ON_RECVRY_THREADS ---------------------------- 41
83 RA_PAGES ---------------------------------------- 41
84 RA_THRESHOLD --------------------------------- 42
2011-01-19
页数1164
浏览1340
下载27