Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Reorg Utility with Discard option

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Reorg Utility with Discard option
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

Site Director


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

PostPosted: Tue Dec 01, 2009 10:00 am    Post subject: Reply to: Reorg Utility with Discard option
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    Post subject: Reply to: Reorg Utility with Discard option
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us