Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 139 140 141 142 143 144 < 145 > 146 147 148 149 150 151 .. 218 >> Next


Resizing Your Windows 2000 Application Event Log

The Application Event Log should have been set to the optimum size during installation. Use this procedure only if you need to increase the size in order for the log to hold an average week of application event messages.

Normally, a file size of 2048 KB is sufficient. If you find that this does not hold seven days of event messages, increase the size follows:

Step Action
1 Select Start -> Programs -> Administrative Tools > Event Viewer.
Event Viewer displays the folder tree, which should include:
Application Log
Security Log
System Log
2 Click on Application Log.
The list of event files appears in the right-hand window:

11 - 10 Teradata RDBMS Database Administration

Chapter 11: Handling System Dumps

Handling Windows 2000 System Dumps

Step 2

cont

Action

bj I

iE R

L-=Ld



rLlI E '.l^r fc r^e .L qcaj



SfiCLftr-L^

LCt



TtK DOLT . LT Colr . I -- -
^1Erfa . bn :. :DCJ ? ); " 11| : HniK HHi -J--1
.y Lrf Jim ar Iifl i . . ." 1" I Il it JS .. ^l-"" i-i ò 1-
J^i lrtrm -... Il . .. Ivlnr Nov ,.1 VJi
// I IIlTf I (1 -I ."Tl Il .-.. 11--. -YC IfTJT1 J-
-^[rfbmactfl - . . -JLJ LL -.:.1 .. .,:1.1 . ' . JL.'.' J'-
-?^ IrJrmar iai i- :. L JL] LL IL:. < .. ',:4 .- . . Now JL .1.' -J-
-^nfrmaHl <ii Il - - . v -. ò I- -. 44
-.-I^trf : j:.LJU L. : -,1.. Jj.l-L. ò'- -L-JJL J-'-
- '. 1 I - 1 .. ".I. T . ! ò..- -r.-n-; -J-'-
^trfDTTrtaCCfl .',ji < . .:i- J IIO-I = I V J.
-1^DV JTfH I IfI , . .-".. "( , I-T,- J-
^LrfimarLfl i..;r-| I" -..-. , . ò" , 1--:-.7 J-
-.^Lrtmrt t.LL.1 L. JtrTJ .. --: HOIK JL .'J J-
.^TrfTnvThfl 11..,1 I I ':--.. '.hi . -. Nnnr ,- i| VA
W^rnnc J 1,,.1..1 L. .'.:^-.. J j. I j. L Noi= J=JJi -J-
-3^ ErJrnfrar Cfl iK.am : ::::< -JrfTids Hoik -J-'-
pTrfrTiiHMTi -in,. I I il< .. Mil I- /- I Il
zrmarlzci -,.. I I I .. ..... ..... '-Ml M-I
^ Enforrndbn -I QCffi11 ",I, T , - NN-I- T--I-Il J- -
i >r
-JBid4 . Yr rs-acktan iJssoid-^! . ||| Itwrrt Ij 0: Pr

Click on Action (the left-hand button on the top tool bar) and select Properties. The Application Log Properties screen allows you to change the log size:

Give the Maximum Log Size at least 2048 KB, but calculate enough space to accommodate applications besides Teradata that might generate dumps.

3

4

11 - 10

Teradata RDBMS Database Administration Chapter 11: Handling System Dumps

Handling Windows 2000 System Dumps

Step Action
5 Give the Application Log enough space to hold at least seven days of event messages from all applications.
6 Under "When maximum log size is reached:", set "Overwrite events older than" to at least 7 days.
7 Click OK to save the new setup.
8 In the Event Viewer Log Menu, click Exit to complete the Applications Event Log setup.

Increasing Your Paging File Size

Your paging file size and dump settings should have been defined during installation, but you can change them if necessary. If you have questions on settings or sizes, contact the TSC.

The primary pagefile is located on the same drive as the Windows 2000 operating system. The default paging file size is generally the size of physical memory plus 12 megabytes (MB). On computers with 4 GB or more of physical memory, a paging file size of 2060 MB is recommended.

The following procedure explains how to access the help display:

Step

Action

To find your system memory, place the mouse pointer on your My Computer iconand press the right mouse button.

Select Properties. The Properties screen shows your computer memory in kilobytes, as follows:

1

2

11 - 10 Teradata RDBMS Database Administration

Chapter 11: Handling System Dumps

Handling Windows 2000 System Dumps

Step

Action

Access the tool you want to use:

IF you .

THEN .

do not have the NCR State Saver

use the Windows 2000 Help information:

Step

Action

Start -> Help

Type in the keyword: Paging files

From the index choices, select:

setting default size

and press the Display button.

The paging file help appears in the text window.

I Windows ZDOD _ I ? I >: |

Hde Back Forward JptiDiis WebHeIp

Index I Search

, n the keywad Ic fhd:

|pajifig ^elirgr

paginate checkrig Fagir l-u ifguring rcc' deired Hpplinj be Glioi op:imiznq Ixal 7| 47s

nhflicing "ir uol Yicnror/ (Jcyiliy. CKUCiSVl

Han'. paelte?, in Painl

pa ICi

n Windows t Xe

|<7[|

ܳ' IincpL^

Display

Changing the default paging tile si/e on Inrge memorv corn puLers

]f vol have 4 ^nabvte; GE) or mors of memory cn your ServBrj you may lVcliL \u dial Jic default ;iic u'' fCU' psq nq rile In IAirdD1Vf LUUU1 the Hi=f^ilit paging file 27 ie rp-|^r^lly -Z r-icgoD^tcs (MB) Iargerthon physical , on corriDuter; >th 4 tR "ir nf rh^irFi , th cn incffccti/ ; " di?k sdocd. A waging fi s z- Df ^udl lib s the ^ si 7 3 for computers with 'I GB Dr rnorD of ph/ficD nnemary.
Previous << 1 .. 139 140 141 142 143 144 < 145 > 146 147 148 149 150 151 .. 218 >> Next