List of Contributions

Roy Boxwell

Software Engineering GmbH

Contact Details

Software Engineering GmbH

My Content

1 to 20 of 36 total

RE: New webinar all about Zowe and Certificates

Posted By Roy Boxwell Fri April 19, 2024 03:59 AM
Found In Egroup: IBM Z and LinuxONE IBM Z \ view thread
Hi! On our web site scroll down and click on Events - The Click on Webinars and scroll down to "register" link. Just in case here is a link as well: When You Think Db2 Webinar Series - ZOWE registration - Software Engineering GmbH WebEx Meeting Center Cheers! ------------------------------ ...

New webinar all about Zowe and Certificates

Posted By Roy Boxwell Fri April 12, 2024 04:14 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Hi! I am happy to be able to announce the second of our free webinar series on Tuesday the 23rd April with Zowe guru Joe Winchester kicking it off with "Wowee it's Zowe – the new face of mainframe computing" and then my esteemed colleague Ulf Heinrich will take away all the worries and pain of certificates ...

New webinar all about Zowe and Certificates

Posted By Roy Boxwell Fri April 12, 2024 04:13 AM
Found In Egroup: IBM Z and LinuxONE IBM Z \ view thread
Hi! I am happy to be able to announce the second of our free webinar series on Tuesday the 23rd April with Zowe guru Joe Winchester kicking it off with "Wowee it's Zowe – the new face of mainframe computing" and then my esteemed colleague Ulf Heinrich will take away all the worries and pain of certificates ...

RE: JDBC - DB2 z/OS

Posted By Roy Boxwell Mon March 18, 2024 03:31 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Hi! Sadly Data Studio is deprecated and about to completely killed off! i would not start using it now at all.. Better is to downlaod and install the Visual Studio Code and the install the IBM Db2 for z/OS Developer Extension. Cheers! ------------------------------ Roy Boxwell Senior Software ...

RE: Error creating a table

Posted By Roy Boxwell Wed February 28, 2024 01:37 AM
Found In Egroup: Db2 \ view thread
Your HASH_ID is two bytes too long for the primary_key. See docu: The number of identified columns must not exceed 64. In addition, the sum of the length attributes of the columns must not be greater than 2000 - n - 2m - 3d, where m is the number of varying-length columns and d is the number of ...

RE: Bind error in program: COBOL with DB2

Posted By Roy Boxwell Fri February 23, 2024 02:55 AM
Found In Egroup: Db2 \ view thread
Hi! Thats a very nasty RC you have got there... Normally means internal error trying to access the SYSLGRNX - Was anyone REORG directory tablespaces at the same time? ------------------------------ Roy Boxwell Senior Software Architect Software Engineering GmbH Duesseldorf +4921196149675 ------ ...

RE: Reorg 1.1B row table shrlevel reference

Posted By Roy Boxwell Fri February 16, 2024 01:28 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
hi! 100% use SHRLEVEL CHANGE and the "new" REORG parameter ICLIMIT to "batch" the TP level image copies together otherwise it will attempt to image copy in parallel! For the change to RPN you *must* do a TS level reorg so there is no other way and always use SHRLEVEL CHANGE regardless of what you ...

RE: Reorganization of PBG TS on partition number

Posted By Roy Boxwell Thu January 25, 2024 01:45 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Be careful if it is compressed or full of varchar columns – might not "fit back in" used to cause grief but is much better these days as it can allocate a new partition if maxpartitions has not been reached. All indexes are per definition NPSI so that can also cause grief as the "other" users still get ...

RE: How often runstats should be run

Posted By Roy Boxwell Fri November 24, 2023 01:03 AM
Found In Egroup: Db2 \ view thread
I am with Bruce here and even more radical really... Our Runstats Avoidance has rules about super size tables that states for over 100 Million rows a RUNSTATS is a real waste of CPU. After all, what are the chances of the Db2 optimizer choosing a different index or acces path with so much data? A table ...

RE: Timestamp with time zone

Posted By Roy Boxwell Wed November 22, 2023 02:24 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Hi! This works for me: -- RETURNS 2005-10-3110-00.00.00.000 SELECT TIMESTAMP(TO_DATE('2005-10-31', 'YYYY-MM-DD'), 3) FROM SYSIBM.SYSDUMMY1 ; SELECT TIMESTAMP_TZ(TIMESTAMP(TO_DATE('2005-10-31', 'YYYY-MM-DD'), 3),'-04:00') FROM SYSIBM.SYSDUMMY1 ; ------------ ...

RE: Bad or missing columns in SYSIBM.SYSINDEXES & SYSIBM.SYSINDEXPART

