Does the colum physaddr exist anymore?

Hi Guys, just wondering if the column physaddr of sysptntbls in sysmaster has been dropped. I receivedd some errors, problably related to this missing column in a brand new 9.40.TC2E1. Any clue about? Let me know. Thanks Cheers MArcelo

> Hi Guys, > just wondering if the column physaddr of sysptntbls in sysmaster has > been dropped. I receivedd some errors, problably related to this missing > column in a brand new 9.40.TC2E1. > Any clue about? In order to support > 2GB limit of chunks, Informix has made changes to some tables in sysmaster. The error message you are seeing is a result of that. Ravi

One specific change that was made was the structure of physaddr. It's now 6 bytes, versus 4 bytes in pre-9.4. We stole 2 bytes from the page header timestamp and used it in the new physaddr (it's now 0xPPPPPPPPCCCC), and what was left is now a 2-byte checksum. This was for >2G file/chunk support. Don't know if this is why you're getting the errors, but it certainly could be. Mark. Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Office: 303-773-5067 Cell: 303-929-0914 email: mscranto@us.ibm.com "Ravi Krishna" <rkrishna@farelog To: ids@iiug.org ix.com> cc: Sent by: Subject: Re: Does the colum physaddr exist anymore? [2052] forum.subscriber@ iiug.org 10/21/2003 02:52 AM > Hi Guys, > just wondering if the column physaddr of sysptntbls in sysmaster has > been dropped. I receivedd some errors, problably related to this missing > column in a brand new 9.40.TC2E1. > Any clue about? In order to support > 2GB limit of chunks, Informix has made changes to some tables in sysmaster. The error message you are seeing is a result of that. Ravi