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', '123', '0 ');

-- Physical log

Execute function task

('Alter plog', 'plogdbs ', '123 ');

-- 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 ', '123 ');

-- Logical log 8

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 9

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 10

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 11

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 12

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 13

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 14

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical Log 15

Execute function task

('Add log', 'llogdbs ', '123 ');

-- Logical log 16

Execute function task

('Add log', 'llogdbs ', '123 ');

-- 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;

_______________________________________

? In the alienware Local Machine of Windows 7 64bit advanced Home Edition, test1.cmd runs, the window is very small, how to increase? It's easy to delete the last row.

Set informixdir = c: \ IBM \ Informix
Set informixserver = test1
Set onconfig = onconfig. test1
Set Path = c: \ IBM \ Informix \ bin; % PATH %
Set classpath = % informixdir % \ eXtend \ 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

You can.