on 06-20-2008 6:33 PM
Usage: R3szchk [options]
options:
-h print help information
-v print version information
-p <path> read input files in <path>
-o <splitpath> write output files to <splitpath>
(only effective in split case)
-n <name> alternative name for DDL<DB>.TPL
-f <files> list of input file names
(separated by spaces)
-s DB | DD determine size of tables and indices
from DB or SAP DDIC
-g <dbs> <dbparams> compute targetsize
(dbs = ada, inf, ora, ...)
-z <splitdb> <charsplitpar> <numsplitpar> split
-x <files> exclude list of files from split
(separated by spaces)
-y <splitsuffix> suffix for splitted STR files
-w <writedb> <writeparams> write DDL<DB>.TPL option
-a switch to upgrade mode (no effect)
What does <dbparams> mean?
Edited by: Ulf Schmidt on Jun 20, 2008 7:33 PM
-s DB | DD determine size of tables and indices
from DB or SAP DDIC
when I need to use DB or DD?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ralph,
thanks for your information. I started the r3szck:
./R3szchk -s DD -g ora 8 -p $/$_export/DB/ORA -f $
Regards
Ulf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
DB parameters list:-
pga_aggregate_target= 70% of db server main memory
u2022_pga_max_size= 2GB
u2022db_cache_size = 20% of db server mainmemory
u2022db_file_multi_block_read_count = 128
u2022db_writer_processes= 20 (set to 1 if platform supports async_io)
u2022log_buffer= 10MB (reduce to 1 if platform supports async io)
u2022filesystemio_options= setall
u2022parallel_execution_message_size = 16384/8192KB
u2022parallel_threads_per_cpu= 1
u2022parallel_max_servers = # of R3load processes *
of CPUs * 2
u2022processes= processes + parallel_max_servers
And also look into OSS note:936441
Regards,
Srini Nookala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ulf,
it means Page or Block size of the database. For MAXDB, Oracle and SQL Server you could use 8192 and for DB2 16384 or any other supported block size. May be the block size is in kByte, then use 8 or 16 respectively. You could find it out easily by running it on a table of known size.
But usually you should run it from SAPinst.
Regards
Ralph
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.