Try building the DBE Manually before you run IMAGESQL.
Here is the start of a large job that should help you out.
!job pactatt,!hpuser.!hpaccount,Sql;outclass=lp,1,1;hipri
!setjcw sicognos 0
!sqlmig
exit;
!if !migwarn = 0
! setvar hasallbase 'YES'
! else
! setvar hasallbase 'NO'
!endif
!continue
!TELL !HPSTREAMEDBY; ALLBASE Present = !hasallbase
!if finfo('PACTDBE.SQL','exists')
!continue
!TELL !HPSTREAMEDBY; Beginning DETACH !HPTIMEF
!continue
!RUN IMAGESQL.PUB.SYS
set turbodb PACT.PUB
set sqldbe PACTDBE
detach
exit
!else
!continue
!TELL !HPSTREAMEDBY; Building DBE !HPTIMEF
!continue
!isql
start DBE 'PACTDBE' multi new
dbefile0 dbefile dbefile0
with pages = 1000, name='PACTDB0', log dbefile dbelog1
with pages = 50000, name='PACTLOG',
transaction=32, buffer =(512,512) ,
default timeout = 300 seconds;
create dbefile SYSTEM_SPACE_1 with pages=1000,name='PACTDB1',
increment=1000,maxpages=50000;
add dbefile SYSTEM_SPACE_1 to dbefileset SYSTEM;
commit work;
exit;
!continue
!TELL !HPSTREAMEDBY; Creating Default Tablespace
!if '!hasallbase' = 'YES'
!continue
!isql
create dbefileset DESKTOP_TABLES;
create dbefile DESKTOP_TABLES_1 with pages=100,name='DESKTBL1',
increment=128,maxpages=50000;
create dbefile DESKTOP_TABLES_2 with pages=100,name='DESKTBL2',
increment=128,maxpages=50000;
add dbefile DESKTOP_TABLES_1 to dbefileset DESKTOP_TABLES;
add dbefile DESKTOP_TABLES_2 to dbefileset DESKTOP_TABLES;
grant tablespace on dbefileset DESKTOP_TABLES to DESKTOP,TICKETS,FUND;
SET DEFAULT TABLESPACE TO DBEFILESET DESKTOP_TABLES FOR PUBLIC;
commit work;
exit;
!else
!isql
create dbefileset IMAGESQL;
create dbefile IMAGE_SQL_1 with pages=100,name='ISQLTBLS',
increment=100,maxpages=3000;
add dbefile IMAGE_SQL_1 to dbefileset IMAGESQL;
grant tablespace on dbefileset IMAGESQL to DESKTOP,TICKETS,FUND;
SET DEFAULT TABLESPACE TO DBEFILESET IMAGESQL FOR PUBLIC;
commit work;
exit;
!endif
!endif
!continue
!TELL !HPSTREAMEDBY; Beginning ATTACH !HPTIMEF
!continue
!RUN IMAGESQL.PUB.SYS
set turbodb PACT.PUB
set sqldbe PACTDBE
attach
Gary L. Biggs, N5TTO
[log in to unmask]
Interex SIG Allbase Chair
"Abandon all hope, Ye who Inter(net) here" --
Dante, over the portal(router) to Hell
|