Db2 Dba

[rashmibiliya]

Hi,

I have few questions can you please guide me:

1) In DB2 V 8.1 - is caching is available? If yes then how can it be achieved.
2) if we run the stored procedure then it will run in the SPAS addressspace which is now called as WLM address space,
can we do anything so that it can run in DB2 addressspace only, if we can do like this then is there any performance
issue in that.
3) What is the performance issue if we use three addressspace ie stored procedure addressspace,DB 2 addressspace,
and application addressspace.

Please help me.

[spider007]

1. We relate caching to bufferpool. The data is "cached" in a bufferpool, the memory for which is taken from real memory
2. You need to specify the stored procedure as non-fenced. In non-fenced mode, the stored procedures are run in the db2 addresspace, however this is not advisable as if there is any problem with SP, it may result into crashing of the instance.

[rashmibiliya]

1. We relate caching to bufferpool. The data is "cached" in a bufferpool, the memory for which is taken from real memory
2. You need to specify the stored procedure as non-fenced. In non-fenced mode, the stored procedures are run in the db2 addresspace, however this is not advisable as if there is any problem with SP, it may result into crashing of the instance.

I am talking about mainframes(Z/OS) db2, i dont think that non fenced mode is there in z/os.
how caching can be achieved in z/os db2 ie how it can be used in application program.
what is the performance issuse if we use more addressspaces(d b2,spas), or can we make the stored procedure to run in the db2 addressspace only instead of running in spas.

[docdiesel]

how caching can be achieved in z/os db2 ie how it can be used in application program. what is the performance issuse if we use more addressspaces(d b2,spas), or can we make the stored procedure to run in the db2 addressspace only instead of running in spas.

Hi,

you already said that in your first post, even in more readable form. There's no need to double post. Please follow the posting guidelines. Thank you.

Regards

Doc Diesel (moderator)