SAP OS/DB Migration Questions

Sample osdb migration question 1. Which R3load R3load versio version n is used used for migrat migrating ing SAP R/3 4.! 4.! s"stem# s"stem# Same $ernel of 4.! s"stem% &. What What is the purp purpose ose of the the tas' tas' file# file# Ans( Since ).1 it use to restart a failed R3load process. *he *+, files is read to find the last -rite portion onl" Previous version uses .*+, to restart a failed R3load0 *as' *as' files are created b" R3load from eisting .S*R files. 2t simplifies the R3load restart as" to use table/inde eception handling. 2mplemented since ).1 Support tablesplitting from ).4 3. Which Which process processes es create create the the R3load R3load command command file# file# Ans( R3setup / sapinst / igmon 4. 2f "ou "ou have the the follo-ing follo-ing contents contents in the import import tas' tas' file file * A345 , +$  6 A345 2 +$  * A5) , +$  27 the import tas' status is changed from 8o'9 to eq then -hat -ill be the outcome. * A345 , err  6 A345 2 err  * A5) , err  !ecause the table A345 is alread" loaded in to the database% -hen it tries create the table it thro-s an error :table is alread" e ist : and so on....

5. R3S;,< R3S;,<$ $ creates creates -hic -hich h of the follo follo-in -ing g file file a. 66=>6!S?.*P= .*P= b. DBSIZE.XML .XML c. 2nit 2nitia iall t ten entt fil filee d. ,omm ,omman and d fil file ). *he +S/6! +S/6! igration igration service service perform performss the follo-ing follo-ing a. Performance Performance anal"sis anal"sis of the source and target target s"stem s"stem  b. Performance anal"sis of the target migrated migrated s"stem c. Is a paid paid servi service ce pro provid vided ed by by SAP SAP d. Needed Needed for every every produ productiv ctivee SAP syste system m invoved invoved..

@. Which files are used to anal"sis if there is an issue -ith the migration 'e" & correct ans-ers0 a. SAPINS! o" fies  b. R3S*p log files c. port log files d. MI#$E%.o" B. *he information from -hich files are used to create the igration 'e" for command file?G a. *able A5) is deleted and recreated  b. *able A5B is created c. Primar" 'e" A,5@E -ill not be created Ans( R3load Fo is used omit * H? *able% 2H? 2nde% IH? Iie-% PH? Primar" $e"0 *his command -ill omit the creation of primar" 'e" and A5B inde 1. *he R3load activit" 8struct9 in the means 11. 2n an 22J proKect -hich of the follo-ing holds true a. 22J source s"stem base release should be SAP ).& or later   b. *here must be enough space in the source s"stem for creating the logging table c. *he online data transfer is performed -hen the source s"stem is shutdo-n 7eatures( +nline eport of selected largest tables. *riggerHbased logging of table updates. +nline table s"nchroniLation bet-een source and target Safe s"nchroniLation protocol to ensure data co nsistenc". 7inal eport of remaining tables in an acceptable time frame.

1&. Which a.  b. c.

of the follo-ing are heterogeneous s"stem cop" A2M 5.1/+racle B.1  A2M 5.3/+racle 1g AIX '.()*race +.( Soaris ) *race (," Windo-s 3& bit / +racle 3& bit  Windo-s )4 bit/ +racle )4 bit

13. 2f the R3load process terminated due to space not available in the database -hile creating the primar" 'e". After the space is provided and R3load started again -hat -ill be the effect a. R3load -ill proceed successfull" -ithout an" error  b. !-e primary ey /i be recreated a"ain c. R3load error occurs 14. What is the location of the 66=>6!S?.*P= file a. port dump director" b. E&port DB directory c. port 6ata director" d. port 6!/>6!S? 15. *he database -as reorganiLed due to -hich all the obKects in the customer specific tablespaces have been relocated. *he A!AP dictionar" information ho-ever is not updated about the changes in the database the R3=6,*= and R3S;,<$  process have been run on the s"stem -hat is the effect a. *he R3load errors out  b. R3S;,<$ create the 6!S2;.M= for the target database containing the customer tablespaces c. 01LD2!L creates t-e 3.S!0 fies d. 66D= table updated 1). Which of the follo-ing does R3S;,<$ use to compute the siLe of the target 6atabase a. R3=oad command file b. DDL*ADD c. Structure file d. 66D= 1@. What information is contained in the .*+, files Ans(
Where condition in case of table splitting.  Cumber of tables unloaded and time stamps.

1B.
&1. *he program 8dipgntab9 performs G. nsuring Abap 662, 6ictionar"0 consistenc"% *he program dipgntab -ill be started to update the sap s"stem active nametab from database dictionar"table field order0 ,onsistenc" bet-een A!AP and database dictionar".

&&. 7or R3=oad >4.)6 if an +S crash occurs during the s"stem cop"

&3. R3=oad?).1 performs the follo-ing

an" questions related to chapter @ on the contents and structure of files.