1219 - IBM i 系统管理基础（面向程序员）.pdf

1、Basics of System Admin for ProgrammersSession:1219Session:1219Pete MassielloPete MPetemPPetemP How did you get so lucky?Who was doing it?What happened?Is there any documentation?Will you continue or is this temporary?This is a 7x24 hour on-call?Hardware service?Security?PTFs?OS Upgrades?Backups/Rest

2、ores?Disaster Recovery and High Availability?Performance Problems?TumsDaily Care and Feeding:DSPMSG QSYSOPRDaily Care and Feeding:WRKACTJOBDaily Care and Feeding:WRKSYSSTSDaily Care and Feeding:WRKDSKSTSDaily Care and Feeding:WRKDSKSTSDaily Care and Feeding:WRKPRBDaily Care and Feeding:SNDSRVRQSDail

3、y Care and Feeding:SNDSRVRQSDaily Care and Feeding DSPMSG QSYSOPR WRKSYSACT WRKSYSSTS WRKDSKSTS WRKPRB Checking your backup job Did it end successfully?Is it still running?Whats changed that hasnt been backed up?Daily Care and Feeding Checking your backup job Did it end successfully?Is it still runn

4、ing?Whats changed that hasnt been backed up?Is the attention light on?Service Tools Do you have a valid user?Terms BRMS Backup Recovery Media Services Restricted State All Subsystems ended PTFs Program Temporary Fixes SST System Service Tools DST Dedicated Service Tools Differences between Function

5、21 or Manual IPL Load Source Disk with License Internal Code(LIC)ASP Auxiliary Storage Pools iASP Independent Auxiliary Storage Pools13Generate List of Files140SELECT SYSTEM_TABLE_SCHEMA,SYSTEM_TABLE_NAME,SYSTEM_TABLE_MEMBER,NUMBER_DELETED_ROWS,NUMBER_ROWS AS NUMBER_ACTIVE_ROWS,NUMBER_DELETED_ROWS+N

6、UMBER_ROWS AS TOTAL_ROWS,CASE NUMBER_ROWS WHEN 0 THEN 100.00ELSE(CAST(NUMBER_DELETED_ROWS AS DEC(10,0)/(CAST(NUMBER_DELETED_ROWS AS DEC(10,0)+CAST(NUMBER_ROWS AS DEC(10,0)*100END AS Percent_Deleted,DATA_SIZE/1000000 AS Data_Size_in_MB,(DATA_SIZE/1000000)*(CAST(NUMBER_DELETED_ROWS AS DEC(10,0)/(CAST(