[Info-ingres] Table Version Value in Ingres 11 Database

Steve s.anderson.au at gmail.com
Fri Aug 30 09:26:43 UTC 2019


On Friday, 30 August 2019 16:34:03 UTC+10, Henrik Georg Sørensen (HGO)  wrote:
> Well I see the same in all my upgraded installations (10.2=>11.0=>11.1), so believe there's no change for the internal Ingres-format.
> 
> By the way If your Ingres System tables still on 2K-pages it's recommended/explicit needed to move them to higher like 8K-pages.
> (preferably before upgrading to Actian/X aka Ingres 11 - but possible after as well)
> 
> sysmod ${database} -page_size=8192
> 
> Best regards
> 
> Henrik Georg Sørensen
> 
> Internal - KMD A/S
> 
> -----Oprindelig meddelelse-----
> Fra: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> På vegne af Steve
> Sendt: 30. august 2019 08:15
> Til: info-ingres at lists.planetingres.org
> Emne: [Info-ingres] Table Version Value in Ingres 11 Database
> 
> Running "help table" for tables in my upgraded Ingres 11 database, indicates the table version is II10.0, is this as expected?
> 
> I see the same info in iitables.table_version.
> 
> Steve
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres
> Beskyttelse af dine personlige oplysninger er vigtig for os. Her finder du KMD’s Privatlivspolitik<http://www.kmd.dk/Privatlivspolitik>, der fortæller, hvordan vi behandler oplysninger om dig.
> 
> Protection of your personal data is important to us. Here you can read KMD’s Privacy Policy<http://www.kmd.net/Privacy-Policy> outlining how we process your personal data.
> 
> Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar for tab og skade, som er opstået i forbindelse med at modtage og bruge e-mailen.
> 
> Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachments are free from viruses and other errors that might affect the computer or it-system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.

Thanks Henrik. Interesting re page size of the system tables, I wonder if that is mentioned in the Ingres 11 Upgrade Guide?

Steve



More information about the Info-ingres mailing list