CFRM Policy updates



IBM's flagship relational database management system

CFRM Policy updates

Postby v1gnesh » Fri Feb 10, 2012 11:43 pm

Hi,

First things first. Please move this to the appropriate sub-forum if this doesn't belong here.
Is it possible to update a single structure size( GBP, LOCK, or SCA ) alone? I'm aware that this can be done dynamically using SETXCF ALTER commands. How I do the update is..
  • Get a report using DATA TYPE(CFRM) REPORT(YES) to a dataset
  • Update the necessary values in the dataset; keep the information about other unchanged structures too; change policy name
  • Write policy to CFRM
  • Activate policy

In other words, is it possible to write a policy to CFRM, which contains only the changed structure sizes in the input dataset?

Thanks!
boyo
v1gnesh
 
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: CFRM Policy updates

Postby Peter_Mann » Sat Feb 11, 2012 2:54 am

v1gnesh wrote:Hi,

First things first. Please move this to the appropriate sub-forum if this doesn't belong here.
Is it possible to update a single structure size( GBP, LOCK, or SCA ) alone? I'm aware that this can be done dynamically using SETXCF ALTER commands. How I do the update is..
  • Get a report using DATA TYPE(CFRM) REPORT(YES) to a dataset
  • Update the necessary values in the dataset; keep the information about other unchanged structures too; change policy name
  • Write policy to CFRM
  • Activate policy

In other words, is it possible to write a policy to CFRM, which contains only the changed structure sizes in the input dataset?

Thanks!

The only safe way is to create a new policy from the old policy alteing only the items you need to alter, and start the new policy, I think there are tools that allow altering structures on the fly, I've never felt safe using these tools to alter any XCF policy or structure, I've always used tools like SYSVIEW to VIEW XCF data.
only my 2 cents
Peter
Peter_Mann
 
Posts: 145
Joined: Fri Jun 24, 2011 7:37 pm
Location: Lowell,AR
Has thanked: 15 times
Been thanked: 3 times

Re: CFRM Policy updates

Postby v1gnesh » Sat Feb 11, 2012 3:24 pm

thanks! anyone else willing to share their 2 cents :P ?
boyo
v1gnesh
 
Posts: 72
Joined: Wed Sep 28, 2011 8:24 pm
Has thanked: 1 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post