Conference orarep::nomahs::dbstars

778.0. "-SYSTEM-F-EXLNMQUOTA w/DDD transfer" by BROKE::GREEN () Wed Apr 30 1997 16:52

Copyright (c) 1997 by Oracle Corporation.  All Rights Reserved.

KEYWORDS: -SYSTEM-F-EXLNMQUOTA Replication DDD transfer hang hung SQL monitor

TITLE:    -SYSTEM-F-EXLNMQUOTA error running Replication Option transfer

PRODUCT:  Rdb Replication Option V7.0

OP/SYS:   OpenVMS VAX and OpenVMS AXP

SOURCE:   Oracle Worldwide Customer Support


SYMPTOM: You execute a Replication Option transfer and (1) the process starting
         the transfer hangs in SQL and (2) the Replication Option monitor 
         process crashes with a bugcheck dump file.
          
         Look for the logfile called DDAL_nodename_START_TM.LOG.   The location
         of this file is determined by a parameter when starting Rdb 
         Replication Option.  The default area is SYS$SYSROOT:[SYSEXE]

         In the log file you find the following errors:

         %RDB-F-BUG_CHECK, internal consistency check failed
         -DDAL-I-BUGFILCRE, Replication Option for Rdb bugcheck dump file 
         -DDAL-E-MBXERR, mailbox error in the transfer monitor
         -SYSTEM-F-EXLNMQUOTA, logical name table is full


RESPONSE:  Either the process which defined the transfer has a JTQUOTA value
           which is too small in AUTHORIZE, or the SYSGEN values for 
           PQL$JTQUOTA are too small.


WORKAROUND:  To change the user's JTQUOTA quota in AUTHORIZE:

             $ MCR AUTHORIZE
             UAF> MOD joe_user /JTQUOTA=4096

             You must then log out and log back in to have the UAF change take
             effect.

             To change the SYSGEN values:
             
             $ MCR SYSGEN
             SYSGEN> USE ACTIVE
             SYSGEN> SHOW /PQL

Parameters in use: Active
Parameter Name            Current    Default     Min.     Max.     Unit  Dynamic
--------------            -------    -------    -------  -------   ----  -------
PQL_DJTQUOTA                 1024       1024        -1        -1 Bytes      D

             SYSGEN> SET PQL_DJTQUOTA 4096
             SYSGEN> WRITE ACTIVE
             SYSGEN> EXIT

             These SYSGEN parameters are dynamic so you don't have to reboot
             your system.  The PQL values used in this example were chosen
             only to show the syntax of the command.  You may not need to
             use values as high as what's in the example.
             



\
\ CONTRIBUTORS:
\
\	Technical: Don Green
\	Editorial: 
\
\

    Sent to Mem on 4/30/97