SAND CDBMS Administration Guide
The Nucleus.ini File

 

Previous Topic:
Nucleus.ini file Parameters - Connection Sections
Chapter Index
Next Topic:
Nucleus.ini file Parameters - DCL Section

 

Nucleus.ini file Parameters


[CLIENT] Section Parameters

The [CLIENT] section contains parameters that set options for client applications connecting to database instances. The TempDrive, TempCache, and TempPage parameters are exclusive to the SAND CDBMS Data Loader program (ndlm) running in Parallel Loader mode.


DatePic
A picture string indicating how a value stored using the DATE data type will appear in output from the client application, as well as the format in which date values will be presented to the SAND CDBMS data loader (ndlm). Additionally, date constants may be referenced in SQL statements according to the user-defined date picture, as well as using the standard date formats.

Default: yyyy-mm-dd (for July 1, 2003, SAND CDBMS will display 2003-07-01).

Entries can be various combinations of the letters y for year, m for Month, d for Day, and w for Weekday (lowercase only), along with any other characters used as separators. Some common separators are colons (:), hyphens (-), and slashes (/). The Day, Month, Year and Weekday components can be ordered in any way, for example: dd/mm/yy, mm/dd/yy, yy/mm/dd.

If the date picture specifies only the last two digits of the year (yy), SAND CDBMS must assume a default century for date constants that use this format. This determination is based on the last two digits of the year:

Last two digits Base year
00 - 50
2000 (21st century)
51 - 99
1900 (20th century)

The full year is produced by adding the last two year digits to the base year. For example, if yy = 04, the base year is 2000, and the full year is 04 + 2000 = 2004.

If the user-defined date picture is invalid, date values will be displayed using the default format.

Date Picture Components

Day

d Integer between 1 and 31, corresponding to day of month; leading zeros are not displayed
dd Integer between 01 and 31, corresponding to day of month; leading zeros are displayed
ddd Integer between 1 and 365 (366 in a leap year), corresponding to number of days since first of the year; leading zeros are not displayed

Month

m Integer between 1 and 12, corresponding to a month; leading zeros are not displayed
mm Integer between 01 and 12, corresponding to a month; leading zeros are displayed
mmm A three-character abbreviation for the month corresponding to the stored month number (for example, JAN, FEB, MAR, and so on)
mmmm Month name corresponding to the stored month number (for example, January, February, March, and so on)

Year

yy Last two digits of the stored year
yyyy Entirety of the stored year


Weekday

ww An integer corresponding to the day of week (Monday=1, Tuesday=2, Wednesday=3, and so on)
www Three-character abbreviation for the day of the week (for example: MON, TUE, WED, and so on)
wwww The day of the week on which a date falls (for example: Monday, Tuesday, Wednesday, and so on)

 

The following examples show some date pictures using the date August 31, 2003:

Date Picture Displayed Date
m/d/yy 8/31/03
mm/dd/yy 08/31/03
mm/dd/yyyy 08/31/2003
dd-mm-yy 31-08-03
yyyy-mm-dd 2003-08-31
mmm-dd-yyyy AUG-31-2003
mmddyyyy

08312003

mmmm,yyyy August,2003

TimePic
A picture string indicating how a value stored using the TIME data type will appear in output from the client application, as well as the format in which time values will be presented to the SAND CDBMS data loader (ndlm).

default: hh:mm:ss (for ten minutes past 2 pm, SAND CDBMS will display 14:10:00)

Entries can be various combinations of the letters h for Hours, m for Minutes, and s for Seconds (lowercase only); any other characters can be used as separators. Commonly used separators are colon (:), hyphen (-), and period (.). The Hour, Minute, and Second components can be ordered in any way, for example: hh:mm:ss, ss:mm:hh, hh:ss:mm. For a 24-hour clock, place the number 24 at the end of the picture. For a 12-hour clock, place the number 12 at the end of the picture. If you do not specify the clock type, a 24-hour clock is assumed. For 12-hour clocks, you can include the characters 'am' in your picture in the location you want 'am' or 'PM' to appear. Use the case you want used in the display.

As per the 24-hour clock format, noon is represented as 12:00:00 and midnight is 00:00:00.

If the user-defined time picture is invalid, time values will be displayed using the default format.

Time Picture Components

Hour

h An integer between 0 and 23 (inclusive), corresponding to the hour of the day; leading zeros are not displayed
hh An integer between 00 and 23 (inclusive), corresponding to the hour of the day; leading zeros are displayed

Minute

m An integer between 0 and 59 (inclusive), corresponding to a number of minutes; leading zeros are not displayed
mm An integer between 00 and 59 (inclusive), corresponding to a number of minutes; leading zeros are displayed

Second

s An integer between 0 and 59 (inclusive), corresponding to a number of seconds; leading zeros are not displayed
ss An integer between 00 and 59 (inclusive), corresponding to a number of seconds; leading zeros are displayed


The following examples show time format masks and the resulting output, using the time 15:08:25.

Time Picture Displayed Time
12-hour clock:
hh:mm:ss am 12 03:08:25 PM
hh.mm 12 03.08
AM h-m-s 12 PM 3-8-25
24-hour clock:
hh:mm:ss 24 15:08:25
hh.mm 24 15.08
h-m-s 24 15-8-25

 

TempDrive
The TempDrive parameter sets the drive(s) where the temporary loader files will be written. Multiple drives can be listed, separated by semicolons (;). The number of temporary files created by the loader is related to the ndlm -j flag value: if the -j value is n, then there will be at least n temporary files.

Default: . (current directory)

Note:
For best results, ensure that the temporary drive is not located on the same disk as the database or, especially, the flat file. In addition, make sure that the amount of free disk space in the temporary drive is at least three (3) times the size of the flat file.


TempCache

The TempCache parameter allocates buffer space in memory (in megabytes) to hold Virtual File System (VFS) data during Parallel Loader operations. By default, VFS data is not cached. Enabling this parameter (by setting it to a positive value) can speed up load operations and SCT File creation.

Default: 0
Minimum: 0
Maximum: none


TempPage

The TempPage parameter sets the Virtual File System (VFS) page size (in kilobytes). Data is written to the VFS in clusters of this size. If multiple locations for the VFS are specified by the TempDrive parameter, one page of data at a time will be written to each location in "round robin" fashion.

Default: 32
Minimum: 1
Maximum: none

 

Sample [CLIENT] Section

[CLIENT]
DatePic=dd-mm-yy
TimePic=hh.mm.ss
TempDrive=/usr/sand/tmp;/drv1/tmp;/drv2/tmp
TempCache=32
TempPage=4

 

Previous Topic:
Nucleus.ini file Parameters - Connection Sections
Chapter Index
Next Topic:
Nucleus.ini file Parameters - DCL Section