View previous topic :: View next topic
|
Author |
Message |
prabhucs01 Warnings : 1 New User
Joined: 07 Mar 2005 Posts: 43
|
|
|
|
in DB2 bind card what does these following parameters mean?
ACT(REP) RETAIN
ACQUIRE(USE)
RELEASE(COMMIT)
VALIDATE(BIND)
EXPLAIN(NO) |
|
Back to top |
|
|
i413678 Currently Banned Active User
Joined: 19 Feb 2005 Posts: 112 Location: chennai
|
|
|
|
hi,
ACT(REP) : Action is replace the existing one
ACQUIRE(USE) :locks on table and table space are imposed when it executed sql statement
RELEASE(COMMIT) :locks on table and table space are released on commit.
VALIDATE(BIND) : the authorization is validated at bind time.
EXPLAIN(NO) : no display of access path
cheers...........
pavan |
|
Back to top |
|
|
prabhucs01 Warnings : 1 New User
Joined: 07 Mar 2005 Posts: 43
|
|
|
|
ACT(REP) : Action is replace the existing one
pavan replace the existing once means what?
replace what? |
|
Back to top |
|
|
vinoddevkar
New User
Joined: 13 Apr 2005 Posts: 9 Location: pune
|
|
|
|
ACT(REP) : Action is replace the existing one
Replace the existing one means u have executed the program with abc.plan and u have done some modifications in the pgm and again if u submit it with the same plan name it will give error as it is already existing....Action(replace) will take care of the execution of the pgm without errors |
|
Back to top |
|
|
|