Db2 - L

 View Only

Latest Discussion Posts

  • LFAREA is either ALLOCATED to an address space/STC, or AVAILABLE for allocation in the IAR019I message you get from D VIRTSTOR,LFAREA If you add the two numbers, it should add up to "TOTAL LFAREA", which is the amount defined at IPL-time. ------------------------------ ...

  • Hi Mark, Thank you very much for all the information! One additional question, when displaying LFAREA we see LFAREA available LOWER than LFAREA allocated. should that be a concern? thanks Bill ------------------------------ williamgiannelliMe ------ ...

  • Profile Picture

    RE: Access issue

    Hi Your current SQLID must have the Privilege to issue the grant. So I think you have to execute a SET CURRENT SQLID TO something. ------------------------------ WalterJanißenRetired ------------------------------

  • Db2 is still using logical 4/8/16/32K pages for its bufferpools. The advantage to backing these with large real frames deals with virtual memory DAT. Every time Db2 references an area of storage, the virtual address it uses needs to be translated to a ...

  • we plan on implementing Large Page Frames for our local bufferpools. Might someone be able to suggest what data to monitor a before and after time frame to gage the benefits? thanks Bill ------------------------------ williamgiannelliMe ------------ ...

Latest Shared Files

Community Blogs

  • HURRY SIGN UP TIME IS HURRYING OUT John John Campbell IBM Distinguished Engineer and Db2 12 clients on this first of a kind live panel https://ibm.biz/Db212ClientPanel Sign up for this virtual Db2 12 client panel today ...