I am looking to find the size of data at source and not sure how to do it. One way I could think of is by looking at the 'Archive Process Report. Below is a report generated when archive job is run successfully
Request Name CLAIM
Server Name SERVERNAME
Archive File \\server\ARCHIVE\FILE_NAME.AF
Access Definition DB.CLAIM_AD
Storage profile (None)
File Access Definition (None)
File Attachments Processed
Client User ID XXXX
Server User ID YYYY
Time Started 4/21/2020 12:41:53
Time Finished 4/13/2020 12:55:21
Elapsed Time 00:13:28
Archive File Data Byte Count 205479580 Bytes (0.191 GB)
Process Status no errors, no warnings
Backup Created for Archive File No
Process Summary
Tables Processed 8
Rows Archived 2260822
Rows with Errors 0
First Pass Table Rows 46878
Row Details:
Table Name Archived Failed Data Byte Count
TABLE 1 46878 0 26659533
TABLE 2 469286 0 148527555
TABLE 3 277335 0 5545665
TABLE 4 1108620 0 16629300
TABLE 5 168879 0 3715338
TABLE 6 46593 0 1537569
TABLE 7 47602 0 952040
TABLE 8 95629 0 1912580
------------------------------
205479580 --> Total Data Byte Count
Q1) Can I simply take this total Data Byte Count and divide it by 1024 to get the MB and further divide it by 1024 to get the size in GB?
i.e. 205479580 / 1024 = 200663.65 MB
200663.65 / 1024 = 195.96 GB?
Is this the right way to calculate the size at source?
Q2) I noticed that the initial section of the archive report mentions the Archive File Data Byte Count (mentioned in initial section of this post. Also see below).
Archive File Data Byte Count 205479580 Bytes (0.191 GB)What is this size in GB, is this after the data is archived? and how is it calculated?
Appreciate any inputs on how I can calculate the size at source?
------------------------------
Optim Learner
------------------------------
#InfoSphereOptim#Optim