View previous topic :: View next topic
|
Author |
Message |
ravindra.vadali
New User
Joined: 30 Jan 2012 Posts: 34 Location: USA
|
|
|
|
Hi
I have this BMC unload utility which needs to invoke parallelism, so I used the option CURRENTDEGREE(ANY) with DIRECT NO, but while the unload was executing I found that it automatically set the DEGREE to NONE, so I am not sure if I am using the correct option to invoke parallelism in BMC unload. If CURRENTDEGREE(ANY) is not for parallelism then what does it actually do?
I did google about this option but I didn't get any definition/explination specific to this option in BMC
It would be of a great help to me if anyone has an idea of what actually this CURRENTDEGREE option is or if it means the same as DEGREE(ANY) in a DB2 world
Below are the details of the information I am seein from BMC
Code: |
BMC50471I CURRENTDEGREE=NONE NULLTYPE=T1
BMC50102I UNLOAD
BMC50102I DIRECT NO
BMC50102I FORMAT CSV
BMC50102I TERMINATEDBY '~'
BMC50102I ENCLOSEDBY ''
BMC50102I NULLSTRING ''
BMC50102I TSFMT('YYYY-MM-DD-HH.MM.SS.NNNNNN')
BMC50102I TIMEFMT('HH.MM.SS')
BMC50102I CURRENTDEGREE(ANY)
BMC50102I |
Thanks,
Ravi |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I suggest BMC support would have the best answer. . . |
|
Back to top |
|
|
ravindra.vadali
New User
Joined: 30 Jan 2012 Posts: 34 Location: USA
|
|
|
|
Thanks D.Sch,
I had my DBAs have an explain on the job and it proved that BMC invoked parallelism while CURRENTDEGREE is set to ANY. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - good to hear it is resolved
d |
|
Back to top |
|
|
|