Additional Blogs by Members
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Unicode - Episode 0.005: Journey to the Edge of Quality

JimSpath
Active Contributor
‎2007 Dec 23 7:10 AM
0 Kudos
478
Prior/Later Unicode Conversion Episodes [Updated 12-Feb-2008]
  • 0.001 - [Destroyed by space pirates]
  • 0.002 - Community Day and Onward
  • 0.003 - Revenge of The Space Monster
  • 0.004 - Children of Murphy
  • 0.005 - Journey to the Edge of Quality
  • 0.006 - The Calm Before the Storm of Quality
  • 0.007 - Passage to Production
  • 0.008 - Unicode The Final Descent
  • 1.000 - The Final Chapter
Lessons learned during post-Unicode conversion testing in development
  • Extended syntax check - previously would not fail; after Unicode, will fail.  Developers have safely ignored this up till now.
  • Oracle environment scripts - some head scratching to get all the tools to work.
  • SCM development - Java update was required, missing on 1st plan
  • LiveCache - Missed executable patches on failover node, one more checklist tickler.
  • R/3 and SCM copybacks are complete; needed to wipe pre-Unicode SQL Trace file.
Planning for Quality and Production
The SAP Unicode Conversion guide has a graphic showing system requirements.

Our landscape for this second phase is more complex:

Each cylinder represents a working database, with disk storage up to 6TB, not including the file export space.

Quality System Preparation

  As of 21-Dec-2007, here is where our R/3 pre-Unicode scanning stood:

 


 

We expect to have under 100,000 vocabulary words to identify, similar to what we saw in our prior R/3 and BW conversions. 

For the last several days, we pushed the TST servers average CPU values up and over 90%.




SPUMG TST status
This is a tabular view of the above SPUMG status screen shot, showing progress on the preconversion steps.
Job StatusJob NumberScan LevelIn ProcessInitialCompletedWarningIgnored
 0Consistency Check0039,08500
Is running15Tables without Language Information153,45227,8494500
 0Tables with Ambiguous Lang. Information07,769000
 0Tables with Language Information07,562000
 0Reprocess0449000
 0INDX Table Analysis0404000

Here is an extract from SM66, showing the background process jobs doing the table scans.  Some have been running for over a week. 

SM66 during TST scans
ServerTyp     PIDStatus  TimeUserReportAction/Reason for waitingTable
towtstap01_TST_02BTC364740running19231SCHEDGPASIAZMMTBLEXSequential readMSEG
towtstap01_TST_02BTC761990running753406QA-BDILLINGUMG_SCAN  
towtstap01_TST_02BTC704710running73236QA-BDILLINGUMG_SCAN  
towtstap01_TST_02BTC708774running86396QA-BDILLINGUMG_SCANSequential readS751
towtstha02_TST_02DIA3215488stopped QA-EMILLER   
towtstha02_TST_02BTC3035204running753340QA-BDILLINGUMG_SCANSequential readCKMI1
towtstha02_TST_02BTC3129558stopped73SCHEDULER CMRCV / 15550141 
towtstha02_TST_02BTC3137790running576023QA-BDILLINGUMG_SCANSequential readRFBLG
towtstha02_TST_02BTC3391634running90024QA-BDILLINGUMG_SCANSequential readCDCLS
towtstsv01-z_TST_02BTC2576532running77714QA-BDILLINGUMG_SCANSequential readCE1NAPT
towtstsv01-z_TST_02BTC11702480running47810QA-BDILLINGUMG_SCAN  
towtstsv01-z_TST_02BTC4284468running47650QA-BDILLINGUMG_SCAN  
towtstsv01-z_TST_02BTC7499924running47641QA-BDILLINGUMG_SCAN  
towtstsv01-z_TST_02BTC8106142running46970QA-BDILLINGUMG_SCANSequential readS710
towtstsv01-z_TST_02BTC3567646running3259QA-BDILLINGUMG_SCAN  
towtstsv01-z_TST_02BTC3518526running46740QA-BDILLINGUMG_SCANSequential readVBFA
towtstsv01-z_TST_02BTC11518024running46649QA-BDILLINGCL_UMG_W  
towtstsv01-z_TST_02BTC3576046running44331REGRESSIONZMMTBLEXSequential readMSEG
ST04
Finally, here are the SQL statements for UMG_SCANNER that have done more than 10,000,000 disk reads... 
ExecutionsDisk reads  Reads/ExecBuffer gets  Bgets/exec Proc. rows   Rproc/ExeSQL statementProgram nameFirst load time
3043,108,5151,436,95157,547,616191825458,062,0901,935,403SELECT FROM CKMI1... UMG_SCANNER2007-12-15/16:07:40
12539,056,422312,45152,620,554420964171,961,3091,375,691SELECT FROM BSIS...UMG_SCANNER2007-12-15/00:18:28
433,698,9928,424,74833,492,34683730873,335,905833,976SELECT FROM CE1NAPT ...UMG_SCANNER2007-12-20/12:37:22
23227,035,126116,53150,633,044218246461,837,1691,990,678SELECT FROM COEP ...UMG_SCANNER2007-12-12/17:37:49
25225,443,669100,96754,683,309216997502,091,4961,992,427SELECT FROM ZZGLA...UMG_SCANNER2007-12-12/17:12:20
15623,840,795152,826189,698,7761216018103,474,387663,297SELECT FROM RFBLG ... UMG_SCANNER2007-12-12/17:36:06
5620,369,302363,73827,064,66348329864,534,8791,152,409SELECT FROM BSIS... UMG_SCANNER2007-12-15/00:38:01
119,962,70019,962,7009,820,35898203582,000,0012,000,001SELECT FROM BSIS ... UMG_SCANNER2007-12-14/11:46:51
519,680,1873,936,037140,810,2122816204277,661,17315,532,235SELECT FROM RFBLG...   UMG_SCANNER2007-12-12/16:35:04
115,602,39415,602,39459,775,263597752632,000,0012,000,001SELECT FROM LIPS ... UMG_SCANNER2007-12-19/23:52:53
1111,804,9801,073,18083,907,209762792841,827,8553,802,532SELECT FROM RFBLG ...UMG_SCANNER2007-12-14/03:34:21
2110,658,314507,53910,169,70248427241,488,0551,975,622SELECT FROM PBHI ...UMG_SCANNER2007-12-20/10:38:45
110,101,16010,101,1605,974,76059747602,000,0012,000,001SELECT FROM CKMI1 ... UMG_SCANNER 2007-12-15/11:01:07
Popular Blog Posts