IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Reorg Utility with Discard option


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sree reddy

New User


Joined: 20 Jul 2007
Posts: 27
Location: bangalore

PostPosted: Tue Dec 01, 2009 9:50 am
Reply with quote

REORG TABLESPACE Database.tablespace

Code:
            CopyDDN(copylp)
           SHRlevel change
           statistics table(all)
                 index(all
                        keycard freqval numcols 1 count 30
                                    freqval numcols 2 count 30
                                    freqval numcols 3 count 30
                                    freqval numcols 4 count 30
                                    freqval numcols 5 count 30
                                                                            )
                               REPORT(NO) UPDATE(ALL)
                       MAPPINGTABLE database.table
                       MAXRO 30
                      DELAY 1200
                     LONGLOG CONTINUE
                     DRAIN_WAIT 30
                    TIMEOUT TERM
                    DEADLINE CURRENT TIMESTAMP + 45 minutes
                   DISCARD
                              from table database.table
                      when
                     (
                        X_VAL = 12345
                    and  abc_VAL not in
                    (
                           'AbcdEFG'
                         ,'SEDOL'
                         ,'CUSIP'
                         ,'primaryexchange'
                         ,'tickerK'
                     )
                     )

Code'd

I ran this utility and this did not work as expected, it deleted all the records satisfying X_val = 12345 and it ignored abc_VAL not in

Could any one suggest me the solution as early as possible

Thanks
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Dec 01, 2009 10:00 am
Reply with quote

Hello,

Why do you refuse to use the "Code" tag? It takes very little time to learn and there is the Preview so you can see your post as the forum will see it. When you have the "look" you want, Submit.

Future posts without the Code tag for code, jcl, data, screen info, etc will be deleted if i see them. . .

d
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Thu Dec 03, 2009 1:46 am
Reply with quote

Did you check the case of those characters you are passing and whats really in table? And when you run that JCL that they pass as caps off?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts REASON 00D70014 in load utility DB2 6
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
No new posts CICS vs LE: STORAGE option CICS 0
Search our Forums:

Back to Top