Informix 11.7 dbspace.sql

最新推荐文章于 2022-03-21 16:42:30 发布

jaminwm

最新推荐文章于 2022-03-21 16:42:30 发布

阅读量1.8k

点赞数

分类专栏： DB2 文章标签： informix function ibm c table path

本文链接：https://blog.youkuaiyun.com/jaminwm/article/details/7605847

版权

DB2 专栏收录该内容

54 篇文章

订阅专栏

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

即可