Hi again, list.
This is my problem-program:
/**/
"db2 get monitor switches"
"db2 update monitor switches using bufferpool on"
"db2 get monitor switches"
"db2 get monitor switches > ./koko"
"db2 get monitor switches"
The Default values for monitor switches are:
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
Then I change them and I visualize:
Buffer Pool Activity Information (BUFFERPOOL) = ON
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
Then I record this very information into ./koko file but my surprise is so great to see it records:
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
and if I display it again I see it correct:
Buffer Pool Activity Information (BUFFERPOOL) = ON
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
In summary: it behaves as if "whenever my program has to display the get monitor switches command, it does it fine. BUT whenever it has to write the get monitor command it always writes it wrong".
Why ????
Jose R. Baron
CALCULO S.A.
Madrid, Spain
This is my problem-program:
/**/
"db2 get monitor switches"
"db2 update monitor switches using bufferpool on"
"db2 get monitor switches"
"db2 get monitor switches > ./koko"
"db2 get monitor switches"
The Default values for monitor switches are:
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
Then I change them and I visualize:
Buffer Pool Activity Information (BUFFERPOOL) = ON
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
Then I record this very information into ./koko file but my surprise is so great to see it records:
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
and if I display it again I see it correct:
Buffer Pool Activity Information (BUFFERPOOL) = ON
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
In summary: it behaves as if "whenever my program has to display the get monitor switches command, it does it fine. BUT whenever it has to write the get monitor command it always writes it wrong".
Why ????
Jose R. Baron
CALCULO S.A.
Madrid, Spain