C Downloading Files from an NPAC to the LSMS
This chapter describes how you can manually FTP bulk data download (BDD) files from the NPAC to the LSMS and merge those data files into an LSMS regional database.
Overview
This chapter describes how you can manually FTP bulk data download (BDD) files from the NPAC to the LSMS and merge those data files into an LSMS regional database.
Following are some examples of situations in which you would use the BDD procedure described in this chapter (see NPAC-LSMS Download Procedure):
- To perform a download of NPAC data after an LSMS site failure (for more information about restoring an LSMS site, see Recovering from Site Failures)
- To perform a download of NPAC data when migrating an LSMS
- To update NPA split information as part of a procedure to correct an active NPA Split Entry made in error (for more information about this procedure, refer to “Reversing (Correcting) an NPA Split Entry Made in Error” in the Database Administrator's Guide)
Time Range BDD and Object BDD/Object Range BDD
Note:
Object ranges are used so that potentially very large files can be broken down into smaller files based on NPA-NXX (for SVs) or NPA-NXX-X (for NPBs) ranges. Because of the much smaller number of LRN, NPA-NXX, NPA-NXX-X, or SPID objects, ranges are not supported for these data file types.If you have installed the optional feature, NANC 3.2 Mass Update of SPID and BDD Enhancements, you can download files either for objects/object ranges or for time ranges (however, time range files are not supported for SPIDs).
Whenever you need to perform a download after a site failure or when migrating an LSMS, determine if it necessary to perform an Object BDD/Object Range BDD, or whether a Time Range BDD would suffice; a Time Range BDD can take many hours less to complete than an Object BDD/Object Range BDD.
Primarily, a Time Range BDD differs from an Object BDD/Object Range BDD in that:
- Each entry in the Time Range BDD file is processed as a create, modify, or delete in the LSMS databases; no data is deleted from the LSMS database prior to the import. Each entry in the Object BDD/Object Range BDD file is processed only as a create in the LSMS databases; all data in the LSMS database that meets the range criteria is deleted prior to the import.
- A Time Range BDD enables you to download a file from an NPAC that contains porting data for a specific period of time (you can specify begin and end timestamp values); an Object Range BDD does not allow you to specify begin and end timestamp values (the default values, 00-00-0000000000 and 99-99-9999999999, are assumed).
Note:
Time Range SPIDBDD files are not supported.
A Time Range BDD is not appropriate for correcting NPA Split information or EDR Conversion data.
NPAC-LSMS Download Procedure Summary
The following procedure is an outline of the detailed procedure shown in “NPAC-LSMS Download Procedure”.
Caution:
The following procedure requires the connection between the LSMS and each regional NPAC that needs to have files downloaded be aborted (when you stop the regional agent in 27) before the NPAC builds the files to be sent to the LSMS. The connection must be aborted so that data can be properly resynchronized after the download of files completes. Therefore, the normal transmission of NPAC data from the LSMS to the connected NEs will temporarily be precluded during this procedure. It is recommended that you contact the unresolvable-reference.html#GUID-646F2C79-C167-4B5A-A8DF-7ED0EAA9AD66 before performing this procedure.Note:
If an automatic or manual switchover occurs while files are being downloaded from the NPAC or between the time files are downloaded from the NPAC and the time they are imported into the LSMS database, perform the appropriate procedure described in “Copying Files to Other Server If Switchover Occurs”.Note:
Before you start this procedure, it is recommended that you contact the unresolvable-reference.html#GUID-646F2C79-C167-4B5A-A8DF-7ED0EAA9AD66. If you encounter any problems in the procedure, you must call the unresolvable-reference.html#GUID-646F2C79-C167-4B5A-A8DF-7ED0EAA9AD66.Prerequisite Information
Before starting this procedure, obtain the following site-specific information. Record this information on your recovery preparation worksheet (see Recovery Preparation Worksheet).
-
A login name and password for each supported NPAC. This login and password have been previously issued by the regional NPAC.
-
The FTP IP address of each supported NPAC.
-
The FTP directory names where the files are located on each supported NPAC.
-
Data file names you need to download. To determine the naming convention for each type of NPAC data file, see “File Naming Conventions”.
-
Contact the NPAC of the region for which data files are required and request that the files you need be copied into the NPAC’s FTP directory.
File Naming Conventions
All BDD file names include a creation timestamp, which is represented as <create>. Time Range BDD file names also contain start (<start>) and end (<end>) timestamps. All timestamps are represented as DD-MM-YYYYhhmmss where:
DD represents a two-digit day
MM represents a two-digit month
YYYY represents a four-digit year
hh represents a two-digit hour
mm represents a two-digit minute
ss represents a two-digit second
An example timestamp is 11-10-2006123015.
For Object Range BDD files, <start>
is always 00-00-0000000000 and <end>
is always 99-99-9999999999. These are the default values.
Table C-1 references the pages where you can find information about file naming conventions for each data type:
Table C-1 Determining Naming Conventions for NPAC Data Files
Type of Data File | See: |
---|---|
Subscription Version (Object Ranges and Time Ranges are supported) |
|
Number Pool Block (Object Ranges and Time Ranges are supported) |
|
LRN, NPA-NXX, and NPA-NXXX (Only Objects are supported) |
|
SPID (Only Objects are supported) |
Note:
Object ranges are used so that potentially very large files can be broken down into smaller files based on NPA-NXX (for SVs) or NPA-NXX-X (for NPBs) ranges. Because of the much smaller number of LRN, NPA-NXX, NPA-NXX-X, or SPID objects, ranges are not supported for these data file types.Subscription Version File Naming Convention
The file name for subscription version files is represented as <NPANXX-NPANXX>
, which indicates the range of NPA-NXX values contained in the download file. The file extension values depend on whether you are requesting a file for an Object Range BDD or for a Time Range BDD, as shown in Table C-2.
Table C-2 NPAC File Naming Convention for Subscription Version Data File
Range Type | Naming Convention |
---|---|
Object Range BDD |
|
Time Range1 BDD |
|
1Time Range files are supported only if you have installed the NANC 3.2 feature 2For format of |
Following are examples of uses for subscription version BDD files:
-
If you need to bulk download all subscription versions from the NPAC, use the following file name:
<000000-999999>.<create>.00-00-0000000000.99-99-9999999999
-
If you need to bulk download all subscription versions for a time period from midnight February 12, 2006 to midnight February 13, 2006 in a file created February 14, 2006 at 9:00 a.m., use the following file name:
<000000-999999>.14022006090000.12022006000000.13022006000000
-
If you need files to correct an NPA split, specify three Object Range files that have the same NPANXX values before and after the hyphen:
-
One file with the old NPANXX value
-
One file with the correct new NPANXX value
-
One file with the erroneous new NPANXX value
For example, if an NPA split was erroneously entered from 909-860 to 123-860 instead of correctly from 909-860 to 124-860, specify the following files:
-
909860-909860
-
124860-124860
-
123860-123860
Because no file extension is specified in these files, the default values of
00-00-0000000000.99-99-9999999999
are assumed. -
Number Pool Block File Naming Convention
The file name for number pool block files is represented as <NPANXXX-NPANXXX>
, which indicates the range of EDR NPA-NXXX values contained in the download file. The file extension values depend on whether you are requesting a file for an Object Range BDD or for a Time Range BDD, as shown in Table C-3.
Table C-3 NPAC File Naming Convention for Number Pool Block Data File
Range Type | Naming Convention |
---|---|
Object Range BDD |
|
Time Range1 BDD |
|
1Time Range files are supported only if you have installed the NANC 3.2 feature 2For format of |
These file types exist only if the NPAC supports Efficient Data Representation (EDR). Following are examples of uses for number pool block BDD files:
-
If you need to bulk download all number pool blocks from the NPAC, use the following file name:
<0000000-9999999>.<create>.00-00-0000000000.99-99-9999999999
-
If you need to bulk download all number pool blocks for a time period from midnight February 12, 2006 to midnight February 13, 2006 in a file created February 14, 2006 at 9:00 a.m., use the following file name:
<0000000-9999999>.14022006090000.12022006000000.13022006000000
-
If you need files to correct an NPA split, specify three files, each with the NPANXX value followed by a 0 before the hyphen and the NPANXX value followed by a 9 after the hyphen:
-
One file with the old NPANXX value
-
One file with the correct new NPANXX value
-
One file with the erroneous new NPANXX value
For example, if an NPA split was erroneously entered from 909-860 to 123-860 instead of correctly from 909-860 to 124-860, specify the following files:
-
9098600-9098609
-
1248600-1248609
-
1238600-1238609
-
Because no file extension is specified in these files, the default values of 00-00-0000000000.99-99-9999999999
are assumed.
LRN, NPA-NXX, and NPA-NXXX File Naming Convention
Note:
In contrast to SVs and NPBs data file types, there are a much smaller number of LRN, NPA-NXX, and NPA-NXX-X objects; therefore, ranges are not supported for these data file types, as shown in Table C-4.
-
The file name for LRN files is represented as
<LRN>
, which indicates the LRN value contained in the download file. -
The file name for NPA-NXX files is represented as
<NPANXX>,
which indicates the NPA-NXX value contained in the download file. -
The file name for NPA-NXXX files is represented as
<NPANXX>,
, which indicates the EDR NPA-NXXX value contained in the download file. This file type exists only if the NPAC supports Efficient Data Representation (EDR).
The file extension values depend on whether you are requesting a file for an Object BDD or for a Time Range BDD, as shown in Table C-4.
Table C-4 NPAC File Naming Convention for LRN, NPA-NXX, and NPA-NXXX Network Data Files
Type | Naming Convention |
---|---|
Object BDD |
|
|
|
|
|
Time Range1BDD |
|
|
|
|
|
1 Time Range files are supported only if you have installed the NANC3.2 feature 2 For format of |
SPID File Naming Convention
Note:
In contrast to SVs and NPBs data file types, there is a much smaller number of SPID objects; therefore, ranges are not supported for this data file type, as shown in Table C-5.
The SPID naming convention only applies to Object BDD files; Time Range is not supported. The file name for SPID files is represented as <SPID>
, which indicates the SPID value contained in the download file..
Table C-5 NPAC File Naming Convention for SPID Network Data File
Type | Naming Convention |
---|---|
Object BDD |
|
2 For format of |
Only the <create>
timestamp field is supported.
Because no file extension is specified in these files, the default values of 00-00-0000000000.99-99-9999999999
are assumed.
NPAC-LSMS Download Procedure
Note:
Before you start this procedure, it is recommended that you contact the unresolvable-reference.html#GUID-646F2C79-C167-4B5A-A8DF-7ED0EAA9AD66. If you encounter any problems in the procedure, you must call the unresolvable-reference.html#GUID-646F2C79-C167-4B5A-A8DF-7ED0EAA9AD66.Caution:
The following procedure requires the connection between the LSMS and each regional NPAC that needs to have files downloaded be aborted (when you stop the regional agent in step 26) before the NPAC builds the files to be sent to the LSMS. The connection must be aborted so that data can be properly resynchronized after the download of files completes. Therefore, the normal transmission of NPAC data from the LSMS to the connected NEs will temporarily be precluded during this procedure. It is recommended that you contact the unresolvable-reference.html#GUID-646F2C79-C167-4B5A-A8DF-7ED0EAA9AD66 before performing this procedure.Note:
If an automatic or manual switchover occurs while files are being downloaded from the NPAC or between the time files are downloaded from the NPAC and the time they are imported into the LSMS database, perform the appropriate procedure described in “Copying Files to Other Server If Switchover Occurs”.Copying Files to Other Server If Switchover Occurs
When switchover (whether automatically or manually initiated) occurs, the standby server, which has been replicating the database on the active server, takes over to be the newly active server. However, any files that have been downloaded from the NPAC exist only on the server to which they were downloaded. If switchover occurs during a BDD procedure, the quickest way to get the files on the newly active server is to perform one of the procedures described in this section.
The following notifications indicate that a switchover has been initiated and completed:
LSMS4000|14:58 Oct 22, 2005|xxxxxxx|Notify:Sys Admin - Switchover initiated
LSMS4001|14:58 Oct 22, 2005|xxxxxxx|Notify:Sys Admin - Switchover complete
Perform one of the following procedures:
-
If switchover occurred after all files have been downloaded from the NPAC, perform the procedure described in “Copying All Downloaded Files After Switchover”
-
If switchover occurred while files are being downloaded from the NPAC, perform the procedure described in “Copying Partially Downloaded Files After Switchover”
Copying All Downloaded Files After Switchover
If switchover is initiated and completed after all the files you need have been downloaded from the NPAC but before you have imported them into the LSMS database, perform the following procedure.
Copying Partially Downloaded Files After Switchover
If switchover is initiated and completed while files are being downloaded from the NPAC, some of the files may exist on the previously active server and some may exist on the newly active server. The safest procedure is to repeat the BDD procedure.
However, if you have already downloaded a number of files, you can choose to determine which files exist on which server and use the following procedure to copy the files that exist on the non-active server to the active server.