Informix 11.7 dbspace.sql

c:\net start test1

c:\ibm\informix\test1.cmd

__________________________

EXECUTE FUNCTION ADMIN ('create dbspace', 'plogdbs', 'C:\09_datafile\informix\test1\plogdbs', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'llogdbs', 'C:\09_datafile\informix\test1\llogdbs', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create tempdbspace', 'tmpdbs01', 'C:\09_datafile\informix\test1\tmpdbs01', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create tempdbspace', 'tmpdbs02', 'C:\09_datafile\informix\test1\tmpdbs02', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create tempdbspace', 'tmpdbs03', 'C:\09_datafile\informix\test1\tmpdbs03', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create tempdbspace', 'tmpdbs04', 'C:\09_datafile\informix\test1\tmpdbs04', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs01', 'C:\09_datafile\informix\test1\datadbs01', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs02', 'C:\09_datafile\informix\test1\datadbs02', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs03', 'C:\09_datafile\informix\test1\datadbs03', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs04', 'C:\09_datafile\informix\test1\datadbs04', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs05', 'C:\09_datafile\informix\test1\datadbs05', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs06', 'C:\09_datafile\informix\test1\datadbs06', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs07', 'C:\09_datafile\informix\test1\datadbs07', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs08', 'C:\09_datafile\informix\test1\datadbs08', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs09', 'C:\09_datafile\informix\test1\datadbs09', '100000K', '0K');

EXECUTE FUNCTION ADMIN ('create dbspace', 'datadbs10', 'C:\09_datafile\informix\test1\datadbs10', '100000K', '0K');

--  Dbspace 21 -- Chunk 21

EXECUTE FUNCTION TASK('create sbspace', 'sbspace1', 'C:\09_datafile\informix\test1\sbspace1', '100000', '0');

--  Physical Log

EXECUTE FUNCTION TASK

('alter plog', 'plogdbs', '99000');

--  Store pre-existing logical logs information before create new logical logs

DATABASE sysadmin;

CREATE TABLE llog (log smallint, flags  smallint);

INSERT INTO llog SELECT number, flags FROM sysmaster:syslogfil;

--  Logical Log 7

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 8

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 9

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 10

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 11

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 12

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 13

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 14

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 15

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Logical Log 16

EXECUTE FUNCTION TASK

('add log', 'llogdbs', '10000');

--  Drop all pre-existing logical logs

EXECUTE FUNCTION TASK

('checkpoint');

SELECT TASK ('drop log', log) FROM sysadmin:llog

WHERE sysmaster:bitval(flags,'0x02')==0;

EXECUTE FUNCTION TASK

('checkpoint');

SELECT TASK('onmode', 'l') FROM sysmaster:syslogfil

WHERE chunk = 1 AND sysmaster:bitval(flags,'0x02')>0;

EXECUTE FUNCTION TASK

('checkpoint');

SELECT TASK ('drop log', log) FROM sysadmin:llog

WHERE sysmaster:bitval(flags,'0x02')==1;

DROP TABLE sysadmin:llog;

_______________________________________

? 在windows 7 64bit進階家庭版的alienware本機中，test1.cmd運行，視窗非常小，如何變大？很簡單，刪除最後一行

set INFORMIXDIR=C:\IBM\Informix
set INFORMIXSERVER=test1
set ONCONFIG=ONCONFIG.test1
set PATH=C:\IBM\Informix\bin;%PATH%
set CLASSPATH=%INFORMIXDIR%\extend\krakatoa\krakatoa.jar;%INFORMIXDIR%\extend\krakatoa\jdbc.jar;%CLASSPATH%
set DBTEMP=C:\IBM\Informix\infxtmp
set CLIENT_LOCALE=EN_US.CP1252
set DB_LOCALE=EN_US.8859-1

mode con codepage select=1252

即可