Re: Database Journaled

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
How was the table created?

Basically you have a few options
1 - Delete and recreate the library using the SQL command CREATE
COLLECTION instead of the OS/400 command CRTLIB.  The CREATE COLLECTION
will automatically create the necessary journals, and a plethora of other
objects for this library.
2 - Create the journals and receivers yourself.  See GO CMDJRN
3 - Ignore the message and just be aware that commitment control and some
forms of referential integrity will not be available to you.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Ren Fu Ping" <fupingren@yeah.net>
Sent by: rpg400-l-admin@midrange.com
04/23/2002 06:03 AM
Please respond to rpg400-l


        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        Database Journaled


This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Message . . . . :   Table ACRX10W1 in NTCOMMON created but could not be

  journaled.

 Cause . . . . . :   The table ACRX10W1 was created in NTCOMMON, but the
table

   could not be journaled. The journal QSQJRN in NTCOMMON may be damaged,

   removed, unable to accept journal entries, or may not be created. The
SQL

   name for the table is ACRX10W1 and the system name for the table is

   ACRX10W1. For a distributed table, journaling could not be started on
all of

   the systems.  The journal QSQJRN in NTCOMMON must exist, and be able to

   accept journal entries, on each of the systems in the node group.
Recovery

   . . . :   The table was created, but until the table is journaled,

   COMMIT(*CHG), COMMIT(*CS), and COMMIT(*ALL) will not be allowed for
table

   ACRX10W1. If journal QSQJRN does not exist in NTCOMMON, create the
journal

   (CRTJRN command) and start journaling (STRJRNPF command). If the
journal is

   in error, correct the problem to the journal If the table is
distributed,

   correct the problems on all the systems in the node group and start

   journaling (STRJRNPF command).





Hello, Everybody

           An CL programm running in batch has display the error  message
on the above, but running in interactive has nothing, this CL programm is
calling an SQLRPG that compiled by option commit(*NONE).  How to solve it?
thanks for any suggestion.



Regards!

Ping











--

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.