Posted By Roy Boxwell Wed August 30, 2023 02:01 AM
Found In Egroup: Db2 \ view thread
Hi, In the past when you created a partition (either data or index) your definitions for space were always saved at just the PARTITION level. What IBM did was allow all of these definitions to be at the TS or IX level. This saves a bit of work as , if the defs are all the same, you only need one ...

RE: Bad or missing columns in SYSIBM.SYSINDEXES & SYSIBM.SYSINDEXPART

Posted By Roy Boxwell Tue August 29, 2023 02:55 AM
Found In Egroup: Db2 \ view thread
Hi Barry! Here's an example of how it all looks. First some DDL snippets so you can see my table and index defs: CREATE TABLE XXXXXXX.XXXXT151 ("PKEY" CHAR( 1 ) ,"NUMSMALLINT" SMALLINT ,"NUMINT" INTEGER ,"NUMBIGINT" BIGINT ,"X03" TIME ,"X04" DECIMAL(5 , 1) Partitioning ...

RE: Bad or missing columns in SYSIBM.SYSINDEXES & SYSIBM.SYSINDEXPART

Posted By Roy Boxwell Mon August 28, 2023 01:45 AM
Found In Egroup: Db2 \ view thread
Hi! A couple of things I can answer without thinking: DEFINE YES/NO is not stored in the catalog anywhere. The column SPACE in SYSINDEXPART is used to register this at creation with a -1 and then when one row is inserted the VSAM LDS is created and this field is changed to be 0. DEFER ...

RE: Example of DD statement for a spanned variable block

Posted By Roy Boxwell Tue August 15, 2023 01:45 AM
Found In Egroup: ISV Ecosystem \ view thread
I use this for my SMF VBS datasets: //DUMP EXEC PGM=IFASMFDP,COND=(0,NE) //SMFDD1 DD DISP=SHR,DSN=SYS1.MAN1 //SMFDD2 DD DISP=SHR,DSN=SYS1.MAN2 //SMFDD3 DD DISP=SHR,DSN=SYS1.MAN3 //DUMPOUT DD DISP=(NEW,CATLG,DELETE),LRECL=32760,BLKSIZE=0,RECFM=VBS, // SPACE=(CYL,200,RLSE), // DSN=BOXWELL.SMFUNLD ...

RE: Timestamp with time zone

Posted By Roy Boxwell Mon March 13, 2023 03:42 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Hi! This works for me: ---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+------ select date('2005-10-10') 00000172 , timestamp('2005-10-10') 00000273 , timestamp('2005-10-10') at local 00000374 , timestamp('2005-10-10') at timezone '-04:00' ...

RE: Finding last updated time and checksum of a DB2 table

Posted By Roy Boxwell Wed October 19, 2022 01:31 AM
Found In Egroup: Db2 \ view thread
Hi! There are some timestamps in the RTS that could help you but not that much really. Checksum is not available anywhere. You must code that yourself and is obviously very very cpu intensive... ------------------------------ Roy Boxwell ------------------------------

RE: SQL0407 Null values not allowed in column or variable

Posted By Roy Boxwell Wed October 19, 2022 01:29 AM
Found In Egroup: Db2 \ view thread
Hi! Without seeing the SQL it is tough but I would hazard a guess you are doing an INSERT and not giving all column names/values. Then the "missing" ones get the NULL value and if they are defined as NOT NULL then you get this exception. That's how it is on z/OS anyways... ------------------------------ ...

RE: Use of Relative Page Numbering (RPN)

Posted By Roy Boxwell Wed October 05, 2022 01:01 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Hi! There is an increase in size and logging due to the seven byte rid so depending on your row size and your update rates you will need more space for the object and for the logs but as it is only two bytes for the rid it is a maximum of 1%. Doesn't sound much but if you have 256GB DSSIZE that's still ...

RE: REORG large TS to convert to RPN, DASD requirements

Posted By Roy Boxwell Wed September 28, 2022 01:17 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Hi! Without VTS that is going to be tough! However there are the "new" ICLIMIT_TAPE and, for you, ICLIMIT_DASD REORG options in APAR PI75518 UI75979 this enables you to reduce the number of physical TP image copies dramatically, naturally your space requirement is the same... Roy Boxwell SOFTWARE ...

RE: Result of expression "-(SELECT 3 FROM SYSIBM.SYSDUMMY1 )" in update statement is zero and not -3

Posted By Roy Boxwell Tue August 30, 2022 01:31 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
IBM just released APAR PH48073 with PTFs UI82094 UI82095 to fix this and it is also a HIPER... ------------------------------ Roy Boxwell ------------------------------