Hello
I have been going through the ARSRES table was surprised with the entries. Can someone please let me know what each of these scenarios mean? How is it possible to have an entry without an ADD_DATE? What does the ADD_DATE signify?
SCENARIO 1:
$ db2 "select * from root.arsres where root.arsres.ADD_DATE is null FETCH FIRST 2 ROWS ONLY"
RID AGID PRI_NID SEC_NID COMP_TYPE ADD_DATE COMP_SIZE DECOMP_SIZE EXP_DATE HOLD
----------- ----------- ------- ------- --------------------- -------------------- ----------- ----------- -------------------- ------
2 642 2 0 x'5A' - - - - -
3 642 6 0 x'5A' - - - - -
SCENARIO2:
$ db2 "select * from root.arsres where root.arsres.EXP_DATE is null FETCH FIRST 2 ROWS ONLY"
RID AGID PRI_NID SEC_NID COMP_TYPE ADD_DATE COMP_SIZE DECOMP_SIZE EXP_DATE HOLD
----------- ----------- ------- ------- --------------------- -------------------- ----------- ----------- -------------------- ------
2 642 2 0 x'5A' - - - - -
3 642 6 0 x'5A' - - - - -
SCENARIO:3
$ db2 "select * from root.arsres where root.arsres.EXP_DATE is null and root.arsres.ADD_DATE is not null FETCH FIRST 2 ROWS ONLY"
RID AGID PRI_NID SEC_NID COMP_TYPE ADD_DATE COMP_SIZE DECOMP_SIZE EXP_DATE HOLD
----------- ----------- ------- ------- --------------------- -------------------- ----------- ----------- -------------------- ------
38424 801 8 0 x'4F' 1033813294 - - - -
38425 801 8 0 x'4F' 1033813314 - - - -
Edit: Added fixed-width formatting for readability.