7 Replies Latest reply on Jul 7, 2017 5:15 AM by Phil Grainger

    log master SQL output

    peter livingston

      Can the logmaster SQL output be longer than 80 bytes, when using migrate.  doc says one line per SQL makes it easier to export to other databases.

        • 1. Re: log master SQL output
          Jim Wilson

          Discussion successfully moved from  BMC Customer Support Community to Solutions for DB2

           

          Let us know if this is not the correct product

          • 2. Re: log master SQL output
            Phil Grainger

            Hi Peter

             

            Sorry for the delay in replying, but the answer is YES - you can allocate a VB format file to contain your SQL, ensuring that you have ONE SQL statement "per line" and don't need necessarily to worry about continuation or termination

             

            I hope that answers your question

             

            Phil Grainger

            product Manager

            • 3. Re: log master SQL output
              peter livingston

              so what would be the syntax, I am getting errors. here is what I am using.   One question, since the dataset gets dynamically allocated I assume it does not need to be preallocated.  I tried LRECL and RECFM=VB  neither seems to work.  the manual says use recfm=vb.

              SQL                                                       

                MIGRATE                                                  

                  DATASET &SYSUID..D&DATE..T&TIME..MIGRATE.SQL NEW       

                     CYLINDERS SPACE(1,1) UNIT(SYSDA) RECFM(VB) RELEASE  

                  TEMPLATE &SYSUID..D&DATE..T&TIME..MIGRATE.TEMPLATE NEW 

                     CYLINDERS SPACE(1,1) UNIT(SYSDA) RELEASE           

              1 of 1 people found this helpful
              • 4. Re: log master SQL output
                Phil Grainger

                Hi Peter

                 

                Sorry for the delay - July 4th got in the way!

                 

                Try this

                 

                SQL

                   MIGRATE

                      DATASET &SYSUID..D&DATE..T&TIME..SQL NEW        

                      CYLINDERS SPACE(1,1) UNIT(SYSDA) RELEASE           

                      LRECL(4000)

                      TEMPLATE &SYSUID..D&DATE..T&TIME..TEMPLATE NEW  

                      TRACKS SPACE(1,1) UNIT(SYSDA) RELEASE           

                      RECFM VB                                        

                • 5. Re: log master SQL output
                  peter livingston

                  yes that worked thank-you.  dumb me I specified recfm=vb , took a while to find that.

                  Also  of note if you don't specify lrecl in the dataset parameters, you end up with a dataset file with 27998 bytes in length per record. So if you know approx. how big your records will be, you can specify the lrecl to reduce the wasted space.   However check that no records go to the end of the lrecl before assuming all ok. v

                  • 6. Re: log master SQL output
                    peter livingston

                    sorry that is 27994 bytes not 27998 for lrecl ,  blksize is 27998

                    • 7. Re: log master SQL output
                      Phil Grainger

                      Glad it worked out in the end