Author Topic: Understanding the ARSRES table  (Read 2337 times)

Trambak

  • Guest
Understanding the ARSRES table
« on: May 19, 2013, 08:14:24 PM »
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"

Code: [Select]
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"

Code: [Select]
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"

Code: [Select]
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.
« Last Edit: May 20, 2013, 05:38:11 AM by Justin Derrick »

Trambak

  • Guest
Re: Understanding the ARSRES table
« Reply #1 on: May 19, 2013, 08:40:56 PM »
Also I would like to understand how does CMOD calculate the EXP_DATE in the table and what does it correspond to? I have not able to find a suitable relation between the ADD_DATE and EXP_DATE.