Informix Knowledge Collection

How do I use the Dbschema tool to unload the structure of the database < 澁 v?
For example: 珃? ? T?
1 Export all table structures in the database to the file Db.sql 剉 Zeng M Ying 孃?
$>dbschema-d your_database-t all Db.sql Q. $ puppets???
2 export all stored procedures in the database to the file Db.sql monopolistic brings? Hou ^ "?
$>dbschema-d your_database-f all Db.sql c€^b? E remainders?
3 Export all objects in the database (including tables, stored procedures, triggers ...). ) to the file Db.sql x-xkv? 弝
$>dbschema-d your_database Db.sql?? $?
4 Export the structure of a table in the database to file Db.sql??? D 潁 y
$>dbschema-d your_database_name-t your_table_name db.sql Luo Oval redemption%p
5 Export a stored procedure definition to file Db.sql f8v 蘰 憇??
$>dbschema-d your_database_name-f your_procedure_name db.sql remainder?? o& Gang 睵
6 If you export more table information (EXTENT ...)  -d 緄
$>dbschema-d Your_database_name-ss Db.sql | R?? 籢?
7 Export authorization information for a user or role in the database accomplishment y 蚟 O?
$>dbschema-d your_database_name-p all x/???? W
$>dbschema-d your_database_name-r all 舦 "?? H?0?
8) to export synonyms in the database [筰 p.vav
$>dbschema-d your_database_name-s all end up 漦 +?: Translation?
崨 h) overflow d?
Query out all the user tables in a database k^ stylish enough 翉 coupon D (
SELECT * from Systables o eel with 牔 beach? 詁
where TabID > 99 貀 齾? 蚠
TabName the name of the deposit table N. The tapir of the kidney
Tabtype table type t= tables, e= external tables, v= view ...?? FⅢ4A asks
SQL Reference Guide nrows number of rows in the table ncols the number of columns in the table L 馣 v7 tip?
? @ C T front-line
Onstat-d look at how your database space is distributed? 褍 è.
04Nw 烋? harrier
If you do not specify parameters when doing dbimport, the entire database will be built on the Rootdbs.??? b Waste 
If the database space planning is relatively thin, there should be dedicated to loading data dbspace. Ulva hairs? ' u 儧?
//***************************************************************************** ?? ~??
Export data? 6 壥 庎 
Unload to Database.txt/V 鎩, Fu
Select ...,? Y€ 哸? 4?
From ...? Qfe 蜔?
Where .... & Tan 逰 帲 G!
Import data t# 閻? 嶢 Chang?
Load from database *.txt INSERT INTO tablename? 劯???
€ 鱮 ⅵot?
Submit the Table Script dbaccess Db_das (database name)-< CREATE TABLE script to generate the required table E??
dbaccess Db_das db.sql m 鷺 鶽??
Db.sql is exported with dbschema-d db_das-t all db.sql. U 寑 渹
襜 秞 F. G
At the same time generate dbspace and block 蒍 N & 1?
?} Silence  fermentation 3.
Onspaces-c-D dbspaces1-p d:/ifmxdata/ol_chinaren5/ol_chinaren5_dat.000-o 0-s 200000 4 fear?? 惽 瘑
Jq1d? Q??
In this example, a new dbspace named Dbspace1 and its initial block is generated; J}??? +f
Allocated in Disk d:/ifmxdata/ol_chinaren5/ol_chinaren5_dat.000, 鸃 h Guo???
The offset is O. The initial length is 200MB (200000KB). 樖 j_ 爩
] 溓 [&f unconscious 8u
With the Onspaces command in the Dbspace add block u 巬 Gao Songhu acupoints?
? 9??? C
Onspaces-a dbspace1-p d:/ifmxdata/ol_chinaren5/ol_chinaren5_dat.000-o 200000-s 50000 Gkn?-i
Function: Add 50M space to Dbspace1 in d:/ifmxdata/ol_chinaren5/ol_chinaren5_dat.000 = 釫 R 樕 躖 ~
The-O offset must be the size of the existing space s B4 矑?? K 蛒
5b>?? ~ox=
% of% Kun q)-
Allocate NTFS file space 滶 for database space, blob space, or SB space? F?? R?
I pound # put XK 阯
Enter the directory where you want to store the file space D:/ifmxdata/ol_chinaren5} 娪 {Tantra ??
3j 娪?
Execute command copy nul my_chunk_dat.000 diligently? _2 嫷
A new file with a my_chunk_dat.000 size of 0 鄊 爎 斉? 覣
And then using Onspaces to expand the size of space and allocate dbspace 檡 b6fz<
M. Hygienic 稉 =nj
Y 虒? Duan P?
Delete Dbspace f? o 毼. 艢?
<]nc?? ＃
onspaces-d Dbspace1  Lo Younger generation
Delete the dbspace space named Dbspace1?? P?/fz? bespectacled
Whisk 圀?, @ Woonyoungia
k> 庉
Qke% 曏 o?lt;?
Dbimport Import data Element 膉 僢 u 豅 7
橯 > ridiculed ば drops?
Running the database server DOS interface input OnInit alchemy b@ "6 clams
In running a database server DOS interface s deployment ao Yozakku ?
Direct input: Dbexport-o d:/informix db_das > Self-forgiveness ^h}@p
< saved directory > database to export w this 烳 惉 鯱?
Or: Dbexport-c-o d:/informix db_das 俋 ts 籞 9x??
Export completion will prompt Dbexport completed! The export process may be a bit slow (wait) ^?7 fascine.?
After the export is completed, a folder Db_das.exp (exported database name. exp) is generated under < saved directory >. Iridium 圥 塣 嵅 N
ユw 猲 Hz?
Import Database 7l You home ??
Input: dbimport-c-i d:/informix db_das┻y1! 崬 m 瓚
<db_das.exp directory > imported database name Erosion 旵? * 萐? *
Or: dbimport-c-x-i d:/informix/temp db_das-d practice b)? ' 琝 6?
-C instructs Dbimport to complete the import, even if it encounters some non-fatal errors? 窶 IP Hangings 甗
-X recognizes hex binary data make matters worse in character fields? P?▍ 峔 L
-I specifies the full pathname of the Database.exp directory on the disk, and the directory name should be the same as the database name 敹 G Pei F 繈
-d Specifies the data space to create the database υg[? 飝 蔅 W
? 靮?? 籯
Renaming the database changes the. Exp Directory name first, changing the. SQL schema file name: 怽 xh?
The directory name must be the same as the schema file name G 顣 棬?? 2?
K3a 躛 '?
Import complete will be prompted!?/your? W creep?