npacimport

Import Specific Files into a Regional Database

Allows user to import specific files into the regional NPAC database.

Keyword

npacimport

Permission

The user must be logged in with the user name lsmsadm.

Restrictions

This command must be run from the $LSMS_DIR directory and run only from the primary server.

Syntax

$LSMS_TOOLS_DIR/npacimport [-h] -r <region> -i <type> [-u] [-y] [-t <number>] [-c <number>] <filename>

Required Flags

-r <region>
Specifies the region whose database the imported files are intended for. This is a mandatory parameter with the following values:
  • Canada
  • MidAtlantic
  • Midwest
  • Northeast
  • Southeast
  • Southwest
  • WestCoast
  • Western
-i <type>
Specifies the type of the file to be imported into the database. This is a mandatory parameter with the following values:
  • SubscriptionVersion
  • NumberPoolBlock
  • ServiceProvNetwork
  • ServiceProvLRN
  • ServiceProvNPA-NXX
  • ServiceProvNPA-NXX-X

Parameters

<filename>
Specifies the input file of pipe delimited records to be used.

Optional Flags

-h
Display Help text and quit.
-u
Time-range update: May modify or delete and does not purge object range first. Not valid for ServiceProvNetwork.
-y
Continue on if a record update fails.
-t
Specify number of threads to use (maximum number is 10).
-c
Specify number of records in each batch to a thread (default is 1000).

Exit Codes

Table 1 lists the exit codes generated by the npacimport command.

Exit Codes: npacimport

Exit Code

Cause

Suggested Recovery

-1

Invalid syntax

Correct the syntax.

1

Database error

Contact the My Oracle Support (MOS).

2

File access error

Contact the My Oracle Support (MOS).

3

Invalid record in the input file

Correct the file entry or contact the My Oracle Support (MOS).

4

Invalid user

Change user to lsmsadm.

5

Unknown error

Contact the My Oracle Support (MOS).

This command is usually run by scripts; scripts should search for exit codes. When the command is run from the command line, the output indicates suggested recovery.