Move sysadmin database
On IDS 12.10.FC4 (Linux), Frank ran task("reset sysadmin","dbdw00") to move the sysadmin database; the build failed with SQL error -349 at line 29 of $INFORMIXDIR/etc/sysadmin/db_install.sql, leaving sysadmin gone. Suggestions: drop any leftover sysadmin and restart the instance; John Miller (IBM) said the CREATE DATABASE itself is failing, so check the dbspace name and free space; Ricardo Henriques posted a manual rebuild using db_uninstall/db_create/db_install/sch_*/start.sql via dbaccess, no restart needed. Frank replied space was adequate; no confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Guys,
IDS12.10 FC4 Lniux 6
Run the SQL,
EXECUTE FUNCTION task("reset sysadmin","dbdw00");
Got this error
14:46:41 Maximum server connections 173
14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
2, Plog used 4477, Llog used 23683
14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
/usr/informix/etc/sysadmin/db_install.sql at line 29
14:47:51 Error building 'sysadmin' database.
Any answer ?
Thanks
Frank
--001a11379f5223445f0519d177a7
Drop the database if it is there and restart the instance ?
Cheers
Paul
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> FRANK
> Sent: Wednesday, July 01, 2015 9:52 AM
> To: ids@iiug.org
> Subject: Move sysadmin database [35361]
>
> Guys,
>
> IDS12.10 FC4 Lniux 6
>
> Run the SQL,
>
> EXECUTE FUNCTION task("reset sysadmin","dbdw00");>
> Got this error
>
> 14:46:41 Maximum server connections 173
> 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 2, Plog used 4477, Llog used 23683
> 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> /usr/informix/etc/sysadmin/db_install.sql at line 29
> 14:47:51 Error building 'sysadmin' database.
>
> Any answer ?
>
> Thanks
> Frank
>
> --001a11379f5223445f0519d177a7
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
The sysadmin database is gone ....
So,...
On Wed, Jul 1, 2015 at 11:00 AM, Paul Watson <paul@oninit.com> wrote:
> Drop the database if it is there and restart the instance ?
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > FRANK
> > Sent: Wednesday, July 01, 2015 9:52 AM
> > To: ids@iiug.org
> > Subject: Move sysadmin database [35361]
> >
> > Guys,
> >
> > IDS12.10 FC4 Lniux 6
> >
> > Run the SQL,
> >
> > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> >
> > Got this error
> >
> > 14:46:41 Maximum server connections 173
> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> > 2, Plog used 4477, Llog used 23683
> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > /usr/informix/etc/sysadmin/db_install.sql at line 29
> > 14:47:51 Error building 'sysadmin' database.
> >
> > Any answer ?
> >
> > Thanks
> > Frank
> >
> > --001a11379f5223445f0519d177a7
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> http://www.avast.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1147947686c45c0519d1c736
More info from log.
Frank
14:41:41 Maximum server connections 173
14:41:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2098, Llog used 16042
14:42:42 SCHAPI: thread dbWorker1 task mon_checkpoint(7-14406) shutting
down
14:42:42 SCHAPI: thread dbWorker2 task mon_memory_system(8-7221) shutting
dow n
14:42:42 SCHAPI: thread dbScheduler(119) shutting down
14:42:51 SCHAPI: 'sysadmin' database will be moved to 'dbdw00'. See online
me ssage log.
14:42:51 Building 'sysadmin' database ...
14:46:32 Logical Log 281716 Complete, timestamp: 0x7168f433.
14:46:41 Checkpoint Completed: duration was 0 seconds.
14:46:41 Wed Jul 1 - loguniq 281717, logpos 0x217018, timestamp:
0x71690d9d Interval: 456981
14:46:41 Maximum server connections 173
14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
2, Plog used 4477, Llog used 23683
14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
/usr/informix/etc/sysad min/db_install.sql at line 29
14:47:51 Error building 'sysadmin' database.
14:50:46 CDR Spool transaction queue completed
14:51:41 Checkpoint Completed: duration was 0 seconds.
14:51:41 Wed Jul 1 - loguniq 281717, logpos 0x79bb44c, timestamp:
0x716e34fc Interval: 456982
14:51:41 Maximum server connections 173
14:51:41 Checkpoint Statistics - Avg. Txn Block Time 0.116, # Txns blocked
3, Plog used 4800, Llog used 30655
14:56:41 Checkpoint Completed: duration was 0 seconds.
14:56:41 Wed Jul 1 - loguniq 281717, logpos 0xe990018, timestamp:
0x71714244 Interval: 456983
14:56:41 Maximum server connections 173
On Wed, Jul 1, 2015 at 11:14 AM, FRANK <yunyaoqu@gmail.com> wrote:
> The sysadmin database is gone ....
>
> So,...
>
> On Wed, Jul 1, 2015 at 11:00 AM, Paul Watson <paul@oninit.com> wrote:
>
>> Drop the database if it is there and restart the instance ?
>>
>> Cheers
>> Paul
>>
>> > -----Original Message-----
>> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> > FRANK
>> > Sent: Wednesday, July 01, 2015 9:52 AM
>> > To: ids@iiug.org
>> > Subject: Move sysadmin database [35361]
>> >
>> > Guys,
>> >
>> > IDS12.10 FC4 Lniux 6
>> >
>> > Run the SQL,
>> >
>> > EXECUTE FUNCTION task("reset sysadmin","dbdw00");>> >
>> > Got this error
>> >
>> > 14:46:41 Maximum server connections 173
>> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
>> blocked
>> > 2, Plog used 4477, Llog used 23683
>> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
>> > /usr/informix/etc/sysadmin/db_install.sql at line 29
>> > 14:47:51 Error building 'sysadmin' database.
>> >
>> > Any answer ?
>> >
>> > Thanks
>> > Frank
>> >
>> > --001a11379f5223445f0519d177a7
>> >
>> >
>> > **********************************************************
>> > *********************
>> > Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> http://www.avast.com
>>
>>
>>
>>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
--001a113a98429af5380519d1cbce
In short the following scripts from $INFORMIXDIR/etc are run
to create the sysadmin database. I am guessing it is having a problem
with
the dbspace name provided as the create database is failing. The first
sql statement in the db=5Finstall script is failing with a database does not
exist
error. Please check the dbspace name and the free space in the dbspace.
sysadmin/db=5Finstall
sysadmin/sch=5Ftasks
sysadmin/sch=5Faus
sysadmin/sch=5Fsqlcap
sysadmin/sch=5Fiwa
sysadmin/sch=5Foat
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 07/01/2015 08:15:48 AM:
> From: "FRANK" <yunyaoqu@gmail.com>
> To: ids@iiug.org
> Date: 07/01/2015 08:16 AM
> Subject: Re: Move sysadmin database [35364]
> Sent by: ids-bounces@iiug.org
>
> More info from log.
> Frank
>
> 14:41:41 Maximum server connections 173
> 14:41:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
blocked
> 0, Plog used 2098, Llog used 16042
> 14:42:42 SCHAPI: thread dbWorker1 task mon=5Fcheckpoint(7-14406) shutting
> down
> 14:42:42 SCHAPI: thread dbWorker2 task mon=5Fmemory=5Fsystem(8-7221) shut=
ting
> dow n
> 14:42:42 SCHAPI: thread dbScheduler(119) shutting down
> 14:42:51 SCHAPI: 'sysadmin' database will be moved to 'dbdw00'. See
online
> me ssage log.
> 14:42:51 Building 'sysadmin' database ...
> 14:46:32 Logical Log 281716 Complete, timestamp: 0x7168f433.
> 14:46:41 Checkpoint Completed: duration was 0 seconds.
> 14:46:41 Wed Jul 1 - loguniq 281717, logpos 0x217018, timestamp:
> 0x71690d9d Interval: 456981
> 14:46:41 Maximum server connections 173
> 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
blocked
> 2, Plog used 4477, Llog used 23683
> 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> /usr/informix/etc/sysad min/db=5Finstall.sql at line 29
> 14:47:51 Error building 'sysadmin' database.
> 14:50:46 CDR Spool transaction queue completed
> 14:51:41 Checkpoint Completed: duration was 0 seconds.
> 14:51:41 Wed Jul 1 - loguniq 281717, logpos 0x79bb44c, timestamp:
> 0x716e34fc Interval: 456982
> 14:51:41 Maximum server connections 173
> 14:51:41 Checkpoint Statistics - Avg. Txn Block Time 0.116, # Txns
blocked
> 3, Plog used 4800, Llog used 30655
> 14:56:41 Checkpoint Completed: duration was 0 seconds.
> 14:56:41 Wed Jul 1 - loguniq 281717, logpos 0xe990018, timestamp:
> 0x71714244 Interval: 456983
> 14:56:41 Maximum server connections 173
>
> On Wed, Jul 1, 2015 at 11:14 AM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > The sysadmin database is gone ....
> >
> > So,...
> >
> > On Wed, Jul 1, 2015 at 11:00 AM, Paul Watson <paul@oninit.com> wrote:
> >
> >> Drop the database if it is there and restart the instance ?
> >>
> >> Cheers
> >> Paul
> >>
> >> > -----Original Message-----
> >> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
Of
> >> > FRANK
> >> > Sent: Wednesday, July 01, 2015 9:52 AM
> >> > To: ids@iiug.org
> >> > Subject: Move sysadmin database [35361]
> >> >
> >> > Guys,
> >> >
> >> > IDS12.10 FC4 Lniux 6
> >> >
> >> > Run the SQL,
> >> >
> >> > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> >> >
> >> > Got this error
> >> >
> >> > 14:46:41 Maximum server connections 173
> >> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> >> blocked
> >> > 2, Plog used 4477, Llog used 23683
> >> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> >> > /usr/informix/etc/sysadmin/db=5Finstall.sql at line 29
> >> > 14:47:51 Error building 'sysadmin' database.
> >> >
> >> > Any answer ?
> >> >
> >> > Thanks
> >> > Frank
> >> >
> >> > --001a11379f5223445f0519d177a7
> >> >
> >> >
> >> > **********************************************************
> >> > *********************
> >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >> ---
> >> This email has been checked for viruses by Avast antivirus software.
> >> http://www.avast.com
> >>
> >>
> >>
> >>
>
***************************************************************************=
****
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >
>
> --001a113a98429af5380519d1cbce
>
>
>
***************************************************************************=
****
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
No need to restart the instance.
It is possible to rebuild-it on the root dbspace without bouncing the
server by following the next steps.
cd $INFORMIXDIR/etc/sysadmin;
dbaccess - db_uninstall.sql;
dbaccess - db_create.sql;
dbaccess sysadmin db_install.sql;
dbaccess sysadmin sch_tasks.sql;
dbaccess sysadmin sch_aus.sql;
dbaccess sysadmin sch_sqlcap.sql;
dbaccess sysadmin start.sql;
If sysadmin has already been dropped then the db_uninstall.sql script will
return error, that can be ignored.
On Wed, 1 Jul 2015 at 16:00 Paul Watson <paul@oninit.com> wrote:
> Drop the database if it is there and restart the instance ?
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > FRANK
> > Sent: Wednesday, July 01, 2015 9:52 AM
> > To: ids@iiug.org
> > Subject: Move sysadmin database [35361]
> >
> > Guys,
> >
> > IDS12.10 FC4 Lniux 6
> >
> > Run the SQL,
> >
> > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> >
> > Got this error
> >
> > 14:46:41 Maximum server connections 173
> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> > 2, Plog used 4477, Llog used 23683
> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > /usr/informix/etc/sysadmin/db_install.sql at line 29
> > 14:47:51 Error building 'sysadmin' database.
> >
> > Any answer ?
> >
> > Thanks
> > Frank
> >
> > --001a11379f5223445f0519d177a7
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> http://www.avast.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec53f3985fb7de30519d22bab
onmode -yuck && oninit -vw
Is easier to type :)
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Ricardo Henriques
> Sent: Wednesday, July 01, 2015 10:43 AM
> To: ids@iiug.org
> Subject: Re: Move sysadmin database [35366]
>
> No need to restart the instance.
>
> It is possible to rebuild-it on the root dbspace without bouncing the
> server by following the next steps.
>
> cd $INFORMIXDIR/etc/sysadmin;
> dbaccess - db_uninstall.sql;
> dbaccess - db_create.sql;
> dbaccess sysadmin db_install.sql;
> dbaccess sysadmin sch_tasks.sql;
> dbaccess sysadmin sch_aus.sql;
> dbaccess sysadmin sch_sqlcap.sql;
> dbaccess sysadmin start.sql;
>
> If sysadmin has already been dropped then the db_uninstall.sql script will
> return error, that can be ignored.
>
> On Wed, 1 Jul 2015 at 16:00 Paul Watson <paul@oninit.com> wrote:
>
> > Drop the database if it is there and restart the instance ?
> >
> > Cheers
> > Paul
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > FRANK
> > > Sent: Wednesday, July 01, 2015 9:52 AM
> > > To: ids@iiug.org
> > > Subject: Move sysadmin database [35361]
> > >
> > > Guys,
> > >
> > > IDS12.10 FC4 Lniux 6
> > >
> > > Run the SQL,
> > >
> > > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > >
> > > Got this error
> > >
> > > 14:46:41 Maximum server connections 173
> > > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > blocked
> > > 2, Plog used 4477, Llog used 23683
> > > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > > /usr/informix/etc/sysadmin/db_install.sql at line 29
> > > 14:47:51 Error building 'sysadmin' database.
> > >
> > > Any answer ?
> > >
> > > Thanks
> > > Frank
> > >
> > > --001a11379f5223445f0519d177a7
> > >
> > >
> > >
> **********************************************************
> > > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > http://www.avast.com
> >
> >
> >
> >
> **********************************************************
> *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --bcaec53f3985fb7de30519d22bab
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
Not on a production site ;)
On Wed, 1 Jul 2015 at 16:47 Paul Watson <paul@oninit.com> wrote:
> onmode -yuck && oninit -vw>
> Is easier to type :)
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Ricardo Henriques
> > Sent: Wednesday, July 01, 2015 10:43 AM
> > To: ids@iiug.org
> > Subject: Re: Move sysadmin database [35366]
> >
> > No need to restart the instance.
> >
> > It is possible to rebuild-it on the root dbspace without bouncing the
> > server by following the next steps.
> >
> > cd $INFORMIXDIR/etc/sysadmin;
> > dbaccess - db_uninstall.sql;
> > dbaccess - db_create.sql;
> > dbaccess sysadmin db_install.sql;
> > dbaccess sysadmin sch_tasks.sql;
> > dbaccess sysadmin sch_aus.sql;
> > dbaccess sysadmin sch_sqlcap.sql;
> > dbaccess sysadmin start.sql;
> >
> > If sysadmin has already been dropped then the db_uninstall.sql script
> will
> > return error, that can be ignored.
> >
> > On Wed, 1 Jul 2015 at 16:00 Paul Watson <paul@oninit.com> wrote:
> >
> > > Drop the database if it is there and restart the instance ?
> > >
> > > Cheers
> > > Paul
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > > FRANK
> > > > Sent: Wednesday, July 01, 2015 9:52 AM
> > > > To: ids@iiug.org
> > > > Subject: Move sysadmin database [35361]
> > > >
> > > > Guys,
> > > >
> > > > IDS12.10 FC4 Lniux 6
> > > >
> > > > Run the SQL,
> > > >
> > > > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > > >
> > > > Got this error
> > > >
> > > > 14:46:41 Maximum server connections 173
> > > > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > > blocked
> > > > 2, Plog used 4477, Llog used 23683
> > > > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > > > /usr/informix/etc/sysadmin/db_install.sql at line 29
> > > > 14:47:51 Error building 'sysadmin' database.
> > > >
> > > > Any answer ?
> > > >
> > > > Thanks
> > > > Frank
> > > >
> > > > --001a11379f5223445f0519d177a7
> > > >
> > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > > ---
> > > This email has been checked for viruses by Avast antivirus software.
> > > http://www.avast.com
> > >
> > >
> > >
> > >
> > **********************************************************
> > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --bcaec53f3985fb7de30519d22bab
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> http://www.avast.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f46d044304c4a40bd00519d24262
They'd never notice :)
And if it's a production server then oninit -i to make sure it is started in
interactive mode :)
Cheers
Paul
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Ricardo Henriques
> Sent: Wednesday, July 01, 2015 10:49 AM
> To: ids@iiug.org
> Subject: Re: Move sysadmin database [35368]
>
> Not on a production site ;)
>
> On Wed, 1 Jul 2015 at 16:47 Paul Watson <paul@oninit.com> wrote:
>
> > onmode -yuck && oninit -vw> >
> > Is easier to type :)
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > Ricardo Henriques
> > > Sent: Wednesday, July 01, 2015 10:43 AM
> > > To: ids@iiug.org
> > > Subject: Re: Move sysadmin database [35366]
> > >
> > > No need to restart the instance.
> > >
> > > It is possible to rebuild-it on the root dbspace without bouncing the
> > > server by following the next steps.
> > >
> > > cd $INFORMIXDIR/etc/sysadmin;
> > > dbaccess - db_uninstall.sql;
> > > dbaccess - db_create.sql;
> > > dbaccess sysadmin db_install.sql;
> > > dbaccess sysadmin sch_tasks.sql;
> > > dbaccess sysadmin sch_aus.sql;
> > > dbaccess sysadmin sch_sqlcap.sql;
> > > dbaccess sysadmin start.sql;
> > >
> > > If sysadmin has already been dropped then the db_uninstall.sql script
> > will
> > > return error, that can be ignored.
> > >
> > > On Wed, 1 Jul 2015 at 16:00 Paul Watson <paul@oninit.com> wrote:
> > >
> > > > Drop the database if it is there and restart the instance ?
> > > >
> > > > Cheers
> > > > Paul
> > > >
> > > > > -----Original Message-----
> > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > Of
> > > > > FRANK
> > > > > Sent: Wednesday, July 01, 2015 9:52 AM
> > > > > To: ids@iiug.org
> > > > > Subject: Move sysadmin database [35361]
> > > > >
> > > > > Guys,
> > > > >
> > > > > IDS12.10 FC4 Lniux 6
> > > > >
> > > > > Run the SQL,
> > > > >
> > > > > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > > > >
> > > > > Got this error
> > > > >
> > > > > 14:46:41 Maximum server connections 173
> > > > > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > > > blocked
> > > > > 2, Plog used 4477, Llog used 23683
> > > > > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > > > > /usr/informix/etc/sysadmin/db_install.sql at line 29
> > > > > 14:47:51 Error building 'sysadmin' database.
> > > > >
> > > > > Any answer ?
> > > > >
> > > > > Thanks
> > > > > Frank
> > > > >
> > > > > --001a11379f5223445f0519d177a7
> > > > >
> > > > >
> > > > >
> > >
> **********************************************************
> > > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > >
> > > > ---
> > > > This email has been checked for viruses by Avast antivirus software.
> > > > http://www.avast.com
> > > >
> > > >
> > > >
> > > >
> > >
> **********************************************************
> > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --bcaec53f3985fb7de30519d22bab
> > >
> > >
> > >
> **********************************************************
> > > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > http://www.avast.com
> >
> >
> >
> >
> **********************************************************
> *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f46d044304c4a40bd00519d24262
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
No No! Never "oninit -i"!
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Wed, Jul 1, 2015 at 11:50 AM, Paul Watson <paul@oninit.com> wrote:
> They'd never notice :)
>
> And if it's a production server then oninit -i to make sure it is started
> in
> interactive mode :)
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Ricardo Henriques
> > Sent: Wednesday, July 01, 2015 10:49 AM
> > To: ids@iiug.org
> > Subject: Re: Move sysadmin database [35368]
> >
> > Not on a production site ;)
> >
> > On Wed, 1 Jul 2015 at 16:47 Paul Watson <paul@oninit.com> wrote:
> >
> > > onmode -yuck && oninit -vw> > >
> > > Is easier to type :)
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > > Ricardo Henriques
> > > > Sent: Wednesday, July 01, 2015 10:43 AM
> > > > To: ids@iiug.org
> > > > Subject: Re: Move sysadmin database [35366]
> > > >
> > > > No need to restart the instance.
> > > >
> > > > It is possible to rebuild-it on the root dbspace without bouncing the
> > > > server by following the next steps.
> > > >
> > > > cd $INFORMIXDIR/etc/sysadmin;
> > > > dbaccess - db_uninstall.sql;
> > > > dbaccess - db_create.sql;
> > > > dbaccess sysadmin db_install.sql;
> > > > dbaccess sysadmin sch_tasks.sql;
> > > > dbaccess sysadmin sch_aus.sql;
> > > > dbaccess sysadmin sch_sqlcap.sql;
> > > > dbaccess sysadmin start.sql;
> > > >
> > > > If sysadmin has already been dropped then the db_uninstall.sql script
> > > will
> > > > return error, that can be ignored.
> > > >
> > > > On Wed, 1 Jul 2015 at 16:00 Paul Watson <paul@oninit.com> wrote:
> > > >
> > > > > Drop the database if it is there and restart the instance ?
> > > > >
> > > > > Cheers
> > > > > Paul
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf
> > > Of
> > > > > > FRANK
> > > > > > Sent: Wednesday, July 01, 2015 9:52 AM
> > > > > > To: ids@iiug.org
> > > > > > Subject: Move sysadmin database [35361]
> > > > > >
> > > > > > Guys,
> > > > > >
> > > > > > IDS12.10 FC4 Lniux 6
> > > > > >
> > > > > > Run the SQL,
> > > > > >
> > > > > > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > > > > >
> > > > > > Got this error
> > > > > >
> > > > > > 14:46:41 Maximum server connections 173
> > > > > > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
> Txns
> > > > > blocked
> > > > > > 2, Plog used 4477, Llog used 23683
> > > > > > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > > > > > /usr/informix/etc/sysadmin/db_install.sql at line 29
> > > > > > 14:47:51 Error building 'sysadmin' database.
> > > > > >
> > > > > > Any answer ?
> > > > > >
> > > > > > Thanks
> > > > > > Frank
> > > > > >
> > > > > > --001a11379f5223445f0519d177a7
> > > > > >
> > > > > >
> > > > > >
> > > >
> > **********************************************************
> > > > > > *********************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > >
> > > > > ---
> > > > > This email has been checked for viruses by Avast antivirus
> software.
> > > > > http://www.avast.com
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --bcaec53f3985fb7de30519d22bab
> > > >
> > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > > ---
> > > This email has been checked for viruses by Avast antivirus software.
> > > http://www.avast.com
> > >
> > >
> > >
> > >
> > **********************************************************
> > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --f46d044304c4a40bd00519d24262
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> http://www.avast.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113321eec7cf3c0519d294c5
John,
There is enough free db space there.
Thanks
Frank
On Wed, Jul 1, 2015 at 11:42 AM, John Miller iii <miller3@us.ibm.com> wrote:
> In short the following scripts from $INFORMIXDIR/etc are run
> to create the sysadmin database. I am guessing it is having a problem
> with
> the dbspace name provided as the create database is failing. The first
> sql statement in the db=5Finstall script is failing with a database does
> not
> exist
> error. Please check the dbspace name and the free space in the dbspace.
>
> sysadmin/db=5Finstall
> sysadmin/sch=5Ftasks
> sysadmin/sch=5Faus
> sysadmin/sch=5Fsqlcap
> sysadmin/sch=5Fiwa
> sysadmin/sch=5Foat
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 07/01/2015 08:15:48 AM:
>
> > From: "FRANK" <yunyaoqu@gmail.com>
> > To: ids@iiug.org
> > Date: 07/01/2015 08:16 AM
> > Subject: Re: Move sysadmin database [35364]
> > Sent by: ids-bounces@iiug.org
> >
> > More info from log.
> > Frank
> >
> > 14:41:41 Maximum server connections 173
> > 14:41:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> > 0, Plog used 2098, Llog used 16042
> > 14:42:42 SCHAPI: thread dbWorker1 task mon=5Fcheckpoint(7-14406) shutting
> > down
> > 14:42:42 SCHAPI: thread dbWorker2 task mon=5Fmemory=5Fsystem(8-7221)
> shut=
> ting
>
> > dow n
> > 14:42:42 SCHAPI: thread dbScheduler(119) shutting down
> > 14:42:51 SCHAPI: 'sysadmin' database will be moved to 'dbdw00'. See
> online
> > me ssage log.
> > 14:42:51 Building 'sysadmin' database ...
> > 14:46:32 Logical Log 281716 Complete, timestamp: 0x7168f433.
> > 14:46:41 Checkpoint Completed: duration was 0 seconds.
> > 14:46:41 Wed Jul 1 - loguniq 281717, logpos 0x217018, timestamp:
> > 0x71690d9d Interval: 456981
> > 14:46:41 Maximum server connections 173
> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked
> > 2, Plog used 4477, Llog used 23683
> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > /usr/informix/etc/sysad min/db=5Finstall.sql at line 29
> > 14:47:51 Error building 'sysadmin' database.
> > 14:50:46 CDR Spool transaction queue completed
> > 14:51:41 Checkpoint Completed: duration was 0 seconds.
> > 14:51:41 Wed Jul 1 - loguniq 281717, logpos 0x79bb44c, timestamp:
> > 0x716e34fc Interval: 456982
> > 14:51:41 Maximum server connections 173
> > 14:51:41 Checkpoint Statistics - Avg. Txn Block Time 0.116, # Txns
> blocked
> > 3, Plog used 4800, Llog used 30655
> > 14:56:41 Checkpoint Completed: duration was 0 seconds.
> > 14:56:41 Wed Jul 1 - loguniq 281717, logpos 0xe990018, timestamp:
> > 0x71714244 Interval: 456983
> > 14:56:41 Maximum server connections 173
> >
> > On Wed, Jul 1, 2015 at 11:14 AM, FRANK <yunyaoqu@gmail.com> wrote:
> >
> > > The sysadmin database is gone ....
> > >
> > > So,...
> > >
> > > On Wed, Jul 1, 2015 at 11:00 AM, Paul Watson <paul@oninit.com> wrote:
> > >
> > >> Drop the database if it is there and restart the instance ?
> > >>
> > >> Cheers
> > >> Paul
> > >>
> > >> > -----Original Message-----
> > >> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > >> > FRANK
> > >> > Sent: Wednesday, July 01, 2015 9:52 AM
> > >> > To: ids@iiug.org
> > >> > Subject: Move sysadmin database [35361]
> > >> >
> > >> > Guys,
> > >> >
> > >> > IDS12.10 FC4 Lniux 6
> > >> >
> > >> > Run the SQL,
> > >> >
> > >> > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > >> >
> > >> > Got this error
> > >> >
> > >> > 14:46:41 Maximum server connections 173
> > >> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > >> blocked
> > >> > 2, Plog used 4477, Llog used 23683
> > >> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > >> > /usr/informix/etc/sysadmin/db=5Finstall.sql at line 29
> > >> > 14:47:51 Error building 'sysadmin' database.
> > >> >
> > >> > Any answer ?
> > >> >
> > >> > Thanks
> > >> > Frank
> > >> >
> > >> > --001a11379f5223445f0519d177a7
> > >> >
> > >> >
> > >> > **********************************************************
> > >> > *********************
> > >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >>
> > >> ---
> > >> This email has been checked for viruses by Avast antivirus software.
> > >> http://www.avast.com
> > >>
> > >>
> > >>
> > >>
> >
>
> ***************************************************************************=
> ****
>
> > >> Forum Note: Use "Reply" to post a response in the discussion forum.
> > >>
> > >>
> > >
> >
> > --001a113a98429af5380519d1cbce
> >
> >
> >
>
> ***************************************************************************=
> ****
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1134f45c40880e0519d298f6
oninit -iy, surely?
> On 1 Jul 2015, at 16:50, Paul Watson <paul@oninit.com> wrote:
>
> They'd never notice :)
>
> And if it's a production server then oninit -i to make sure it is started in
> interactive mode :)
>
> Cheers
> Paul
>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Ricardo Henriques
>> Sent: Wednesday, July 01, 2015 10:49 AM
>> To: ids@iiug.org
>> Subject: Re: Move sysadmin database [35368]
>>
>> Not on a production site ;)
>>
>> On Wed, 1 Jul 2015 at 16:47 Paul Watson <paul@oninit.com> wrote:
>>
>>> onmode -yuck && oninit -vw>>>
>>> Is easier to type :)
>>>
>>>> -----Original Message-----
>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>>> Ricardo Henriques
>>>> Sent: Wednesday, July 01, 2015 10:43 AM
>>>> To: ids@iiug.org
>>>> Subject: Re: Move sysadmin database [35366]
>>>>
>>>> No need to restart the instance.
>>>>
>>>> It is possible to rebuild-it on the root dbspace without bouncing the
>>>> server by following the next steps.
>>>>
>>>> cd $INFORMIXDIR/etc/sysadmin;
>>>> dbaccess - db_uninstall.sql;
>>>> dbaccess - db_create.sql;
>>>> dbaccess sysadmin db_install.sql;
>>>> dbaccess sysadmin sch_tasks.sql;
>>>> dbaccess sysadmin sch_aus.sql;
>>>> dbaccess sysadmin sch_sqlcap.sql;
>>>> dbaccess sysadmin start.sql;
>>>>
>>>> If sysadmin has already been dropped then the db_uninstall.sql script
>>> will
>>>> return error, that can be ignored.
>>>>
>>>> On Wed, 1 Jul 2015 at 16:00 Paul Watson <paul@oninit.com> wrote:
>>>>
>>>>> Drop the database if it is there and restart the instance ?
>>>>>
>>>>> Cheers
>>>>> Paul
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>>> Of
>>>>>> FRANK
>>>>>> Sent: Wednesday, July 01, 2015 9:52 AM
>>>>>> To: ids@iiug.org
>>>>>> Subject: Move sysadmin database [35361]
>>>>>>
>>>>>> Guys,
>>>>>>
>>>>>> IDS12.10 FC4 Lniux 6
>>>>>>
>>>>>> Run the SQL,
>>>>>>
>>>>>> EXECUTE FUNCTION task("reset sysadmin","dbdw00");>>>>>>
>>>>>> Got this error
>>>>>>
>>>>>> 14:46:41 Maximum server connections 173
>>>>>> 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
>>>>> blocked
>>>>>> 2, Plog used 4477, Llog used 23683
>>>>>> 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
>>>>>> /usr/informix/etc/sysadmin/db_install.sql at line 29
>>>>>> 14:47:51 Error building 'sysadmin' database.
>>>>>>
>>>>>> Any answer ?
>>>>>>
>>>>>> Thanks
>>>>>> Frank
>>>>>>
>>>>>> --001a11379f5223445f0519d177a7
>>>>>>
>>>>>>
>>>>>>
>>>>
>> **********************************************************
>>>>>> *********************
>>>>>> Forum Note: Use "Reply" to post a response in the discussion
> forum.
>>>>>
>>>>> ---
>>>>> This email has been checked for viruses by Avast antivirus software.
>>>>> http://www.avast.com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>> **********************************************************
>>>> *********************
>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>>
>>>>>
>>>>
>>>> --bcaec53f3985fb7de30519d22bab
>>>>
>>>>
>>>>
>> **********************************************************
>>>> *********************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>> ---
>>> This email has been checked for viruses by Avast antivirus software.
>>> http://www.avast.com
>>>
>>>
>>>
>>>
>> **********************************************************
>> *********************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>
>> --f46d044304c4a40bd00519d24262
>>
>>
>> **********************************************************
>> *********************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> http://www.avast.com
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Actually, if the dbspace doesnt exist the task will fail immediately with
Space does not exist..
The error shown on the online log is -349 Database not selected yet..
The only related situation I find is:
http://www-01.ibm.com/support/docview.wss?uid=swg1IC89618
But it is for an early version.
I was trying to get the same errorand I crashed.
Now Im the one whos going to do an oninit i but I prefer with the v
flag, and dont forget to change FULL_DISK_INIT for the maximum support of
IO ;)
On Wed, 1 Jul 2015 at 17:13 FRANK <yunyaoqu@gmail.com> wrote:
> John,
>
> There is enough free db space there.
>
> Thanks
> Frank
>
> On Wed, Jul 1, 2015 at 11:42 AM, John Miller iii <miller3@us.ibm.com>
> wrote:
>
> > In short the following scripts from $INFORMIXDIR/etc are run
> > to create the sysadmin database. I am guessing it is having a problem
> > with
> > the dbspace name provided as the create database is failing. The first
> > sql statement in the db=5Finstall script is failing with a database does
> > not
> > exist
> > error. Please check the dbspace name and the free space in the dbspace.
> >
> > sysadmin/db=5Finstall
> > sysadmin/sch=5Ftasks
> > sysadmin/sch=5Faus
> > sysadmin/sch=5Fsqlcap
> > sysadmin/sch=5Fiwa
> > sysadmin/sch=5Foat
> >
> > John F. Miller III
> > STSM, Lead Architect
> > miller3@us.ibm.com
> > 503-747-1366
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 07/01/2015 08:15:48 AM:
> >
> > > From: "FRANK" <yunyaoqu@gmail.com>
> > > To: ids@iiug.org
> > > Date: 07/01/2015 08:16 AM
> > > Subject: Re: Move sysadmin database [35364]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > More info from log.
> > > Frank
> > >
> > > 14:41:41 Maximum server connections 173
> > > 14:41:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > blocked
> > > 0, Plog used 2098, Llog used 16042
> > > 14:42:42 SCHAPI: thread dbWorker1 task mon=5Fcheckpoint(7-14406)
> shutting
> > > down
> > > 14:42:42 SCHAPI: thread dbWorker2 task mon=5Fmemory=5Fsystem(8-7221)
> > shut=
> > ting
> >
> > > dow n
> > > 14:42:42 SCHAPI: thread dbScheduler(119) shutting down
> > > 14:42:51 SCHAPI: 'sysadmin' database will be moved to 'dbdw00'. See
> > online
> > > me ssage log.
> > > 14:42:51 Building 'sysadmin' database ...
> > > 14:46:32 Logical Log 281716 Complete, timestamp: 0x7168f433.
> > > 14:46:41 Checkpoint Completed: duration was 0 seconds.
> > > 14:46:41 Wed Jul 1 - loguniq 281717, logpos 0x217018, timestamp:
> > > 0x71690d9d Interval: 456981
> > > 14:46:41 Maximum server connections 173
> > > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > blocked
> > > 2, Plog used 4477, Llog used 23683
> > > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > > /usr/informix/etc/sysad min/db=5Finstall.sql at line 29
> > > 14:47:51 Error building 'sysadmin' database.
> > > 14:50:46 CDR Spool transaction queue completed
> > > 14:51:41 Checkpoint Completed: duration was 0 seconds.
> > > 14:51:41 Wed Jul 1 - loguniq 281717, logpos 0x79bb44c, timestamp:
> > > 0x716e34fc Interval: 456982
> > > 14:51:41 Maximum server connections 173
> > > 14:51:41 Checkpoint Statistics - Avg. Txn Block Time 0.116, # Txns
> > blocked
> > > 3, Plog used 4800, Llog used 30655
> > > 14:56:41 Checkpoint Completed: duration was 0 seconds.
> > > 14:56:41 Wed Jul 1 - loguniq 281717, logpos 0xe990018, timestamp:
> > > 0x71714244 Interval: 456983
> > > 14:56:41 Maximum server connections 173
> > >
> > > On Wed, Jul 1, 2015 at 11:14 AM, FRANK <yunyaoqu@gmail.com> wrote:
> > >
> > > > The sysadmin database is gone ....
> > > >
> > > > So,...
> > > >
> > > > On Wed, Jul 1, 2015 at 11:00 AM, Paul Watson <paul@oninit.com>
> wrote:
> > > >
> > > >> Drop the database if it is there and restart the instance ?
> > > >>
> > > >> Cheers
> > > >> Paul
> > > >>
> > > >> > -----Original Message-----
> > > >> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf
> > Of
> > > >> > FRANK
> > > >> > Sent: Wednesday, July 01, 2015 9:52 AM
> > > >> > To: ids@iiug.org
> > > >> > Subject: Move sysadmin database [35361]
> > > >> >
> > > >> > Guys,
> > > >> >
> > > >> > IDS12.10 FC4 Lniux 6
> > > >> >
> > > >> > Run the SQL,
> > > >> >
> > > >> > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > > >> >
> > > >> > Got this error
> > > >> >
> > > >> > 14:46:41 Maximum server connections 173
> > > >> > 14:46:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > > >> blocked
> > > >> > 2, Plog used 4477, Llog used 23683
> > > >> > 14:47:51 SCHAPI: SQL Error -349, ISAM Error 0 in file
> > > >> > /usr/informix/etc/sysadmin/db=5Finstall.sql at line 29
> > > >> > 14:47:51 Error building 'sysadmin' database.
> > > >> >
> > > >> > Any answer ?
> > > >> >
> > > >> > Thanks
> > > >> > Frank
> > > >> >
> > > >> > --001a11379f5223445f0519d177a7
> > > >> >
> > > >> >
> > > >> > **********************************************************
> > > >> > *********************
> > > >> > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > >>
> > > >> ---
> > > >> This email has been checked for viruses by Avast antivirus software.
> > > >> http://www.avast.com
> > > >>
> > > >>
> > > >>
> > > >>
> > >
> >
> >
> ***************************************************************************=
> > ****
> >
> > > >> Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >>
> > > >>
> > > >
> > >
> > > --001a113a98429af5380519d1cbce
> > >
> > >
> > >
> >
> >
> ***************************************************************************=
> > ****
> >
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a1134f45c40880e0519d298f6
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec53f398574e0590519d2bcec
On 01/07/15 16:50, Paul Watson wrote:
> They'd never notice :)
>
> And if it's a production server then oninit -i to make sure it is started in
> interactive mode :)
>
> Cheers
> Paul
>
That's cruel, mate! :-P
--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!
Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm