TACL 1 > ASAPDBA
------
ASAPDBA --> ASAP DB Analysis & Aggregation utility - T0402v3.3 - (30MAY2012)
------
ASAP DBA administers, analyzes, aggregates, sorts, merges, & loads long-term
history from one/many ZMMDD* files into a single compacted DB history file.
For more about ASAP ZMMDD files, enter HELP SET DBMaxDays from the ASAP CI.
ASAP DBA provides significant data reduction of ASAP long-term DB stats using
record-compression, hourly-aggregation, and time-of-day filtering. As a result
instead of 1440 records/object/day, only 24 records/object/day or even less
are saved in the DB resulting in 200x-5000x improvement in performance.
ASAP DBA sorts & merges multi-day DB files into a single historical DB file
suitable for long-term analysis. DBA can combine many days of DB files into
one long-term DB file allowing long-term analysis. DBA History is saved in
the ASAPDB subvol with an "H" suffix. For example, a Cpu or Disk "H"istory
file is saved as DBCpuH and DBDskH, along-side your DBCpu and DBDsk files.
ASAP DBA: Prompts you for Entity, Date, Time, Days, Hours, and Node options..
------
Analyzing environment at 12/05/31 13:56:48 ...
Enter ENTITY NAME to administer: CPU | DSK : DSK
ASAP DBA can aggregate DB history to a NEW file, or ADD to an existing file.
NEW - if you want to create an entirely new file $ASAP.ASAPDB.DBDSKH
then enter NEW. The NEW option uses a FUP LOAD operation to create a new
DB file and as a result is much faster than an ADD operation.
ADD - if you want to add history to an existing file $ASAP.ASAPDB.DBDSKH
then enter ADD. The ADD option uses FUP COPY to add to a file and as a
result is slower than a NEW operation. For this reason it is recommended
you only add 1 day of statistics for an ADD operation.
Enter DB create/update option NEW | ADD : NEW
ASAP DBA can analyze and aggregate multiple-days of database statistics,
or it can focus on a single day to perform hourly aggregation. To do
either, please specify the oldest starting date you want to aggregate.
Enter start MONTH to analyze from 1 - 12 : 5
Enter start DAY of the month from 1 - 31 : 1
Enter total #DAYS to analyze from 1 - 365: 30
ASAP DBA can analyze and aggregate either a whole day of statistics, eg
from 00:00 for 24 hours, or it can focus on a particular time range you
specify, eg 11:00 for 3 hours. Please specify the starting hour of the
day you want to analyze and the number of hours you want to aggregate.
Enter start Hour of each day from 00- 23 : 15
Enter total Hours to analyze from 1 - 24 : 1
ASAP DBA can select all nodes, or one particular node for analysis and
aggregation. Specify either \* or a particular \sysname below.
Enter node as \* for all, or \NAME for 1 :
Enter node as \* for all, or \NAME for 1 : \*
ASAP DBA will analyze & aggregate ZMMDD files in subvol $ASAP.ASAP2012
If you want ASAP DBA to use another subvolume for ZMMDD files,
then input the subvol name below, otherwise press the ENTER key.
Enter HISTORY subvol as $VOLUME.ASAPYYYY :
Enter HISTORY subvol as $VOLUME.ASAPYYYY : $ASAP.ASAP2012
ASAP DBA will use DICT files and save/update files in subvol $ASAP.ASAPDB
If you want ASAP DBA to use another subvolume for DICT and output
files, then input the subvol name below, otherwise press the ENTER key.
Enter ASAPDB subvol as $VOLUME.SUBVOLUME :
Enter ASAPDB subvol as $VOLUME.SUBVOLUME : $ASAP.ASAPDB
12/05/31 13:57:23
Analyze DSK in $ASAP.ASAP2012.* from 5/1 for 30 days. Time 15:00 for 1 hrs
NEW - Create file $ASAP.ASAPDB.DBDSKH using FUP Load.
History=$ASAP.ASAP2012 Dict=$ASAP.ASAPDB Cpus=22 Disks=168 Avail/Need=93/2
$ASAP.ASAP2012.QUERYENF save started.
$ASAP.ASAP2012.QUERYENF saved.
Analyze $ASAP.ASAP2012.Z0501DSK 13:57:24
Records received = 168
Analyze $ASAP.ASAP2012.Z0502DSK 14:00:47
Records received = 168
Analyze $ASAP.ASAP2012.Z0503DSK 14:03:52
Records received = 168
Analyze $ASAP.ASAP2012.Z0504DSK 14:07:14
Records received = 168
Analyze $ASAP.ASAP2012.Z0505DSK 14:10:34
Records received = 168
Analyze $ASAP.ASAP2012.Z0506DSK 14:13:39
Records received = 168
Analyze $ASAP.ASAP2012.Z0507DSK 14:16:59
Records received = 168
Analyze $ASAP.ASAP2012.Z0508DSK 14:20:23
Records received = 168
Analyze $ASAP.ASAP2012.Z0509DSK 14:23:40
Records received = 168
Analyze $ASAP.ASAP2012.Z0510DSK 14:27:09
Records received = 168
Analyze $ASAP.ASAP2012.Z0511DSK 14:30:34
Records received = 168
Analyze $ASAP.ASAP2012.Z0512DSK 14:33:42
Records received = 168
Analyze $ASAP.ASAP2012.Z0513DSK 14:37:08
Records received = 168
Analyze $ASAP.ASAP2012.Z0514DSK 14:40:34
Records received = 168
Analyze $ASAP.ASAP2012.Z0515DSK 14:43:50
Records received = 168
Analyze $ASAP.ASAP2012.Z0516DSK 14:47:15
Records received = 168
Analyze $ASAP.ASAP2012.Z0517DSK 14:50:36
Records received = 168
Analyze $ASAP.ASAP2012.Z0518DSK 14:53:58
Records received = 168
Analyze $ASAP.ASAP2012.Z0519DSK 14:57:36
Records received = 168
Analyze $ASAP.ASAP2012.Z0520DSK 15:01:03
Records received = 168
Analyze $ASAP.ASAP2012.Z0521DSK 15:04:13
Records received = 168
Analyze $ASAP.ASAP2012.Z0522DSK 15:07:36
Records received = 168
Analyze $ASAP.ASAP2012.Z0523DSK 15:11:00
Records received = 168
Analyze $ASAP.ASAP2012.Z0524DSK 15:14:11
Records received = 168
Analyze $ASAP.ASAP2012.Z0525DSK 15:17:36
Records received = 168
Analyze $ASAP.ASAP2012.Z0526DSK 15:21:03
Records received = 168
Analyze $ASAP.ASAP2012.Z0527DSK 15:24:10
Records received = 168
Analyze $ASAP.ASAP2012.Z0528DSK 15:27:36
Records received = 168
Analyze $ASAP.ASAP2012.Z0529DSK 15:31:00
Records received = 168
Analyze $ASAP.ASAP2012.Z0530DSK 15:34:12
Records received = 168
ASAPDBA ->FUP LOAD Object Load
\sysname Cpu/$Vol Cache Tid Time
------
\BLPROD AUDIT 145 15:37:38
\BLPROD DSMSCM 146 15:37:38
\BLPROD DUMP 147 15:37:38
\BLPROD DUMP1 148 15:37:38
\BLPROD FSDEVL 149 15:37:38
\BLPROD FSTECH 150 15:37:38
\BLPROD GUEST 151 15:37:38
\BLPROD IPCLIM 152 15:37:38
\BLPROD MCDEV 153 15:37:38
\BLPROD NSKDV 154 15:37:38
\BLPROD NSKMAC 155 15:37:38
\BLPROD NSKOS 156 15:37:38
\BLPROD NSKOS2 157 15:37:38
\BLPROD NSKOS3 158 15:37:38
\BLPROD NSKOS4 159 15:37:38
\BLPROD NSKSPR 160 15:37:38
\BLPROD NSKTK 161 15:37:38
\BLPROD NSKVC 162 15:37:38
\BLPROD OPER 163 15:37:38
\BLPROD OSBGEN 164 15:37:38
\BLPROD OSS000 165 15:37:38
\BLPROD P1D01 166 15:37:38
\BLPROD P1D02 167 15:37:38
\BLPROD P1D03 168 15:37:38
\BLPROD P2D01 169 15:37:38
\BLPROD P3D01 170 15:37:38
\BLPROD P3D02 171 15:37:38
\BLPROD QAOSS 172 15:37:38
\BLPROD QAREPO 173 15:37:38
\BLPROD QASORC 174 15:37:38
\BLPROD ROOT 175 15:37:38
\BLPROD SWAP1 176 15:37:38
\BLPROD SWAP2 177 15:37:38
\BLPROD SYSTEM 178 15:37:38
\BLPROD TMFDMP 179 15:37:38
\NSPROD ASAP 89 15:37:38
\NSPROD AUDIT 90 15:37:38
\NSPROD BIT 91 15:37:38
\NSPROD COMP 92 15:37:38
\NSPROD DATA07 93 15:37:38
\NSPROD DENAL1 94 15:37:38
\NSPROD DENARC 95 15:37:38
\NSPROD DP4 96 15:37:38
\NSPROD DSMSCM 97 15:37:38
\NSPROD DSMTC 98 15:37:38
\NSPROD DUMP1 99 15:37:38
\NSPROD DUMP2 100 15:37:38
\NSPROD ESD001 101 15:37:38
\NSPROD ESD002 102 15:37:38
\NSPROD ESD003 103 15:37:38
\NSPROD ESD004 104 15:37:38
\NSPROD FC52 105 15:37:38
\NSPROD FC6 106 15:37:38
\NSPROD GUEST 107 15:37:38
\NSPROD GUEST1 108 15:37:38
\NSPROD JUPTR 109 15:37:38
\NSPROD LANA 110 15:37:38
\NSPROD OPER 111 15:37:38
\NSPROD OSS 112 15:37:38
\NSPROD OSS1 113 15:37:38
\NSPROD P1D01 114 15:37:38
\NSPROD P1D02 115 15:37:38
\NSPROD P1D03 116 15:37:38
\NSPROD P1D04 117 15:37:38
\NSPROD P2D01 118 15:37:38
\NSPROD P2D02 119 15:37:38
\NSPROD P2D03 120 15:37:38
\NSPROD P2D04 121 15:37:38
\NSPROD P3D01 122 15:37:38
\NSPROD P3D02 123 15:37:38
\NSPROD P3D03 124 15:37:38
\NSPROD P4D01 125 15:37:38
\NSPROD P4D02 126 15:37:39
\NSPROD P4D03 127 15:37:39
\NSPROD P5D01 128 15:37:39
\NSPROD P5D02 129 15:37:39
\NSPROD P5D03 130 15:37:39
\NSPROD P6D01 131 15:37:39
\NSPROD P6D02 132 15:37:39
\NSPROD P6D03 133 15:37:39
\NSPROD P6D04 134 15:37:39
\NSPROD P7D01 135 15:37:39
\NSPROD ROOT 136 15:37:39
\NSPROD SCM 137 15:37:39
\NSPROD SPRS 138 15:37:39
\NSPROD SQLTST 139 15:37:39
\NSPROD SQMX1 140 15:37:39
\NSPROD SYSTEM 141 15:37:39
\NSPROD TMFDMP 142 15:37:39
\NSPROD VADT1 143 15:37:39
\NSPROD VCS 144 15:37:39
\SIERRA APPLE 12 15:37:39
\SIERRA APTOS 13 15:37:39
\SIERRA ARCH 14 15:37:39
\SIERRA AUDIT 15 15:37:39
\SIERRA AUDIT1 16 15:37:39
\SIERRA BANANA 17 15:37:39
\SIERRA BEACH 18 15:37:39
\SIERRA BERRY 19 15:37:39
\SIERRA BFDEV1 20 15:37:39
\SIERRA BFS 21 15:37:39
\SIERRA BFS001 22 15:37:39
\SIERRA BFS002 23 15:37:39
\SIERRA BLAST 24 15:37:39
\SIERRA DCE 25 15:37:39
\SIERRA DEV 26 15:37:39
\SIERRA DEV2 27 15:37:39
\SIERRA DEV3 28 15:37:39
\SIERRA DEV4 29 15:37:39
\SIERRA DSMSCM 30 15:37:39
\SIERRA DSMTC 31 15:37:39
\SIERRA ESD001 32 15:37:39
\SIERRA ESD002 33 15:37:39
\SIERRA ESD003 34 15:37:39
\SIERRA FGWY 35 15:37:39
\SIERRA FIG 36 15:37:39
\SIERRA FSDEV2 37 15:37:39
\SIERRA FSDEVL 38 15:37:39
\SIERRA GEN 39 15:37:39
\SIERRA GRAPE 40 15:37:39
\SIERRA GUEST 41 15:37:39
\SIERRA HIT 42 15:37:39
\SIERRA IDEL 43 15:37:39
\SIERRA IODUMP 44 15:37:39
\SIERRA IOQA1 45 15:37:39
\SIERRA IPM 46 15:37:39
\SIERRA IPM2 47 15:37:39
\SIERRA KAWEAH 48 15:37:39
\SIERRA KIWI 49 15:37:39
\SIERRA KQA5 50 15:37:39
\SIERRA KQAOSS0 51 15:37:39
\SIERRA LEMON 52 15:37:39
\SIERRA MILLI2 53 15:37:39
\SIERRA NEVAD2 54 15:37:39
\SIERRA NSDOM 55 15:37:39
\SIERRA NSKOFF 56 15:37:39
\SIERRA OPER 57 15:37:39
\SIERRA OPSPAX 58 15:37:39
\SIERRA ORANGE 59 15:37:39
\SIERRA OS 60 15:37:39
\SIERRA OS1 61 15:37:39
\SIERRA OS2 62 15:37:39
\SIERRA OSDMP3 63 15:37:39
\SIERRA OSDMP4 64 15:37:39
\SIERRA OSDUMP 65 15:37:39
\SIERRA OSS000 66 15:37:39
\SIERRA OSS001 67 15:37:39
\SIERRA OSS002 68 15:37:39
\SIERRA PEACH 69 15:37:39
\SIERRA PROCQA 70 15:37:39
\SIERRA QUINCE 71 15:37:39
\SIERRA ROOT 72 15:37:39
\SIERRA RTOOL1 73 15:37:39
\SIERRA SBQA1 74 15:37:39
\SIERRA SPOOL 75 15:37:39
\SIERRA SQMX 76 15:37:39
\SIERRA SWAP1 77 15:37:39
\SIERRA SYSTEM 78 15:37:39
\SIERRA TECH 79 15:37:39
\SIERRA TECH2 80 15:37:39
\SIERRA TMFDMP 81 15:37:39
\SIERRA VADT1 82 15:37:39
\SIERRA VFS 83 15:37:39
\SIERRA VFS1 84 15:37:39
\SIERRA VNSK 85 15:37:39
\SIERRA VPERF00 86 15:37:39
\SIERRA YOSE 87 15:37:39
\SIERRA YOSE1 88 15:37:39
Records Loaded = 5040
ASAPDBA --> ASAP DB Analysis & Aggregation utility - T0402v3.3 - (30MAY2012)
Taskid Cpu,Pin Name CachePg Timeout Seeview - T6965H01 - (01MAY06)
------
PRODUCTINFO menudata 1/1 60,15 $SXX.ASAPHIST.ASAPDBEE
PROMPTS menudata 2/16 60,15 $SXX.ASAPHIST.ASAPDBEE
CPUQUERY menudata 2/4 60,15 $SXX.ASAPHIST.ASAPDBEE
DDLDB menudata 2/3 60,15 $SXX.ASAPHIST.ASAPDBEE
DSKQUERY menudata 2/4 60,15 $SXX.ASAPHIST.ASAPDBEE
QUERYENF menudata 2/4 60,15 $SXX.ASAPHIST.ASAPDBEE
DBCREATECMD menudata 0/1 60,15 $SXX.ASAPHIST.ASAPDBEE
OBJINX menudata 6/99 60,15 $SXX.ASAPHIST.ASAPDBEE
FUP T 7,44 $X69A 5/5 60,15 $SYSTEM.SYSTEM.FUP
ASAP ~ 7,7 $X69B 5/5 60,15 $SYSTEM.SYSTEM.ASAP
ENFORM stopped 0/5 900,900 $SYSTEM.SYSTEM.ENFORM
DDL stopped 3/5 60,15 $SYSTEM.SYSTEM.DDL
SIERRAZZAPP stopped 1/93 60,15 $Z0000
SIERRAZZAPT stopped 1/93 60,15 $Z0001
SIERRAZZARC stopped 1/93 60,15 $Z0002
SIERRAZZAUD stopped 1/93 60,15 $Z0003
SIERRAZZAUD stopped 1/93 60,15 $Z0004
SIERRAZZBAN stopped 1/93 60,15 $Z0005
SIERRAZZBEA stopped 1/93 60,15 $Z0006
SIERRAZZBER stopped 1/93 60,15 $Z0007
SIERRAZZBFD stopped 1/93 60,15 $Z0008
SIERRAZZBFS stopped 1/93 60,15 $Z0009
SIERRAZZBFS stopped 1/93 60,15 $Z000A
SIERRAZZBFS stopped 1/93 60,15 $Z000B
SIERRAZZBLA stopped 1/93 60,15 $Z000C
SIERRAZZDCE stopped 1/93 60,15 $Z000D
SIERRAZZDEV stopped 1/93 60,15 $Z000E
SIERRAZZDEV stopped 1/93 60,15 $Z000F
SIERRAZZDEV stopped 1/93 60,15 $Z0010
SIERRAZZDEV stopped 1/93 60,15 $Z0011
SIERRAZZDSM stopped 1/93 60,15 $Z0012
SIERRAZZDSM stopped 1/93 60,15 $Z0013
SIERRAZZESD stopped 1/93 60,15 $Z0014
SIERRAZZESD stopped 1/93 60,15 $Z0015
SIERRAZZESD stopped 1/93 60,15 $Z0016
SIERRAZZFGW stopped 1/93 60,15 $Z0017
SIERRAZZFIG stopped 1/93 60,15 $Z0018
SIERRAZZFSD stopped 1/93 60,15 $Z0019
SIERRAZZFSD stopped 1/93 60,15 $Z001A
SIERRAZZGEN stopped 1/93 60,15 $Z001B
SIERRAZZGRA stopped 1/93 60,15 $Z001C
SIERRAZZGUE stopped 1/93 60,15 $Z001D
SIERRAZZHIT stopped 1/93 60,15 $Z001E
SIERRAZZIDE stopped 1/93 60,15 $Z001F
SIERRAZZIOD stopped 1/93 60,15 $Z0020
SIERRAZZIOQ stopped 1/93 60,15 $Z0021
SIERRAZZIPM stopped 1/93 60,15 $Z0022
SIERRAZZIPM stopped 1/93 60,15 $Z0023
SIERRAZZKAW stopped 1/93 60,15 $Z0024
SIERRAZZKIW stopped 1/93 60,15 $Z0025
SIERRAZZKQA stopped 1/93 60,15 $Z0026
SIERRAZZKQA stopped 1/93 60,15 $Z0027
SIERRAZZLEM stopped 1/93 60,15 $Z0028
SIERRAZZMIL stopped 1/93 60,15 $Z0029
SIERRAZZNEV stopped 1/93 60,15 $Z002A
SIERRAZZNSD stopped 1/93 60,15 $Z002B
SIERRAZZNSK stopped 1/93 60,15 $Z002C
SIERRAZZOPE stopped 1/93 60,15 $Z002D
SIERRAZZOPS stopped 1/93 60,15 $Z002E
SIERRAZZORA stopped 1/93 60,15 $Z002F
SIERRAZZOS stopped 1/93 60,15 $Z0030
SIERRAZZOS1 stopped 1/93 60,15 $Z0031
SIERRAZZOS2 stopped 1/93 60,15 $Z0032
SIERRAZZOSD stopped 1/93 60,15 $Z0033
SIERRAZZOSD stopped 1/93 60,15 $Z0034
SIERRAZZOSD stopped 1/93 60,15 $Z0035
SIERRAZZOSS stopped 1/93 60,15 $Z0036
SIERRAZZOSS stopped 1/93 60,15 $Z0037
SIERRAZZOSS stopped 1/93 60,15 $Z0038
SIERRAZZPEA stopped 1/93 60,15 $Z0039
SIERRAZZPRO stopped 1/93 60,15 $Z003A
SIERRAZZQUI stopped 1/93 60,15 $Z003B
SIERRAZZROO stopped 1/93 60,15 $Z003C
SIERRAZZRTO stopped 1/93 60,15 $Z003D
SIERRAZZSBQ stopped 1/93 60,15 $Z003E
SIERRAZZSPO stopped 1/93 60,15 $Z003F
SIERRAZZSQM stopped 1/93 60,15 $Z0040
SIERRAZZSWA stopped 1/93 60,15 $Z0041
SIERRAZZSYS stopped 1/93 60,15 $Z0042
SIERRAZZTEC stopped 1/93 60,15 $Z0043
SIERRAZZTEC stopped 1/93 60,15 $Z0044
SIERRAZZTMF stopped 1/93 60,15 $Z0045
SIERRAZZVAD stopped 1/93 60,15 $Z0046
SIERRAZZVFS stopped 1/93 60,15 $Z0047
SIERRAZZVFS stopped 1/93 60,15 $Z0048
SIERRAZZVNS stopped 1/93 60,15 $Z0049
SIERRAZZVPE stopped 1/93 60,15 $Z004A
SIERRAZZYOS stopped 1/93 60,15 $Z004B
SIERRAZZYOS stopped 1/93 60,15 $Z004C
NSPRODZZASA stopped 1/93 60,15 $Z004D
NSPRODZZAUD stopped 1/93 60,15 $Z004E
NSPRODZZBIT stopped 1/93 60,15 $Z004F
NSPRODZZCOM stopped 1/93 60,15 $Z0050
NSPRODZZDAT stopped 1/93 60,15 $Z0051
NSPRODZZDEN stopped 1/93 60,15 $Z0052
NSPRODZZDEN stopped 1/93 60,15 $Z0053
NSPRODZZDP4 stopped 1/93 60,15 $Z0054
NSPRODZZDSM stopped 1/93 60,15 $Z0055
NSPRODZZDSM stopped 1/93 60,15 $Z0056
NSPRODZZDUM stopped 1/93 60,15 $Z0057
NSPRODZZDUM stopped 1/93 60,15 $Z0058
NSPRODZZESD stopped 1/93 60,15 $Z0059
NSPRODZZESD stopped 1/93 60,15 $Z005A
NSPRODZZESD stopped 1/93 60,15 $Z005B
NSPRODZZESD stopped 1/93 60,15 $Z005C
NSPRODZZFC5 stopped 1/93 60,15 $Z005D
NSPRODZZFC6 stopped 1/93 60,15 $Z005E
NSPRODZZGUE stopped 1/93 60,15 $Z005F
NSPRODZZGUE stopped 1/93 60,15 $Z0060
NSPRODZZJUP stopped 1/93 60,15 $Z0061
NSPRODZZLAN stopped 1/93 60,15 $Z0062
NSPRODZZOPE stopped 1/93 60,15 $Z0063
NSPRODZZOSS stopped 1/93 60,15 $Z0064
NSPRODZZOSS stopped 1/93 60,15 $Z0065
NSPRODZZP1D stopped 1/93 60,15 $Z0066
NSPRODZZP1D stopped 1/93 60,15 $Z0067
NSPRODZZP1D stopped 1/93 60,15 $Z0068
NSPRODZZP1D stopped 1/93 60,15 $Z0069
NSPRODZZP2D stopped 1/93 60,15 $Z006A
NSPRODZZP2D stopped 1/93 60,15 $Z006B