Aeieeaae ia oaio
“NOAAe INFORMIX. Aaeieieno?e?iaaiea e aaciianiinoue”
ii i?aaeiaoo “Ei?ii?aoeaiua aacu aeaiiuo”
nooaeaioa V-ai eo?na OEI INO
I?ioi?iaa Aiae?ay Aeoaeeaae/a
Eeaa, 1998
Aaciianiinoue
A na?aa?ao aac aeaiiuo oe?iu INFORMIX iiaeii ia?aie/eoue eee aiana
cai?aoeoue iieueciaaoaeyi aeinooi e aeaiiui. Aeinooi iiaeii ia?aie/eoue
ia neaaeothueo /aou?ao o?iaiyo:
1. A neo/aa, anee AAe o?aieony a oaeeao iia?aoeeiiiie nenoaiu,
ia?aie/aieai aeinooia iiaeii oi?aaeyoue n iiiiuueth n?aaenoa IN. Iaeiaei
yoio o?iaaiue iaaeinooiai i?e eniieueciaaiee na?aa?a INFORMIX-OnLine.
Yoi yae?i naii oi?aaeyao nianoaaiiui aeeneiaui i?ino?ainoaii e i?aaeea
iia?aoeeiiiie nenoaiu caeanue ia i?eiaieiu.
2. Iiaeii eniieueciaaoue iia?aoi?u GRANT e REVOKE, /oiau i?aaeinoaaeoue
eee cai?aoeoue aeinooi e AAe eee ioaeaeueiui oaaeeoeai, a oaeaea
?ac?aoaoue eee cai?auaoue i?iaiaeeoue iieueciaaoaeyie ioaeaeueiuo
iia?aoeee iaae AAe.
3. Iiaeii eniieueciaaoue iia?aoi? CREATE VIEW aeey nicaeaiey
ia?aie/eaathuaai eee iaiiaeyaiiai i?aaenoaaeaiey. Ia?aie/aiey iiaoo
auoue ai?eciioaeueiuie (eneeth/athuea iaeioi?ua no?iee) eee
aa?oeeaeueiuie (eneeth/athuea iaeioi?ua noieaoeu) eee iaeiia?aiaiii
aa?oeeaeueiuie e ai?eciioaeueiuie.
4. Aeiioneaaony eniieueciaaiea iia?aoi?a GRANT niaianoii n iia?aoi?ii
CREATE VIEW aeey aeinoeaeaiey aieaa iieiiai eiio?iey iaae /anoyie
oaaeeoeu e aeaiiuie, eioi?ua iieueciaaoaeue iiaeao eciaiyoue.
Aaciianiinoue ia o?iaia oaeeia
ssae?a aac aeaiiuo INFORMIX (ca eneeth/aieai INFORMIX-OnLine) o?aiyo
aacu aeaiiuo a oaeeao iia?aoeeiiiie nenoaiu. Oaeeu nia?aiu a eaoaeiaa,
eioi?ue i?aaenoaaeyao aaco aeaiiuo a oeaeii. Iiaeii cai?aoeoue aeinooi e
aaca aeaiiuo, cai?aoea aeinooi e eaoaeiao aacu aeaiiuo n?aaenoaaie
iia?aoeeiiiie nenoaiu.
I?aaeinoaaeaiea i?eaeeaaee
?ac?aoaiea ia eniieueciaaiea aacu aeaiiuo iacuaaaony i?eaeeaaeae.
Iai?eia?, ?ac?aoaiea ia eniieueciaaiea aacu aeaiiuo aiiaua iacuaaaony
i?eaeeaaeae CONNECT, oiaaea eae ?ac?aoaiea ia aeiaaaeaiea no?ie a
oaaeeoeo iacuaaaony i?eaeeaaeae INSERT. Iiaeii oi?aaeyoue aeinooiii e
aaca aeaiiuo, i?aaeinoaaeyy i?eaeeaaee iieueciaaoaeyi eee ioiaiyy eo.
I?eaeeaaee aeaeyony ia aeaa a?oiiu: iaeia a?oiia i?eaeeaaee eanaaony
aacu aeaiiuo a oeaeii, ae?oaay – ioaeaeueiuo oaaeeoe.
I?eaeeaaee aacu aeaiiuo
O?e o?iaiy i?eaeeaaee aacu aeaiiuo iaania/eaatho iauea n?aaenoaa
oi?aaeaiey oai, eoi eiaao aeinooi e aaca aeaiiuo.
I?eaeeaaey CONNECT
I?eaeeaaeae naiiai ieaeiaai o?iaiy yaeyaony i?eaeeaaey CONNECT, eioi?ay
i?aaeinoaaeyao iieueciaaoaeth aaciaua aiciiaeiinoe cai?aoeaaoue e
iaiiaeyoue oaaeeoeu. Iieueciaaoaeue n yoie i?eaeeaaeae iiaeao
i?iecaiaeeoue oaeea iia?aoeee:
Auiieiyoue iia?aoi?u SELECT, INSERT, UPDATE e DELETE i?e iaee/ee
iaiaoiaeeiuo i?eaeeaaee o?iaiy oaaeeoeu;
Nicaeaaaoue i?aaenoaaeaiey i?e oneiaee, /oi aio ?ac?aoaii cai?aoeaaoue
oaaeeoeu, ia eioi?uo iniiaaiu i?aaenoaaeaiey;
Nicaeaaaoue a?aiaiiua oaaeeoeu e eiaeaenu ia ieo. Aeey yoiai
iieueciaaoaeue aeieaeai iaeaaeaoue i?eaeeaaeae CONNECT. Iau/ii, anee AAe
ia niaea?aeeo eiioeaeaioeeaeueiie eioi?iaoeee, n?aco iinea nicaeaiey
aacu aeaiiuo auiieiyaony iia?aoeey GRANT CONNECT TO PUBLIC.
I?eaeeaaey RESOURCE
Aeaiiay i?eaeeaaey i?aaeinoaaeyao oa aea aiciiaeiinoe, /oi e i?eaeeaaey
CONNECT, e?iia oiai, iieueciaaoaeue n i?eaeeaaeae RESOURCE iiaeao
auiieiyoue neaaeothuea iia?aoeee:
Eciaiyoue ii?aaeaeaiey nouanoaothueo oaaeeoe iooai oaeaeaiey eee
aeiaaaeaiey ii?aaeaeaiiuo noieaoeia, eiaeaenia;
Nicaeaaaoue iiaua iinoiyiiua oaaeeoeu e eiaeaenu e iei.
I?eaeeaaey aaeieieno?aoi?a aac aeaiiuo
Ia aunoai o?iaia eo o?ao o?iaiae i?eaeeaaee aacu aeaiiuo iaoiaeyony
i?eaeeaaee aaeieieno?aoi?a aacu aeaiiuo (AAAe). Nicaeaoaeue aacu aeaiiuo
aaoiiaoe/anee noaiiaeony aa aaeieieno?aoi?ii. Iieueciaaoaeue yoiai
o?iaiy aeinooia iiaeao inouanoaeyoue neaaeothuaa:
Anoaaeyoue, oaeaeyoue eee eciaiyoue no?iee a ethaie ec oaaeeoe
nenoaiiiai eaoaeiaa ca eneeth/aieai systables;
Oaeaeyoue eee eciaiyoue ethaie iauaeo iacaaeneii io oiai, eiio ii
i?eiaaeeaaeeo;
Nicaeaaaoue, oaaeeoeu, eiaeaenu e i?aaenoaaeaiey, eioi?ua aoaeoo
i?eiaaeeaaeaoue ae?oaei iieueciaaoaeyi;
I?aaeinoaaeyoue i?eaeeaaee aacu aeaiiuo, aeeth/ay i?eaeeaaeth AAAe.
I?eaeeaaee iieueciaaoaeae e ae?oaea iauaaeinooiiua i?eaeeaaee
I?eaeeaaee i?aaeinoaaeythony ioaeaeueiui iieueciaaoaeyi ii eo eiaiai,
eee anai iieueciaaoaeyi – iiae eiaiai PUBLIC. Ana i?eaeeaaee,
i?aaeinoaaeaiiua iiae eiaiai PUBLIC, aeaenoaotho eae i?eaeeaaee ii
oiie/aieth. I?aaeaea, /ai auiieieoue iia?aoi?, yae?i aacu aeaiiuo
ii?aaeaeyao, ?aniieaaaao ee iieueciaaoaeue iaiaoiaeeiuie i?eaeeaaeyie.
Nia/aea yae?i euao i?eaeeaaee, i?aaeinoaaeaiiua eiaiii aeaiiiio
iieueciaaoaeth. Anee iaiaoiaeeiua i?eaeeaaee iaia?oaeaiu, oi iie
i?aaeinoaaeythony aeaiiiio iieueciaaoaeth. Anee aea iieueciaaoaeth oaeea
i?eaeeaaee ia i?aaeinoaaeaiu, oi na?aa? euao eo n?aaee iauaaeinooiiuo.
Anee oaeea iaeaeaiu, oi yae?i eniieuecoao eo. Oaeei ia?acii, iiaeii
onoaiiaeoue ieieiaeueiue o?iaaiue i?eaeeaaee aeey iieueciaaoaeae,
i?aaeinoaaea i?eaeeaaee PUBLIC. A eiie?aoiuo neo/ayo yoe i?eaeeaaee
iiaoo auoue ia?ae?uou iooai i?aaeinoaaeaiey iieueciaaoaeth aieaa
neeueiuo i?eaeeaaee.
Anee i?eaeeaaey CONNECT ia aeaeaaony iauaaeinooiiie, oi aeinooi e aaca
aeaiiuo niiaoo iieo/eoue oieueei oa iieueciaaoaee, eioi?ua eiatho yoio
o?iaaiue i?eaeeaaee.
I?aaa aeaaeaiey
Aaca aeaiiuo, oae aea, eae e eaaeaeay oaaeeoea, i?aaenoaaeaiea eee
eiaeaen e neiiiei yoie aacu eiaao naiaai aeaaeaeueoea. Iau/ii
aeaaeaeueoeai AAe yaeyaony oio, eoi aai nicaeae, oioy aaeieieno?aoi?
aacu aeaiiuo iiaeao nicaeaaaoue iauaeou, eioi?ua noaiiayony
i?eiaaeeaaeaueie ae?oaei iieueciaaoaeyi. Aeaaeaeaoe iauaeoa eiaao ia
iaai ana i?aaa e iiaeao eciaieoue eee oaeaeeoue iauaeo aac eaeeo-oi
aeiiieieoaeueiuo i?eaeeaaee. I?eaeeaaee ioaeiu oieueei aeey
iieueciaaoaeae, eioi?ua ia yaeythony aeaaeaeueoeaie iauaeoa.
I?eaeeaaee o?iaiy oaaeeoeu
Nouanoaoao oanoue i?eaeeaaee o?iaiy oaaeeoeu, iicaieythueo ia?aaeaoue
iieueciaaoaeyi, ia yaeythueony aeaaeaeueoeaie oaaeeoeu, i?eaeeaaee
aeaaeaeueoea. *aou?a ec ieo – SELECT, INSERT, UPDATE e DELETE –
oi?aaeytho aeinooiii e niaea?aeeiiio oaaeeoeu. I?eaeeaaey INDEX
oi?aaeyao nicaeaieai eiaeaena. I?eaeeaaey ALTER ii?aaeaeyao
aiciiaeiinoue eciaiyoue ii?aaeaeaiea oaaeeoeu. A ANSI-niaianoeiuo aacao
aeaiiuo i?eaeeaaee ia oaaeeoeo n?aco iinea aa nicaeaiey eiaao oieueei
aeaaeaeaoe. A ae?oaeo aacao aeaiiuo yae?i a i?ioeanna nicaeaiey oaaeeoeu
aaoiiaoe/anee aeaeaao ana oaaee/iua i?eaeeaaee, ca eneeth/aieai
i?eaeeaaee ALTER, iauaaeinooiiuie. Yoi icia/aao, /oi oieueei /oi
nicaeaiiay oaaeeoea iiaeao auoue aeinooiia iieueciaaoaeth, eioi?ue eiaao
i?eaeeaaeth CONNECT. Anee yoi iaaeaeaoaeueii, oi iinea nicaeaiey
oaaeeoeu aa aeaaeaeaoe aeieaeai ioiaieoue ana i?eaeeaaee,
i?aaeinoaaeaiiua PUBLIC a nayce n yoie oaaeeoeae.
I?eaeeaaey aeinooia
*aou?a i?eaeeaaee oi?aaeytho oai, eae iieueciaaoaeue iiaeao ia?auaoueny
e oaaeeoea. Aeaaeaeaoe oaaeeoeu iiaeao i?aaeinoaaeyoue eee ia
i?aaeinoaaeyoue, iacaaeneii iaeia io ae?oaie, neaaeothuea i?eaeeaaee:
I?eaeeaaey SELECT iicaieyao aeaeaoue auai?eo, a oii /enea ai a?aiaiiua
oaaeeoeu;
I?eaeeaaey INSERT iicaieyao aeiaaaeyoue a oaaeeoeo iiaua no?iee;
I?eaeeaaey UPDATE iicaieyao eciaiyoue nouanoaothuea no?iee;
I?eaeeaaey DELETE iicaieyao oaeaeyoue no?iee.
I?eaeeaaey SELECT iaiaoiaeeia aeey auai?ee niaea?aeeiiai oaaeeoeu,
iaeiaei yoa i?eaeeaaey ia yaeyaony iaiaoiaeeiie aeey iaeaaeaiey ae?oaeie
i?eaeeaaeyie. Iieueciaaoaeue iiaeao eiaoue i?eaeeaaee INSERT eee UPDATE,
ia eiay i?e yoii i?eaeeaaee SELECT.
I?eaeeaaee INDEX e ALTER
I?eaeeaaey INDEX iicaieyao nicaeaaaoue e eciaiyoue eiaeaenu a oaaeeoeao.
Yoa i?eaeeaaey, oae aea, eae e i?eaeeaaee SELECT, INSERT, UPDATE,
DELETE, noaiiaeony iauaaeinooiiie iinea nicaeaiey oaaeeoeu. Iiaeii
i?aaeinoaaeoue i?eaeeaaeth INDEX anai iieueciaaoaeyi, ii niiaoo
iieueciaaoueny ath oieueei oa iieueciaaoaee, eoi eiaao i?eaeeaaeth
RESOURCE o?iaiy aacu aeaiiuo. Oaeei ia?acii, oioy i?eaeeaaey INDEX
i?aaeinoaaeyaony aaoiiaoe/anee (e?iia ANSI-niaianoeuo aac aeaiiuo),
iieueciaaoaee, iaeaaeathuea oieueei i?eaeeaaeae o?iaiy aacu aeaiiuo
CONNECT ia niiaoo ainiieueciaaoueny i?eaeeaaeae INDEX. Yoi eiaao niune,
eiaaea eiaeaeniua oaeeu caieiatho iiiai ianoa ia aeenea.
I?eaeeaaey ALTER iicaieyao iieueciaaoaeth eniieueciaaoue iia?aoi? ALTER
TABLE, aeeth/ay aiciiaeiinoue aeiaaaeyoue e oaeaeyoue noieaoeu e o.ae.
Neaaeoao i?aaeinoaaeyoue aeaiioth i?eaeeaaey oieueei oai iieueciaaoaeyi,
eioi?ua oi?ioi iiieiatho iiaeaeue aacu aeaiiuo e aeinoaoi/ii
eaaeeoeoee?iaaiu, /oiau eniieueciaaoue yoo i?eaeeaaeth i/aiue aeeo?aoii.
I?eaeeaaee o?iaiy noieaoea
Iiaeii aeaoaeece?iaaoue i?eaeeaaee SELECT e UPDATE eiaiaie ii?aaeaeaiiuo
noieaoeia. Yoi iicaieeo aieaa oiiei ?aca?aie/eoue aeinooi iieueciaaoaeae
e oaaeeoea: iiaeii iicaieyoue iieueciaaoaeth aeaeaoue eee iaiiaeyoue
oieueei ii?aaeaeaiiua noieaoeu.
Iai?eia?:
CREATE TABLE emp_data
(
emp_num integer,
emp_name char(20),
hired date,
id-code char (10),
salary decimal(4,2)
)
Iineieueeo oaaeeoea niaea?aeeo eiioeaeaioeeaeueiua aeaiiua, oi n?aco
iinea aa nicaeaiey neaaeoao auiieieoue iia?aoi? REVOKE, eioi?ue
cai?auaao aeinooi e aeaiiui:
REVOKE ALL ON emp_data FROM PUBLIC
Aeey ioaeaeueiuo nio?oaeieeia ioaeaea eaae?ia e iaiaaeaea?ia auiieiyaony
iia?aoi? oeia:
GRANT SELECT ON emp_data TO andrew_p, michael_d
Oaeei ia?acii, iaeioi?ui iieueciaaoaeyi iicaieaii aeaeaoue ana noieaoeu.
A iaueo /a?oao neioaene/aneay caienue i?aaee aaciianiinoe aeinooia e
aeaiiui auaeyaeeo neaaeothuei ia?acii:
GRANT nienie_i?eaeeaaee_/a?ac_caiyooth [(nienie_ao?eaooia
/a?ac_caiyooth)]
ON au?aaeaiea TO nienie_iieueciaaoaeae_/a?ac_caiyooth
Aeey iaiaaeaea?ia, eioi?ua aeieaeiu aaiaeeoue iaeioi?ua naaaeaiey i
neoaeaueo, iaiaoiaeeii auiieieoue iia?aoi? oeia:
GRANT SELECT, UPDATE, INSERT, DELETE (salary, hired) ON emp_data TO
alex_v, nataly_d
Yoio iia?aoi? iicaieyao iieo/eoue aeinooi e aeaiiui i ca?ieaoa e aeaoa
i?eaia ia ?iaioo neoaeaueo. Aeey iaeioi?uo iieueciaaoaeae ec ioaeaea
eaae?ia, eioi?ua aeieaeiu ninoaaeyoue oaoie/aneea aeaiiua i
nio?oaeieeao, ioaeii auiieieoue iia?aoi? oeia:
GRANT SELECT, UPDATE, INSERT, DELETE (emp_num,emp_name,id-code) ON
emp_data TO nataly_d
I?eaeeaaee a nenoaiiii eaoaeiaa
I?eaeeaaee ?aaeno?e?othony a oaaeeoeao nenoaiiiai eaoaeiaa. Eaaeaeue
iieueciaaoaeue, iaeaaeathuee i?eaeeaaeae CONNECT, iiaeao cai?ineoue
eioi?iaoeeth ec oaaeeoe nenoaiiiai eaoaeiaa, /oiau ii?aaeaeeoue, eaeea e
eiio i?aaeinoaaeaiu i?eaeeaaee.
I?eaeeaaee aacu aeaiiuo ?aaeno?e?oaony a oaaeeoea sysusers, a eioi?ue
ia?ae/iui eeth/ii yaeyaony eaeaioeoeeaoi? iieueciaaoaey, a a ae?oaii
noieaoea iaoiaeeony neiaie C (CONNECT), R (RESOURCE) eee D (DBA),
iaicia/athuee o?iaaiue i?eaeeaaee. Iauaaeinooiiua i?eaeeaaee ioia?aaeaiu
iiae eiaiai iieueciaaoaey public (a ieaeiai ?aaeno?a).
I?eaeeaaee o?iaiy oaaeeoeu iaoiaeyony a oaaeeoea systabauth, a eioi?ie
eniieuecoaony ninoaaiie ia?ae/iue eeth/, aeeth/athuee iiia? oaaeeoeu,
eaeaioeoeeaoi? iieueciaaoaey, i?aaeinoaaeaoaai i?eaeeaaee ia oaaeeoeo e
eaeaioeoeeaoi? iieueciaaoaey, iieo/eaoaai eo. A noieaoea tabauth
i?eaeeaaee caeiaee?iaaiu a aeaea oanoeaoeaaiiiai nienea neaaeothuei
ia?acii (aeaoen iaicia/aao ia i?aaeinoaaeaiioth i?eaeeaaeth):
s – SELECT
u – UPDATE
– – * i?eaeeaaey ia noieaoeu
i – INSERT
d – DELETE
x – INDEX
a – ALTER
r – REFERENCES (ia?auaiea e caaeaiiie oaaeeoea a ia?aie/aieyo
oeaeinoiinoe)
Oaeei ia?acii, iieiue eiiieaeo i?eaeeaaee auaeyaeeo eae su-idxar.
Iai?eia?, iaai? -u—— aiai?eo, /oi iieueciaaoaeue iaeaaeaao oieueei
i?eaeeaaeae UPDATE.
Anee a o?aoueae iiceoeee i?enoonoaoao caacaei/ea, oi yoi icia/aao, /oi
aeey aeaiiie oaaeeoeu e iieueciaaoaey nouanoaotho aua eaeea-oi
i?eaeeaaee o?iaiy noieaoea. Eiie?aoiua i?eaeeaaee ?aaeno?e?othony a
oaaeeoea syscolauth. Aa ia?ae/iue eeth/ ninoaaeai ec iiia?a oaaeeoeu,
eaeaioeoeeaoi?a iieueciaaoaey, i?aaeinoaaeaoaai i?eaeeaaee, iieo/eaoaai
i?eaeeaaee, e iiia?a noieaoea. Aaeeinoaaiiue ao?eaoo – aeaooaoeaaiiue
nienie, iieacuaathuee oei i?eaeeaaee: s-, -u eee su.
I?eaeeaaee e i?aaenoaaeaiey
I?e nicaeaiee i?aaenoaaeaiey yae?i AAe i?iaa?yao i?eaeeaaee
iieueciaaoaey ia niioaaonoaothuea oaaeeoeu e i?aaenoaaeaiey. I?e
eniieueciaaiee aea i?aaenoaaeaiee i?iaa?ythony oieueei i?eaeeaaee ia
naii i?aaenoaaeaiea.
I?eaeeaaee i?e nicaeaiee i?aaenoaaeaiey
I?e nicaeaiee i?aaenoaaeaiey yae?i AAe i?iaa?yao iaee/ea o iieueciaaoaey
anao i?eaeeaaee, iaiaoiaeeiuo aeey auiieiaiey iia?aoi?a SELECT a
ii?aaeaeaiee i?aaenoaaeaiey. Anee oaeeo i?eaeeaaee iao, i?aaenoaaeaiea
ia nicaeaaony. Yoa i?iaa?ea ia iicaieyao iieueciaaoaeth iieo/eoue
ianaieoeeiie?iaaiiue aeinooi e oaaeeoea iooai nicaeaiey i?aaenoaaeaiey
aeey iaa e ia?auaiey e i?aaenoaaeaieth. Iinea nicaeaiey i?aaenoaaeaiey
yae?i AAe i?aaeinoaaeyao aai nicaeaoaeth e aeaaeaeueoeo, eae ieieioi,
i?eaeeaaeth SELECT aeey yoiai i?aaenoaaeaiey. Iii ia noaiiaeony
aaoiiaoe/anee iauaaeinooiiui, eae yoi i?ienoiaeeo n oaaeeoeae. ssae?i
AAe ii?aaeaeyao ii?aaeaeaiea i?aaenoaaeaiey e auyniyao, yaeyaony ee iii
iaiiaeyaiui. Anee aea, oi nicaeaoaeue i?aaenoaaeaiey iieo/aao i?eaeeaaee
INSERT, DELETE e UPDATE aeey yoiai i?aaenoaaeaiey i?e iaee/ee yoeo
i?eaeeaaee ia ii?iaeaeathuae oaaeeoea eee i?aaenoaaeaiee. Eiuie neiaaie,
anee nicaeaaaaiia i?aaenoaaeaiea yaeyaony iaiiaeyaiui, oi yae?i AAe
eiie?oao i?eaeeaaee INSERT, DELETE e UPDATE nicaeaoaey i?aaenoaaeaiey e
i?aaeinoaaeyao eo aio ia iiaii i?aaenoaaeaiee. Anee aeey ii?iaeaeathuae
oaaeeoeu nicaeaoaeue i?aaenoaaeaiey ?aniieaaaao oieueei i?eaeeaaeae
INSERT, oi ii iieo/eo ia i?aaenoaaeaiea oieueei yoo i?eaeeaaeth e o.ae.
Yoa i?iaa?ea ia iicaieyao iieueciaaoaeyi iieo/eoue eaeea-eeai i?eaeeaaee
e?iia oao, eioi?ua o iaai oaea anoue.
Iineieueeo aeey i?aaenoaaeaiey iaeuecy auiieiyoue iia?aoi?u ALTER TABLE
e CREATE INDEX, i?eaeeaaee ALTER e INDEX ieeiaaea ia ?ani?ino?aiythony
ia i?aaenoaaeaiey.
I?eaeeaaee i?e eniieueciaaiee i?aaenoaaeaiey
I?e iiiuoea eniieueciaaoue i?aaenoaaeaiea, yae?i AAe i?iaa?yao eeoue oa
i?eaeeaaee, eioi?ua ioiinyony eeoue e naiiio i?aaenoaaeaieth. Iii ia
i?iaa?yao i?aaa ia aeinooi e ii?aaeaeythuei aai oaaeeoeai. I?eaeeaaee
nicaeaoaey i?aaenoaaeaiey oaea ioia/aeenue ?aiaa. Aeey ae?oaeo
iieueciaaoaeae i?eaeeaaee ii?aaeaeythony nicaeaoaeai eee oai, o eiai
anoue i?eaeeaaey WITH GRANT OPTION. Yoi icia/aao, /oi iiaeii nicaeaoue
oaaeeoeo e ioiaieoue aa iauaaeinooiiinoue. Caoai iiaeii i?aaeinoaaeoue
ia?aie/aiiua i?eaeeaaee ia aeinooi e oaaeeoea /a?ac i?aaenoaaeaiey.
Ieaea i?eaiaeeony neioaenen iia?aoi?a GRANT:
GRANT nienie_i?eaeeaaee_/a?ac_caiyooth ON iauaeo
TO nienie_iieueciaaoaeae_/a?ac_caiyooth [WITH GRANT OPTION]
Aee?aeoeaa WITH GRANT OPTION iaaeaeyao oeacaiiuo iieueciaaoaeae iniauie
iieiiii/eyie – i?aaii i?aaeinoaaeaiey iieiiii/ee ae?oaei iieueciaaoaeyi.
Yoi icia/aao, /oi aeey ?aaiou n aeaiiui iauaeoii iie iiaoo iaaeaeyoue
iieiiii/eyie ae?oaeo iieueciaaoaeae.
?aaioo n i?aaenoaaeaieyie iiaeii i?iaeaiiino?e?iaaoue ia i?eia?ao n
oaaeeoeae emp_data:
CREATE TABLE emp_data
(
emp_num integer,
emp_name char(20),
hired date,
id-code char (10),
salary decimal(4,2)
)
Ionoue iinea nicaeaiey oaaeeoeu aue auiieiai neaaeothuee iia?aoi?:
REVOKE ALL ON emp_data FROM PUBLIC
Oaia?ue nicaeaaeei ianeieueei i?aaenoaaeaiee aeey ?aciuo eaoaai?ee
iieueciaaoaeae. Aeey oao, eoi iiaeao eiaoue aeinooi ii /oaieth ec
iaeiioeaeaioeeaeueiuo noieaoeia, nicaeaaeei oaeia i?aaenoaaeaiea:
CREATE VIEW emp_data AS
SELECT emp_num, emp_name FROM emp_data
Iieueciaaoaee, iieo/eaoea i?eaeeaaeth SELECT aeey aeaiiiai
i?aaenoaaeaiey, iiaoo aeaeaoue iaeioi?ua aeaiiua aac aiciiaeiinoe
iaiiaeaiey. Aeey ?aaioieeia ioaeaea eaae?ia nicaeaaeei neaaeothuaa
i?aaenoaaeaiea:
CREATE VIEW enter_data AS
SELECT emp_num,emp_name,id-code,salary FROM emp_data
Yoei iieueciaaoaeyi iaiaoiaeeii i?aaeinoaaeoue i?eaeeaaee INSERT e
UPDATE aeey yoiai i?aaenoaaeaiey. Oae eae nicaeaoaeue oaaeeoeu e
i?aaenoaaeaiey eiaao i?eaeeaaee ia anoaaeo eae aeey oaaeeoeu oae e aeey
i?aaenoaaeaiey, iiaeii i?aaeinoaaeoue i?eaeeaaee INSERT e UPDATE ia
i?aaenoaaeaiea aeaaea oai iieueciaaoaeyi, o eioi?uo iao oaeie
i?eaeeaaee:
GRANT SELECT, INSERT, UPDATE ON enter_data TO olga_s, helena_m
Aeey iaeioi?uo iieueciaaoaeae, eioi?ua iiaoo aaiaeeoue eee eciaiyoue
iaeioi?ua aeaiiua i nio?oaeieeao, nicaeaaeei aua iaeii i?aaenoaaeaiea:
CREATE VIEW enter_upd AS
SELECT emp_num,emp_name,id-code FROM emp_data
Yoi i?aaenoaaeaiea ioee/aaony io i?aaeuaeouaai oai, /oi a iineaaeiai ia
iieacuaathony aeaiiua i ca?ieaoa nio?oaeieeia. Iaeiiaoe, ionoue
iaiaaeaea?ai iaiaoiaeei aeinooi ii /oaieth e ?aaeaeoe?iaaieth anao
aeaiiuo i ?aaioieeao oe?iu:
CREATE VIEW all_data AS
SELECT * FROM emp_data
Oaia?ue iiaeii aeaoue iaiaaeaea?ai ana i?eaeeaaee:
GRANT SELECT, UPDATE, INSERT, DELETE ON emp_data TO alex_v
Aaeieieno?e?iaaiea na?aa?a INFORMIX-OnLine
Aiaae?aiea a eioi?iaoeeiiioth nenoaio na?aa?a INFORMIX-OnLine Dynamic
Server o?aaoao ?aoaiey iiiaeanoaa aii?inia, eioi?ua aeeytho ia
i?iecaiaeeoaeueiinoue nenoaiu a oeaeii. Iaiaoiaeeii ?aoeoue aii?inu,
aaea aoaeoo o?aieoueny aeaiiua, eae e iei aoaeao inouanoaeyoueny
aeinooi, eae caueoeoue aeaiiua. OnLine Server iicaieyao iano?ieoue
nenoaio ia iioeiaeueioth i?iecaiaeeoaeueiinoue. Aeey yoiai iaiaoiaeeii
iiieiaoue a?oeoaeoo?o na?aa?a e o?aaiaaiee, aicieeathueo ai a?aiy
yenieoaoaoeee na?aa?a.
I?aaiecaoeey o?aiaiey aeaiiuo
Na?aa? INFORMIX-OnLine iiaeao o?aieoue aeaiiua ia aeenea aeaoiy
niiniaaie. Ia?aue niinia – yoi o?aiaiea aeaiiuo a oaeeiaie nenoaia IN.
Aoi?ie niinia – o?aiaiea aeaiiuo ia “nu?ii” aeeneiaii i?ino?ainoaa. A
iineaaeiai neo/aa na?aa? INFORMIX-OnLine nai oi?aaeyao aaiaeii-auaiaeii
aeaiiuo.
Aaeeieoeu o?aiaiey aeaiiuo
Na?aa? INFORMIX-OnLine eniieuecoao neaaeothuea oece/aneea aaeeieoeu
o?aiaiey eioi?iaoeee: chunk, page, blobpage, extent.
Eiae/aneea aaeeieoeu o?aiaiey aeaiiuo naycaiu n oi?aaeaieai AAe. E
eiae/aneei aaeeieoeai ioiinyony: dbspace, blobspace, database, table,
tblspace.
A aeiiieiaiea e yoiio nouanoaotho neaaeothuea aaeeieoeu o?aiaiey
eioi?iaoeee i oece/aneie e eiae/aneie oeaeinoiinoe aeaiiuo: logical log,
physical log, reserved pages.
O?aaiaio aeenea chunk – yoi iaeneiaeueiay oece/aneay aaeeieoea o?aiaiey
eioi?iaoeee na?aa?ii INFORMIX-OnLine. O?aaiaio iiaeao auoue oaeeii
iia?aoeeiiiie nenoaiu eee niaoeeaeueiui neiaieueiui ono?ienoaii nenoaiu.
A ia?aii neo/aa aeaiiua ?aciauathony a iau/iii oaeea e caienueth ia
aeene oi?aaeyao IN. A yoii neo/aa INFORMIX-OnLine ia aa?aioe?oao, /oi
caienaiiua aeaiiua ?aaeueii iiiaaeoo ia aeene, oae eae aeaiiua iiaoo
auoue iiiauaiu a aeeneiaoth eyo-iaiyoue IN. Ai aoi?ii neo/aa na?aa?
aa?aioe?oao, /oi oa aeaiiua, eioi?ua aeieaeiu iiianoue ia aeene, aoaeoo
caienaiu. E?iia yoiai, caiaoii auoa i?iecaiaeeoaeueiinoue nenoaiu
aaiaea-auaiaea. Iaeiaei ia eaaeaeay iia?aoeeiiiay nenoaia iicaieyao
i?aaieciaaoue chunk ia “nu?ii” aeenea. INFORMIX-OnLine iiaeaea?aeeaaao
?acia? chunk aei 2 GB. Iaeneiaeueiia eiee/anoai chunk’ia – 2048.
No?aieoea page – yoi aaeeieoea eioi?iaoeee, eioi?ie na?aa?
INFORMIX-OnLine iaiaieaaaony n ono?ienoaii o?aiaiey aeaiiuo aeey
aeinooia e AAe. ?acia? no?aieoeu aa?uee?oaony. Iau/ii yoi 2 eee 4 EA.
O?aaiaio aeenea niaea?aeeo ii?aaeaeaiiia eiee/anoai no?aieoe. No?aieoea
ia iiaeao auoiaeeoue ca i?aaeaeu chunk’a.
Blobpage – aaeeieoea aeeneiaiai i?ino?ainoaa, eioi?ie INFORMIX-OnLine
iaieioee?oao aeey o?aiaiey aeaiiuo oeia BYTE e TEXT. ?acia? blobpage
caaeaaony aaeieieno?aoi?ii e iiaeao aa?uee?iaaoueny.
Eiaaea nicaeaaony oaaeeoea, INFORMIX-OnLine auaeaeyao oeene?iaaiiia
/enei no?aieoe aeey o?aiaiey aeaiiuo. Eiaaea auaeaeaiiia i?ino?ainoai
en/a?iuaaaony, na?aa? auaeaeyao aeiiieieoaeueiia ianoi. Oece/aneay
aaeeieoea aeaiiuo, eioi?ay eniieuecoaony aeey yoeo oeaeae, iacuaaaony
extent. I?e nicaeaiee oaaeeoeu caaeathony initial extent size e next
extent size. Ia?aue – ia?aiia/aeueiue iauai iiae oaaeeoeo (a
eeeiaaeoao). Aoi?ie – aaee/eia i?e?inoa iauaia oaaeeoeu a eeeiaaeoao.
Extent anaaaea o?aieony a i?aaeaeao iaeiiai chunk’a e ia iiaeao
ia?ae?uaaoue aai a?aieoeu. A neo/aa, eiaaea INFORMIX-OnLine ia iiaeao
auaeaeeoue aeinoaoi/ii i?ino?ainoaa a oaeouai o?aaiaioa, ii euao aai a
ae?oaii o?aaiaioa.
Aaciaie eiae/aneie aaeeieoeae o?aiaiey eioi?iaoeee na?aa?ii
INFORMIX-OnLine yaeyaony i?ino?ainoai AAe (dbspace). I?ino?ainoai AAe
ioia?aaeaao oece/aneia i?ino?ainoai ia eiae/aneia i?ino?ainoai o?aiaiey
aeaiiuo. Iau/ii iaeiiio dbspace niioaaonoaoao iaeei chunk, oioy iaeiiio
dbspace iiaeao niioaaonoaiaaoue ianeieueei o?aaiaioia.
Ca?eaee?iaaiea
Ca?eaee?iaaiea iicaieyao ?aca?ae?iaaoue o?aaiaio aeenea oi/ii oaeiai aea
?acia?a o?aaiaioii. Caienue a ia?ae/iue chunk ii?iaeaeaao caienue a
?aca?aiue chunk. A neo/aa naiy ia?ae/iiai o?aaiaioa na?aa?
INFORMIX-OnLine ia?aeeth/aaony ia ?aca?aiue aaoiiaoe/anee, i?e yoii
?aaioa iieueciaaoaey ia i?a?uaaaony.
Oaoiieiaey ?aca?ae?iaaiey iicaieyao aaeieieno?aoi?o ainnoaiaaeeaaoue
aeaiiua a ia?ae/iii o?aaiaioa ia?aeeaeueii n ?aaioie iieueciaaoaey n
aoi?e/iui o?aaiaioii.
Ca aiciiaeiinoue ca?eaee?iaaiey i?eaeaony ieaoeoue aeiiieieoaeueiui
aeeneiaui i?ino?ainoaii.
A neo/aa, eiaaea iaca?eaee?iaaiiue chunk auoiaeeo ec no?iy,
INFORMIX-OnLine ia iiaeao aeia?aoueny e aeaiiui ec iaai e aoaeao
aica?auaoue ioeaeo i?e ia?auaiee e yoiio o?aaiaioo. Anee ec no?iy auoae
iaca?eaee?iaaiiue o?aaiaio, eioi?ue o?aieo logical log, physical log eee
root dbspace, na?aa? iaiaaeeaiii ia?aoiaeeo a ?aaeei off-line, o.a.
i?ae?auaao ?aaioo.
Na?aa? aeaeaao caienue a iaa o?aaiaioa ia?aeeaeueii e /eoaao ec iaieo
?aciua /anoe (split read) aeey ieieiecaoeee a?aiaie aaiaea-auaiaea.
Eiaaea nicaeaaony ca?eaee?iaaiiue chunk, INFORMIX-OnLine eiie?oao
aeaiiua ec ia?ae/iiai ai aoi?e/iue. Oaeie i?ioeann iacuaaaony
ainnoaiiaeaieai (recovery). Ca?eaee?iaaiea ia/eiaao ?aaioaoue n?aco
iinea caaa?oaiey i?ioeanna ainnoaiiaeaiey.
Oece/aneee e eiae/aneee i?ioieieu ?aaiou
Oece/aneee i?ioieie (physical log)
Aaaeaiea oece/aneiai i?ioieiea anoue i?ioeann nio?aiaiey no?aieoe,
eioi?ue INFORMIX-OnLine niae?aaony iaiyoue, ii aei oiai, eae aoaeoo
aianaiu ?aaeueiua eciaiaiey a no?aieoeu. Ae?oaeie neiaaie, na?aa? ia?aae
iiaeeoeeaoeeae no?aieoe a iaiyoe na?anuaaao eo eiiee a aooa? oece/aneiai
i?ioieiea a iaiyoe.
Oece/aneee i?ioieie – yoi iiiaeanoai iineaaeiaaoaeueiuo no?aieoe, aaea
INFORMIX-OnLine nio?aiyao iaeciaiaiiua no?aieoeu (before-image). Yoi
ioaeii aeey auno?iai ainnoaiiaeaiey iinea “iaaeaiey” na?aa?a.
Na?aa? iaieioee?oao before-image a aooa?a oece/aneiai i?ioieiea aei oao
ii?, iiea iaeei ec i/enoeoaeae no?aieoe ia caieoao aa ia aeene.
Ia iiiaaeatho a i?ioieie blob-no?aieoeu ec blopspace, o.e. a i?ioeaiii
neo/aa iiaeao i?iecieoe ia?aiieiaiea oece/aneiai i?ioieiea.
Ai a?aiy eieoeeaeecaoeee na?aa? ?aciauaao oaeeu eiae/aneiai e
oece/aneiai i?ioieieia a ei?iaaii i?ino?ainoaa AAe root dbspace. Ec-ca
e?eoe/iinoe oece/aneiai i?ioieiea aeey ?aaiou INFORMIX-OnLine
?aeiiaiaeoaony ca?eaee?iaaoue dbspace, a eioi?ii o?aieony yoio i?ioieie.
Na?aa? auiieiyao oece/aneee i?ioieie ca oanoue oaaia:
*eoaao no?aieoeu aeaiiuo a aooa?.
Eiie?oao iaeciaiaiiua no?aieoeu a aooa? oece/aneiai i?ioieiea.
Ioia?aaeaao eciaiaiey a aooa?a no?aieoeu iinea oiai, eae i?eeiaeaiea
eciaiyao aeaiiua.
Nio?aiyao aooa? oece/aneiai i?ioieiea nianoaaiii a oece/aneii i?ioieiea
ia aeenea.
Nio?aiyao aooa? no?aieoeu ia aeenea.
I?e n?aaaouaaiee eiio?ieueiie oi/ee (checkpoint) na?anuaaao aooa?
oece/aneiai i?ioieiea ia aeene e caoai i/euaao oece/aneee i?ioieie.
Eiae/aneee i?ioieie (logical log)
Na?aa? INFORMIX-OnLine o?aieo enoi?eth eciaiaiee a AAe e na?aa?a n
iiiaioa aaia?aoeee iineaaeiaai a?oeaa e nio?aiaiey caienae i?ioieiea.
Na?aa? nio?aiyao caiene i?ioieiea a eiae/aneii i?ioieiea, ec eioi?iai
nicaeathony oaeeu eiae/aneiai i?ioieiea. Yoio i?ioieie iacuaaaony
eiae/aneei ii oie i?e/eia, /oi a iai nio?aiythony aaeeieoeu ?aaiou,
naycaiiua n eiae/aneeie iia?aoeeyie ?aaiou na?aa?a AAe a
i?ioeaiiieiaeiinoue oece/aneei iia?aoeeyi na?aa?a.
Ana AAe, oi?aaeyaiua iaeiei na?aa?ii INFORMIX-OnLine, nio?aiytho naie
i?ioieie a iaeiii e oii aea eiae/aneii i?ioieiea na?aa?a.
Oaeeu eiae/aneiai i?ioieiea ia yaeythony oaeeaie iia?aoeeiiiie nenoaiu.
Yoi /anoue aeeneiaiai i?ino?ainoaa, oi?aaeyaiiai INFORMIX-OnLine.
Eaaeaeue oaee eiae/aneiai i?ioieiea – yoi ioaeaeueiia i?ino?ainoai ia
aeenea.
I?e aeaiiie aeoeaiinoe nenoaiu, /ai iaiueoa aoaeao ioaeaii iiae oaee
eiae/aneiai i?ioieiea, oai auno?aa yoi ianoi aoaeao caiieiaii, e aieueoa
aa?iyoiinoue oiai, /oi aeoeaiinoue iieueciaaoaey aoaeao caaeiee?iaaia ai
a?aiy a?oeae?iaaiey eiae/aneiai i?ioieiea e n?aaaouaaiey eiio?ieueiie
oi/ee.
A?oeae?iaaiea oaeea eiae/aneiai i?ioieiea
Eiaaea oaee eiae/aneiai i?ioieiea caiieiai, iaiaoiaeeii aai
caa?oeae?iaaoue. I?ioeann a?oeae?iaaiey iiaeao “caii?iceoue” i?ioeann
ia?aaioee o?aicaeoeee, eioi?ua ?aaioatho n aeaiiuie ec oiai aea aeenea,
/oi e oaee eiae/aneiai i?ioieiea. Iiyoiio ?aeiiaiaeoaony auae?aoue a?aiy
iaeie aeoeaiinoe iieueciaaoaeae aeey a?oeae?iaaiey oaeea i?ioieiea.
Eiio?ieueiua oi/ee
Eae ieieioi iaeia eiio?ieueiay oi/ea aeieaeia auoue caienaia a
eiae/aneee i?ioieie. Anee iaiaoiaeeii inaiaiaeeoue oaee, niaea?aeauee
iineaaeithth eiio?ieueioth oi/eo, oi ioaeii caienaoue iiaoth
eiio?ieueioth oi/eo a oaeouee oaee eiae/aneiai i?ioieiea.
Niioaaonoaaiii, /ai /aua a?oeae?oaony oaee eiae/aneiai i?ioieiea e /ai
/aua ii inaiaiaeaeaaony, oai /aua neo/athony eiio?ieueiua oi/ee. O.e.
eiio?ieueiay oi/ea aeiee?oao ?aaioo iieueciaaoaeae, oi yoi
io?eoeaoaeueii neacuaaaony ia i?iecaiaeeoaeueiinoe.
Iauee ?acia? eiae/aneiai i?ioieiea anoue i?iecaaaeaiea eiee/anoaa oaeeia
i?ioieiea ia eo ?acia?:
Ieieiaeueiue ?acia? oaeea eiae/aneiai i?ioieiea – 200 KB.
Iaeneiaeueiue ?acia? ia ia?aie/ai, ii neaaeoao eiaoue aaeaeo, /oi anee
a?oeaaoeey i?ienoiaeeo ia iaaeeaiiue no?eia?, oi eo/oa aeaeaoue ?acia?
oaeea iaaieueoei.
*ai iaiueoa ?acia? oaeea, oai iaiueoa eioi?iaoeee iiaeao auoue iioa?yii,
o.e. anoue aa?iyoiinoue iioa?youe iineaaeiee ia nio?aiaiiue oaee
eiae/aneiai i?ioieiea i?e auoiaea aeenea ec no?iy.
Anaaaea iaiaoiaeeii eiaoue ieieioi 3 oaeea eiae/aneiai i?ioieiea.
Iaiaoiaeeii anaaaea eiaoue aeinoaoi/iia eiee/anoai oaeeia eiae/aneiai
i?ioieiea aeey oiai, /oiau anaaaea eiaoue aiciiaeiinoue ia?aeeth/eoueny
ia iiaue oaee e ia aeiionoeoue ia?aiieiaiey yoeo oaeeia.
I?e eieoeeaeecaoeee aeeneiaiai i?ino?ainoaa INFORMIX-OnLine ?aciauaao
oaeeu eiae/aneiai i?ieiea a ei?iaaii i?ino?ainoaa AAe (root dbspace).
Oaeeu eiae/aneiai i?ioieiea niaea?aeao e?eoe/anee aaaeioth eioi?iaoeeth
e aeieaeiu auoue caca?eaee?iaaiu aeey iaania/aiey iaeneiaeueiie
iaaeaaeiinoe aeaiiuo.
Eaaeaeue oaee eiaao naie oieeaeueiue eaeaioeoeeaoi?.
Iineaaeiaaoaeueiinoue iiia?ia ia/eiaaony n 1 aeey ia?aiai oaeea
eiae/aneiai i?ioieiea, caiieiaiiiai iinea eieoeeaeecaoeee aeeneiaiai
i?ino?ainoaa. I?e caiieiaiee oaeouaai oaeea na?aa? ia?aeeth/aaony ia
neaaeothuee e i?enaaeaaao aio iiia? ia 1 aieueoa, /ai i?aaeuaeouee.
Aeooaeueiia aeeneiaia i?ino?ainoai, auaeaeaiiia aeey eaaeaeiai oaeea
eiae/aneiai i?ioieiea, eiaao eaeaioeoeeaoeeiiiue iiia? logid. Iai?eia?,
anee au neiioeao?e?iaaee 6 eiae/aneiai i?ioieiea, oi yoe oaeeu eiatho
iiia?a io 1 aei 6. Iinea oiai, eae yoe oaeeu caa?oeae?iaaiu e
inaiaiaeaeaiu, INFORMIX-OnLine iiaoi?ii eniieuecoao aeeneiaia
i?ino?ainoai aeey oaeeia eiae/aneiai i?ioieiea, iaeiaei na?aa? aoaeao
ioia?iaaoue oieeaeueiui eaeaioeoeeaoi?ii, eioi?ie ?aaai i?aaeuaeouaio
iethn aaeeieoea.
Oaeeu eiae/aneiai i?ioieiea eiatho iaeei ec neaaeothueo noaoonia:
Added (A) Oaee i?ioieiea eiaao noaoon aeiaaaeaiiue, eiaaea yoio oaee
oieueei /oi aeiaaaeai. Ii ia aoaeao aeinooiai aeey eniieueciaaiey aei
oao ii?, iiea ia aoaeao nicaeai a?oea ioeaaiai o?iaiy ei?iaaiai
i?ino?ainoaa AAe.
Free (F) Oaee eiae/aneiai i?ioieiea naiaiaeai, eiaaea ii aeinooiai aeey
eniieueciaaiey. Yoio oaee aue inaiaiaeaeai iinea a?oeae?iaaiey, ana
o?aicaeoeee aioo?e oaeea i?ioieiea auee caaa?oaiu e iineaaeiyy caienue
eiio?ieueiie oi/ee iaoiaeeony a neaaeothuai ii ii?yaeeo i?ioieiea.
Used (U) Oaee eiae/aneiai i?ioieiea caaeaenoaiaai, eiaaea ii ioaeai
na?aa?o aeey ainnoaiiaeaiey (ioeao o?aicaeoeee eee iiene iineaaeiae
caiene eiio?ieueiie oi/ee).
Backed-up (B) Oaee i?ioieiea eiaao noaoon caa?oeae?iaai iinea oiai, eae
yoio oaee aue a naiii aeaea caa?oeae?iaai.
Current (C) Oaee i?ioieiea eiaao noaoon oaeouee, eiaaea na?aa? caiieiyao
aai i?ioieieii.
Last (L) Oaee eiaao noaoon iineaaeiee, eiaaea ii niaea?aeeo naioth
iineaaeithth caienue eiio?ieueiie oi/ee. Yoio oaee ia iiaeao auoue
inaiaiaeaeai aei oao ii?, iiea na?aa? ia caieoao iiaoth eiio?ieueioth
oi/eo a ae?oaie oaee eiae/aneiai i?ioieiea.
Anee INFORMIX-OnLine iuoaaony ia?aeeth/eoueny ia neaaeothuee ii ii?yaeeo
oaee eiae/aneiai i?ioieiea, eioi?ue aua ia inaiaiaeaeai, oi any ?aaioa
i?einoaiaaeeaaaony. Yoi i?ienoiaeeo aeaaea a oii neo/aa, eiaaea iaeei ec
oaeeia i?ioieiea naiaiaeai. Na?aa? ia iiaeao eniieueciaaoue
i?iecaieueiue ii iiia?o oaee. ?aaioa inoaiaaeeaaaony aeey caueou aeaiiuo
a oaeea i?ioieiea. Oaee eiae/aneiai i?ioieiea iiaeao auoue caiyo ii
neaaeothuei i?e/eiai:
Oaee eiae/aneiai i?ioieiea ia caa?oeae?iaai.
Oaee niaea?aeeo ioe?uooth o?aicaeoeeth.
Aeeeiiay o?aicaeoeey – yoi oaeay o?aicaeoeey, eioi?ay ia/eiaaony a
iaeiii oaeea eiae/aneiai i?ioieiea e ia oeene?oaony, eiaaea
INFORMIX-OnLine ioaeaeaaony a iiaoi?iii eniieueciaaiee oiai aea oaeea
i?ioieiea. O.a. aeeeiiay o?aicaeoeey ia?ae?uaaao aieueoa i?ino?ainoaa,
/ai auaeaeaii anaai iiae eiae/aneee i?ioieie.
O.e. na?aa? ia iiaeao inaiaiaeeoue oaee eiae/aneiai i?ioieiea aei oao
ii?, iiea ana caiene ia aoaeoo annioeee?iaaiu n cae?uouie o?aicaeoeeyie,
aeeeiiay o?aicaeoeey iaoaao inaiaiaeeoue ia?aue oaee i?ioieiea e aeaeaao
aai iaaeinooiiui aeey eniieueciaaiey.
Aeey i?aaeioa?auaiey oaeie neooaoeee ioaeii o/anoue neaaeothuaa:
I?iaa?eoue, ia caiieiyaony ee oaee eiae/aneiai i?ioieiea neeoeii auno?i.
I?iaa?eoue, ia inoaaony ee o?aicaeoeey neeoeii aeieai ioe?uoie.
Onoaiiaeoue a?aieoeo, ii aeinoeaeaiee eioi?ie INFORMIX-OnLine
aaoiiaoe/anee naa?iao ia?aaioeo aeeeiiie o?aicaeoeee.
A?oeae?iaaiea aeaiiuo
Nenoaia ainnoaiiaeaiey INFORMIX-OnLine iicaieyao a?oeae?iaaoue aeaiiua e
ainnoaiaaeeaaoue eo a neo/aa ii?/e.
Ono?ienoai nenoaiu ainnoaiiaeaiey aeaiiuo
A?oea – yoi eiiey anao eee /anoe aeaiiuo, eioi?uie oi?aaeyao na?aa?,
o.a. yoi eiiey iaeiiai eee aieaa dbspace e ethauo aniiiiaaoaeueiuo
aeaiiuo, eioi?ua iiaoo iiiaaeiaeoueny aeey ainnoaiiaeaiey.
A?oea eiae/aneiai i?ioieiea – yoi eiiey oaeeia eiae/aneiai i?ioieiea ia
aeenea eee eaioa, eioi?ua caiieiaiu e aioiau e a?oeae?iaaieth.
Ainnoaiiaeaiea – yoi i?ioeann ainnoaiiaeaiey aeaiiuo INFORMIX-OnLine, a
/anoiinoe, i?ino?ainoa AAe ec a?oeaa e a?oeae?iaaiiuo oaeeia eiae/aneiai
i?ioieiea.
Oece/aneia e eiae/aneia ainnoaiiaeaiea
Ainnoaiiaeaiea aeaiiuo iaiaoiaeeii i?iecaiaeeoue a aeaa yoaia. Ia?aue
yoai – oece/aneia ainnoaiiaeaiea, aoi?ie – eiae/aneia ainnoaiiaeaiea.
Oece/aneia ainnoaiiaeaiea – i?ioeann ainnoaiiaeaiey no?aieoe i?ino?ainoa
AAe ec a?oeaa. Eiae/aneia ainnoaiiaeaiea eniieuecoao a?oeae?iaaiiue
eiae/aneee i?ioieie aeey «iaeaoa» o?aicaeoeee a ainnoaiiaeaiiuo
i?ino?ainoaao AAe.
Nenoaia ainnoaiiaeaiey INFORMIX-OnLine
INFORMIX-OnLine i?aaeinoaaeyao aeaa nenoaiu ainnoaiiaeaiey aeaiiuo:
ON-Archive e ontype. Iie iicaieytho naeaeaoue neaaeothuaa:
A?oeae?iaaoue aeaiiua INFORMIX-OnLine;
A?oeae?iaaoue oaeeu eiae/aneiai i?ioieiea;
Aeaeaoue aeiaaai/iia a?oeae?iaaiea oaeeia eiae/aneiai i?ioieiea;
Ainnoaiaaeeaaoue aeaiiua ec a?oeaa;
A aeiiieiaiea e yoiio On-Archive iicaieyao neaaeothuaa:
Ieaie?iaaiea e ioneaaeeaaiea a?oeaia;
Iiiaeanoai n?aaenoa caueou e aeinooia e On-Archive;
Aiciiaeiinoue ia?aeeaeueii ?aaioaoue n ianeieueeeie eaioi/iuie
ono?ienoaaie;
?aaioaoue aac iaiin?aaenoaaiiiai o/anoey /aeiaaea.
Nio?aiaiea no?aieoe e eiae/aneiai i?ioieiea a a?oeaa
Ana, /ai oi?aaeyao INFORMIX-OnLine iiaeao auoue caa?oeae?iaaii ca
eneeth/aieai neaaeothuaai:
No?aieoeu dbspace, auaeaeaiiua aeey na?aa?a, ii ia i?eaycaiiua e
eaeiio-eeai o?aaiaioo tblspace;
Eiioeao?aoeeiiiua oaeeu ia a?oeae?othony;
No?aieoeu ec ca?eaeueiuo o?aaiaioia ia a?oeae?othony, anee aeinooiai
ia?ae/iue o?aaiaio;
Blob’u a blobspace, o?aieiua ia iioe/aneii iineoaea;
O?iaie a?oeaa
Iao niunea eaaeaeue ?ac a?oeae?iaaoue ana aeaiiua INFORMIX-OnLine.
Iiaeaea?aeeaathony o?e oeia aeiaaai/iiai a?oeae?iaaiey:
Level-0 – a?oeae?othony ana no?aieoeu;
Level-1 – a?oeae?othony ana eciaiaiey n iiiaioa iineaaeiaai a?oeaa
ioeaaiai o?iaiy;
Level-2 – a?oeae?othony ana eciaiaiey n iiiaioa iineaaeiaai a?oeaa
ia?aiai o?iaiy.
A?oeae?iaaiea eiae/aneiai i?ioieiea
Anee auei eieoeee?iaaii i?ioieiee?iaaiea AAe, oi INFORMIX-OnLine
caienuaaao o?aicaeoeee, i?iecioaaeoea iaaeaeo i?ioeaaeo?aie
a?oeae?iaaiey, a eiae/aneee i?ioieie, eioi?ue ninoieo ec ii?aaeaeaiiiai
/enea oaeeia eiae/aneiai i?ioieiea ia aeenea. Na?aa? ioaeaeaaony eae a
caiene iiauo aeaiiuo a i?ioieie, oae e a /oaiee i?ioieiea aeey
ainnoaiiaeaiey o?aicaeoeee. Aeey oiai, /oiau oaeeu eiae/aneiai i?ioieiea
ia caeii/eeenue, iaiaoiaeeii a?oeae?iaaoue caiieiaiiua oaeeu eiae/aneiai
i?ioieiea.
Anee aea i?ioieiee?iaaiea ia eniieuecoaony, oai ia iaiaa, ana ?aaii
iaiaoiaeeii a?oeae?iaaoue oaeeu eiae/aneiai i?ioieiea. A yoii neo/aa
i?ioieie niaea?aeeo eioi?iaoeeth i nicaeaiee e oaeaeaiee o?aaiaioia
aeenea e i caiene eiio?ieueiie oi/ee. Yoa eioi?iaoeey ioaeia aeey
“oaieiai” ainnoaiiaeaiey AAe aeaaea a oii neo/aa, eiaaea AAe ia
i?ioieiee?othony.
Aaoiiaoe/aneia e iai?a?uaiia a?oeae?iaaiea
Anee iaiaoiaeeii a?oeae?iaaoue oaeeu eiae/aneiai i?ioieiea n?aco iinea
eo caiieiaiey, oi ioaeii caionoeoue aaoiiaoe/aneia a?oeae?iaaiea. A yoii
?aaeeia a?oeae?othony ana oaeeu eiae/aneiai i?ioieiea, aioiaua e
a?oeae?iaaieth e i?ioeann inoaiaaeeaaaony ia oaeouai oaeea.
Oaeaea iiaeii caionoeoue iai?a?uaiia a?oeae?iaaiea. Oiaaea na?aa?
aaoiiaoe/anee a?oeae?oao oaee eiae/aneiai i?ioieiea n?aco ii aai
caiieiaieth.
I?e aaoiiaoe/aneii a?oeae?iaaiee iao iaiaoiaeeiinoe iiiieoue ia
a?oeae?iaaiee oaeea, ii ioaeii iiiieoue, /oi ia ono?ienoaa a?oeae?iaaiey
anaaaea aeieaeii auoue naiaiaeiia ianoi.
?aaeeiu ainnoaiiaeaiey aeaiiuo
A i?ioeanna ainnoaiiaeaiey INFORMIX-OnLine ainnicaeaao aeaiiua, eioi?ua
noaee iaaeinooiiuie a ?acoeueoaoa aiia?aoiiai eee i?ia?aiiiiai naiy. A
ethaii ec o?ao i?eaaaeaiiuo ieaea neo/ayo iaiaoiaeeii ainnoaiiaeaiea
aeaiiuo:
Ioeaea a i?ia?aiia caii?oeea aeaiiua a AAe;
Iaiaoiaeeii ia?aianoe aeaiiua ia ae?oaie eiiiuethoa?.
I?ioeann ainnoaiiaeaiey aeaeeony ia oacu oece/aneiai e eiae/aneiai
ainnoaiiaeaiey:
I?e oece/aneii ainnoaiiaeaiee ec a?oeaa ainnoaiaaeeaathony no?aieoeu
dbspace e blobspace;
I?e eiae/aneii ainnoaiiaeaiee i?iecaiaeeony ainnoaiiaeaiea o?aicaeoeee.
Auai? oeia oece/aneiai ainnoaiiaeaiey
Anee iaiaoiaeeii ainnoaiiaeoue aeaiiua iinea naiy, a ?acoeueoaoa
eioi?iai na?aa? ia?aoae a ?aaeei off-line, oi iaiaoiaeeii ainnoaiiaeoue
ana aeaiiua, oi?aaeyaiua na?aa?ii. Oaeie oei ainnoaiiaeaiey iacuaaaony
iieiui ainnoaiiaeaieai nenoaiu. Anee naie ia i?eaae e inoaiiao nenoaiu,
oi iiaeii auai?i/ii ainnoaiaaeeaaoue auai?i/iua dbspace eee blobspace.
I?e ia?aoiaea INFORMIX-OnLine a ?aaeei off-line ec-ca naiy aeenea
e?eoe/aneea aeaiiua dbspace aoaeoo iia?aaeaeaiu. E e?eoe/aneei dbspace
ioiinyony:
root dbspace;
niaea?aeauee oece/aneee i?ioieie dbspace;
niaea?aeauee oaeeu eiae/aneiai i?ioieiea dbspace.
Ainnoaiiaeaiea e?eoe/aneeo dbspace iaiaoiaeeii i?iecaiaeeoue a
“oieiaeiii” ?aaeeia.
Auai?i/iia ainnoaiiaeaiea dbspace eee blobspace
Anee iinea naiy INFORMIX-OnLine ia ia?aoae a ninoiyiea off-line, oi
iia?aaeaeaiey dbspace ia yaeythony e?eoe/aneeie. Anee naie neo/eeny a
o?aaiaioa aeenea dbspace, eioi?ue ?aciauaaony ia ianeieueeeo o?aaiaioao,
oi ana aeoeaiua o?aicaeoeee a yoii dbspace aeieaeiu auoue i?a?aaiu
ia?aae ainnoaiiaeaieai. Iiaeii caionoeoue iia?aoeeth ainnoaiiaeaiey aei
caaa?oaiey o?aicaeoeee. Oiaaea i?ioeann ainnoaiiaeaiey aoaeao aeaeaoue,
iiea na?aa? ia caaa?oeo i?iaa?eo oiai, /oi ana o?aicaeoeee, aeoeaiua a
iiiaio naiy, auee caaa?oaiu.
“Oieiaeiue” ?aaeei ainnoaiiaeaiey
Eae iieacaii ia ?en. 1, ainnoaiiaeaiea anao dbspace e blobspace (iieiia
ainnoaiiaeaiea nenoaiu) iiaeii naeaeaoue n iiiiuueth iaeiiai oece/aneiai
e iaeiiai eiae/aneiai ainnoaiiaeaiey.
INFORMIX-OnLine iaoiaeeony a ?aaeeia off-line a ia/aea i?ioeanna
ainnoaiiaeaiey, ii caoai, iinea ainnoaiiaeaiey ?aca?aiuo no?aieoe,
na?aa? ia?aoiaeeo a ?aaeei ainnoaiiaeaiey. N yoiai iiiaioa na?aa?
iaoiaeeony a aeaiiii ?aaeeia aei oao ii?, iiea ia aoaeao caaa?oaii
eiae/aneia ainnoaiiaeaiea.
“Oaieue” ?aaeei ainnoaiiaeaiey
A aeaiiii ?aaeeia iiaeii ainnoaiaaeeaaoue iae?eoe/iua dbspace e
blobspace i?e ?aaioa INFORMIX-OnLine a ?aaeeia on-line eee quiescent.
“Oaieue” ?aaeei ninoieo ec iaeiiai eee ianeieueeeo oece/aneeo
ainnoaiiaeaiee, eiae/aneiai a?oeae?iaaiey e ainnoaiiaeaiey.
I?e “oaieii” ainnoaiiaeaiee caa?oeae?iaaiiua oaeeu eiae/aneiai i?ioieiea
“i?iea?uaathony” aeey ainnoaiiaeaiey o?aicaeoeee a ainnoaiiaeaiiuo
dbspace (?en. 2).
Niaoaiiue ?aaeei ainnoaiiaeaiey
Niaoaiiue ?aaeei ainnoaiiaeaiey ninoieo ec oieiaeiiai ainnoaiiaeaiey, ca
eioi?ui neaaeoao oaieia ainnoaiiaeaiea. Iaeioi?ua dbspace e blobspace
ainnoaiaaeeaathony a oieiaeiii ?aaeeia (INFORMIX-OnLine iaoiaeeony a
?aaeeia off-line). Oaeie ?aaeei ainnoaiiaeaiey iau/ii i?eiaiyaony,
eiaaea o?aaoaony iieiia ainnoaiiaeaiea nenoaiu, ii a oiaea aai o?aaoaony
/anoe/iue aeinooi e iaeioi?ui oaaeeoeai. A yoii neo/aa auiieiyaony
oieiaeiia ainnoaiiaeaiea e?eoe/aneeo dbspace e dbspace, eioi?ua
niaea?aeao aaaeioth eioi?iaoeeth.
Yenii?o-eiii?o aeaiiuo
Iea?aoeey aeaiiuo, o.a. ia?aiin aacu aeaiiuo eee aa /anoae iiaeao
iiiaaeiaeoueny ii neaaeothuei i?e/eiai:
Aeey ia?aiina ?ac?aaioaiiie nenoaiu caeac/eeo;
Aeey ia?aiina ia ae?oaoth aiia?aoioth ieaooi?io;
Aeey ?ani?ino?aiaiey iieueciaaoaeyi;
Aeey ia?aiina aeaiiuo iaaeaeo INFORMIX-SE e INFORMIX-OnLine.
Iaoiaeu iea?aoeee aeaiiuo, eniieuecoaiua a INFORMIX-OnLine
Na?aa? INFORMIX-OnLine neaaeothuea iaoiaeu aeey ia?aiina aeaiiuo ec
iaeiie AAe a ae?oaoth:
Ooeeeoaie onunload e onload;
Ooeeeoaie dbexport e dbimport;
Au?aaeaieyie LOAD e UNLOAD;
Ooeeeoie dbload.
Ooeeeou onunload e onload acaeiinaycaiu, o.a. aeey oiai, /oiau
caa?oceoue aeaiiua n iiiiuueth onload, eo iaiaoiaeeii i?aaeaa?eoaeueii
aua?oceoue n iiiiuueth onunload. Aiaeiae/ii, aeey ?aaiou dbimport ioaeiu
oaeeu, iiaeaioiaeaiiua dbexport. Ooeeeoa dbload e au?aaeaiea LOAD iiaoo
caa?oaeaoue aeaiiua ec ethaiai oaeea, anee ii ioaa/aao ii?aaeaeaiiui
o?aaiaaieyi ii oi?iaoo.
Ooeeeoa dbschema ii noaia AAe nicaeaao oaee n au?aaeaieyie ia SQL,
eioi?ue iiaeii eniieueciaaoue caoai aeey nicaeaiey oaaeeoe n aiaeiae/iie
no?oeoo?ie.
Eniieueciaaiea ooeeeo onunload e onload
Yoe aeaa ooeeeou aua?oaeatho e caa?oaeatho aeaiiua ec AAe eee aa /anoe
no?aieoeaie. Iiyoiio ia eniieueciaaiea yoeo ooeeeo iaeeaaeuaathony
iaeioi?ua ia?aie/aiey.
I?e ia?aiina aeaiiuo iaaeaeo eiiiuethoa?aie iaiaoiaeeii:
Oaaaeeoueny, /oi ?acia? no?aieoeu e i?aaenoaaeaiea /enae aeieaeii auoue
iaeeiaeiaui ia iaieo nenoaiao.
Caionoeoue ooeeeoo oncheck aeey i?iaa?ee oeaeinoiinoe aacu aeaiiuo.
Caionoeoue ooeeeoo onunload.
Anee ioaeii, ia?aianoe iineoaeue n aua?oaeaiiuie aeaiiuie ia ae?oaoth
nenoaio.
Caionoeoue ooeeeoo onload.
Onoaiiaeoue aeaeaaiue noaoon i?ioieiee?iaaiey iiaie AAe.
Nicaeaoue a?oea ioeaaiai o?iaiy iiaie AAe.
I?e ia?aiina oaaeeoe iaaeaeo eiiiuethoa?aie n iiiiuueth onunload e
onload iaiaoiaeeii auiieieoue neaaeothuea oaae:
Oaeinoiaa?eoueny, /oi ?acia? no?aieoe e i?aaenoaaeaiea /enae iaeeiaeiai
ia iaieo nenoaiao.
Caionoeoue ooeeeoo oncheck aeey i?iaa?ee oeaeinoiinoe aacu aeaiiuo.
Caionoeoue ooeeeoo onunload.
Anee ioaeii, ia?aianoe iineoaeue n aua?oaeaiiuie aeaiiuie ia ae?oaoth
nenoaio.
Aueeth/eoue i?ioieiee?iaaiea
Caionoeoue ooeeeoo onload.
Nicaeaoue a?oea ioeaaiai o?iaiy iiaeeoeoee?iaaiiie AAe.
Aeeth/eoue i?ioieiee?iaaiea, anee ioaeii.
Nicaeaoue iaiaoiaeeiua neiiieiu e i?aaa aeinooia e aeaiiie oaaeeoea.
Auai? iaaeaeo onunload, dbimport e LOAD
I?e iaaiciiaeiinoe eniieueciaaiey ooeeeo onunload e onload, iaiaoiaeeii
naeaeaoue auai? iaaeaeo dbload, dbimport e LOAD. Eaaeaeue ec yoeo
niiniaia iicaieyao iiaeeoeoee?iaaoue noaio AAe.
Ooeeeoa dbimport caa?oaeaao AAe oeaeeeii e ath iaiaoiaeeii
ainiieueciaaoueny a oii neo/aa, eiaaea iao aiciiaeiinoe eniieueciaaoue
onload. Aeey caa?ocee oaaeeoe eniieuecoeoa au?aaeaiea LOAD eee ooeeeoo
dbload.
I?e eniieueciaaiee ooeeeou dbload (eee au?aaeaiey LOAD) ioaeii
caa?oaeaoue aeaiiua a oaea nouanoaothuoth oaaeeoeo. Anee oaaeeoeu ia
nouanoaoao, oi aa ioaeii nicaeaoue, iai?eia?, n iiiiuueth SQL-au?aaeaiey
CREATE iiaeii nicaeaoue oaaeeoeo, i?aaenoaaeaiea eee neiiiei.
Iiaeeoeeaoeey noaiu AAe
Ooeeeoa dbschema nicaeaao oaee n SQL-iia?aoi?aie, iaiaoiaeeiuie aeey
aini?iecaaaeaiey oeacaiiie AAe, oaaeeoeu e ae?oaeo iauaeoia AAe
(iai?eia?, o?eaaa?a). Iinea nicaeaiey oaeea ni noaiie AAe, yoio oaee
iiaeii a?o/ioth io?aaeaeoe?iaaoue n oeaeueth eciaiaiey iaeioi?uo
oa?aeoa?enoee AAe eee oaaeeoeu (eee aua /aai-ieaoaeue). Iiaeii eciaieoue
neaaeothuea oa?aeoa?enoeee:
I?aaa aeinooia;
Aeaaeaeueoea iauaeoa (oaaeeoea, eiaeaen, i?aaenoaaeaiea);
?aaeei aeiee?iaee;
?acia?u ia/aeueiiai e iineaaeothueo extent’ia.
Dbspace, aaea o?aiyony oaaeeoeu.
Eniieueciaaiea au?aaeaiee UNLOAD e LOAD
Au?aaeaiea UNLOAD iicaieyao caienuaaoue no?iee, ecaea/aiiua au?aaeaieai
SELECT a ASCII-oaee. Au?aaeaiea UNLOAD nicaeaao oaee a niioaaonoaea n
onoaiiaeaie a ie?oaeaiee iieueciaaoaeueneiai i?eeiaeaiey.
Iia?aoi? LOAD caa?oaeaao aeaiiua ec i?aaeaa?eoaeueii nicaeaiiiai oaeea a
iauaeo AAe (oaaeeoeo, neiiiei eee i?aaenoaaeaiea). Iau/ii ia aoiaea
eniieuecoaony oaee, nicaeaiiue iia?aoi?ii UNLOAD, o.e. iia?aoi? LOAD
o?aaoao no?iai oi?iaoe?iaaiiue oaee.
Eniieueciaaiea ooeeeou dbload
Aeaiiay ooeeeoa, eniieuecoy eiiaiaeu a eiiaiaeiii oaeea dbload, iiaeao
oi?iaoe?iaaoue aoiaeiua aeaiiua ia?aae oai, eae anoaaeyoue eo a
oeacaiioth oaaeeoeo. A aeiiieiaiea e yoiio iioeee eiiaiaeiie no?iee
dbload aeatho neaaeothuea aiciiaeiinoe:
I?iaa?eoue neioaenen au?aaeaiee eiiaiaeiiai oaeea;
Ioeeaaeuaaoue aeiee?iaee oaaeeoeu ai a?aiy anoaaee aeaiiuo;
Eaii?e?iaaoue ii?aaeaeaiiia /enei no?ie n ia/aea aoiaeiiai oaeea;
I?iioneaoue iaei??aeoiua no?iee;
I?a?uaaoue caa?oceo iinea ii?aaeaeaiiiai eiee/anoaa iaeaeaiiuo
iaei??aeoiuo no?ie.
Ooeeeoa dbload iiaeao a?aoue ia aoiaea ianeieueei oaeeia e anoaaeyoue eo
niaea?aeeiia a caaeaiiua oaaeeoeu, nicaeaiiua ec oaeea noaiu AAe.
Eniieueciaaiea ooeeeo dbexport e dbimport
Ooeeeou dbexport e dbimport iaieioee?otho oieueei aacaie aeaiiuo
oeaeeeii. Aeey eniieueciaaiey yoeo ooeeeo ioaeii auoue iiaeeeth/aiiui e
na?aa?o AAe eae iieueciaaoaeue informix eee eiaoue i?aaa nenoaiiiai
aaeieieno?aoi?a.
Ooeeeoa dbexport aua?oaeaao aeaiiua a ASCII-oaeeu. A aeiiieiaiea e yoiio
dbexport nicaeaao ASCII-oaee, a eioi?ii niaea?aeeony noaia aacu aeaiiuo,
iaiaoiaeeiay aeey iiaoi?iiai nicaeaiey AAe, eaeaioe/iie aeaiiie, ia
ae?oaii na?aa?a.
Ooeeeoa dbimport /eoaao aoiaeiua oaeeu. Iia eniieuecoao oaee noaiu AAe
aeey nicaeaiey eiiee aacu. Iiaeii oeacaoue oa?aeoa?enoeee
i?ioieiee?iaaiey iiaie AAe n iiiiuueth iioeee eiiaiaeiie no?iee. Iinea
nicaeaiey AAe i?ienoiaeeo aa iaiieiaiea niaea?aeeiui oaeeia, nicaeaiiuo
ooeeeoie dbexport.
?aaeeiu ?aaiou na?aa?a INFORMIX-OnLine
Na?aa? eiaao ianeieueei ?aaeeiia ?aaiou:
off-line
quiescent
on-line
read-only
recovery
shutdown
A ?aaeeia off-line na?aa? ia caiouai.
A ?aaeeia quiescent auiieiythony aaeieieno?aoeaiua i?ioeaaeo?u. Aeey
yoiai i?ae?auaaony any ?aaioa n aacie aeaiiuo. Oieueei iieueciaaoaee
informix e root iiaoo auiieiyoue aaeieieno?aoeaiua i?ioeaaeo?u n
iiiiuueth ON-Monitor eee ooeeeo eiiaiaeiie no?iee. A yoii ?aaeeia
iaeuecy iiaeeeth/eoueny e na?aa?o, iaeiaei iiaeii ociaoue aai oaeouaa
ninoiyiea.
A ?aaeeia on-line iieueciaaoaee iiaoo iiaeniaaeeiyoueny e naiei aacai
aeaiiuo e auiieiyoue cai?inu. A yoi a?aiy aaeieieno?aoi? iiaeao iaiyoue
ii?aaeaeaiiua iano?ieee a oaeea ONCONFIG.
?aaeei read-only i?eeiaeaiey iiaoo oieueei cai?aoeaaoue aeaiiua n
na?aa?a, ii ia iiaoo eo iaiiaeyoue.
?aaeei recovery yaeyaony ia?aoiaeiui. A yoii ?aaeeia na?aa? iaoiaeeony
i?e ia?aoiaea ec ?aaeeia off-line a ?aaeei quiescent. Auno?ia
ainnoaiiaeaiea auiieiyaony a yoii ?aaeeia.
?aaeei shutdown oaeaea yaeyaony ia?aoiaeiui. Ii iiaeao aicieeiooue i?e
ia?aoiaea ec ?aaeeia on-line (eee quiescent) a ?aaeei off-line.
N?aaenoaa aeeaaiinoeee na?aa?a INFORMIX-OnLine
Nenoaiiay AAe sysmaster
INFORMIX-OnLine Dynamic Server nicaeaao e iiaeaea?aeeaaao AAe sysmaster.
Yoa aaca aeaiiuo niaea?aeeo eioi?iaoeeth i naiii na?aa?a. Sysmaster
ninoieo ec neaaeothueo oaaeeoe:
Oaaeeoeu SMI
Oaaeeoeu eioa?oaena nenoaiiiai iiieoi?eiaa (SMI) niaea?aeao eioi?iaoeeth
i ninoiyiee na?aa?a INFORMIX-OnLine. Iiaeii ia?auaoueny e yoei oaaeeoeai
aeey ii?aaeaeaiey “oceeo iano” a ia?aaioea eioi?iaoeee, ii?aaeaeaiey
eniieueciaaiey ?ano?nia, ioneaaeeaaiey aeoeaiinoe nannee eee na?aa?a
AAe, e o.i.
Oaaeeoeu eaoaeiaa ON-Archive
Yoe oaaeeoeu niaea?aeao eioi?iaoeeth i cai?inao, iaai?ao oiiia, iaai?ia
nio?aiaiey.
INFORMIX-OnLine nicaeaao AAe sysmaster aaoiiaoe/anee i?e eieoeeaeecaoeee
aeeneiaiai i?ino?ainoaa. Iaeuecy oaeaeeoue yoo AAe eee oaaeeoeu a iae, a
oaeaea iaeuecy eciaieoue ninoiyiea i?ioieiee?iaaiey AAe.
Iiaeii, eae iieueciaaoaeue informix, nicaeaaaoue o?aieiua i?ioeaaeo?u e
o?eaaa?u a yoie AAe. Ii INFORMIX-OnLine ia aoaeao eniieiyoue nicaeaiiua
iieueciaaoaeai a sysmaster o?eaaa?u.
Iienaiea oaaeeoe SMI
Eioa?oaen nenoaiiiai iiieoi?eiaa ninoieo ec iaeioi?iai /enea oaaeeoe e
inaaaeioaaeeoe, eioi?ua aaoiiaoe/anee iiaeaea?aeeaathony INFORMIX-OnLine
e ia na?anuaathony ia aeene ai a?aiy ?aaiou.
Oaaeeoeu SMI niaea?aeao neaaeothuoth eioi?iaoeeth:
Aoaeeoeia
Ia?auaiea e aeeneai
Eioi?iaoeey i iieueciaaoaeyo
Noaoon i?ioieiee?iaaiey aac aeaiiuo
Oaaeeoeu
Chunk’e
Aaiae-auaiae chunk’ia
I?ino?ainoaa AAe
Aeiee?iaee
Extent’u
Nenoaiiay eioi?iaoeey
Ethaie iieueciaaoaeue iiaeao cai?aoeaaoue eioi?iaoeeth ec ethaie
oaaeeoeu sysmaster ca eneeth/aieai oaaeeoe sysadinfo e sysaudit.
Iineaaeiea aeaa oaaeeoeu iiaeao i?iniao?eaaoue oieueei iieueciaaoaeue
informix.
O?eaaa?u ii eciaiaieth a SMI-oaaeeoeao ieeiaaea ia auiieiythony, o.e.
INFORMIX-OnLine i?iecaiaeeo eciaiaiey a SMI-oaaeeoeao ia n iiiiuueth
SQL-au?aaeaiee.
Ieaea i?eaaaeai nienie eniieuecoaiuo SMI-oaaeeoe:
sysaudinfo Eiioeao?aoeeiiiay eioi?iaoeey aoaeeoeiaa
sysaudit Ianee niauoee aoaeeoeiaa
syschkio Noaoenoeea aaiaea-auaiaea aeey chunk’ia
syschunks Eioi?iaoeey i chunk’ao
sysdatabases Eioi?iaoeey i aacao aeaiiuo
sysdbspaces Eioi?iaoeey i i?ino?ainoaao AAe
sysdri Eioi?iaoeey ii ?aieeeaoeee aeaiiuo
sysextents Eioi?iaoeey i ?aciauaiee extent’ia
syslocks Eioi?iaoeey ia aeoeaiuo aeiee?iaeao
syslogs Eioi?iaoeey i oaeeao eiae/aneiai i?ioieiea
sysprofile Nenoaiiay eioi?iaoeey
sysptprof Eioi?iaoeey ii oaaeeoeai
syssesprof Iiaen/ao aeaenoaee iieueciaaoaeae
syssessions Iienaiea eaaeaeiai iieueciaaoaeueneiai niaaeeiaiey
sysseswts A?aiy iaeeaeaiey iieueciaaoaeai eaaeaeiai ec ianeieueeeo
iauaeoia
systabnames Iienaiea eaaeaeie oaaeeoeu, oi?aaeyaiie INFORMIX-OnLine
Ecaea/aiea aeeaaiinoe/aneie eioi?iaoeee i ?aaioa na?aa?a
Aeey ecaea/aiey eioi?iaoeee ec oaaeeoe SMI eniieuecoaony ooeeeoa onstat.
Ieaea i?eaaaeaiu iaeioi?ua aiciiaeiua iioeee yoie ooeeeou:
Iioeee onstat Cai?in e oaaeeoeai SMI
-d sysdbspaces
syschunks
-D sysdbspaces
syschkio
-F sysprofile
-g dri sysdri
-g glo sysvpprof
-k syslocks
-l syslogs
sysprofile
-p sysprofile
-u syssessions
syssesprof
Eniieueciaaiiay eeoa?aoo?a:
“INFORMIX. O/aaiia iiniaea”, Eeaa, Ec-ai ANTEC, 1996
PAGE
PAGE 20
EAIOU A?OEAA EIAE*ANEIAI I?IOIEIEA
A?OEAIUA EAIOU
O?AICAEOeEE
Root DBS
Dbspace1
dbspace2
?en. 1
EAIOU A?OEAA EIAE*ANEIAI I?IOIEIEA
O?AICAEOeEE
Root DBS
Dbspace1
dbspace2
?en. 2
A?OEAIUA EAIOU
Нашли опечатку? Выделите и нажмите CTRL+Enter
