MVSFORUMS.com

abc2000 · Beginner Joined: 22 Mar 2006 Posts: 18 Topics: 9

How to run SPUFI in batch setup

I have seen
"How to run SPUFI in batch"
http://groups.google.com/group/bit.listserv.db2-l/browse_thread/thread/5ea4629d20bee493/5b9806f06c07f6ae%235b9806f06c07f6ae

Who had did it?

Can you give some detail?

kolusu · Posted: Thu Apr 13, 2006 7:07 am Post subject:

abc2000,

I have done it and it is a pain to set it up. However I just don't see the need to run spufi in batch mode as you have the utilities like DSNTEP2 and DSNTIAUL

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

abc2000 · Beginner Joined: 22 Mar 2006 Posts: 18 Topics: 9

difference beetween DB2 SPUFI vs DSNTEP2

1. if error DB2 SPUFI can rollback, but DSNTEP2 can not rollback，this
would cause data integrity problem, it is very important

2. DSNTEP2 output line cannot exceed 133bytes，SPUFI can produce fromatted output, a line up to 32767bytes

kolusu · Posted: Fri Apr 14, 2006 7:40 am Post subject:

abc2000,

I know the differences between spufi and dsntep2, but the question why do you need to run spufi in batch? If rollback is the concern then why not write a program ?

You can use DSNTIAUL to produce a formatted output report.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

abc2000 · Beginner Joined: 22 Mar 2006 Posts: 18 Topics: 9

I always run a lot of SQL for long time, if I use spufi in online, in the long time,
I can not do anything

if I use dsntep2, when it errors, it can not roolback,
I must change the erros and discards all changes(very trouble) , then reruns a lot of SQL for long time