Db2 - L

Latest Discussion Posts

  • CenCan Db2 User Group April 12/13 (Mon/Tues) > Virtual and Free! Open to anyone! http://www.ccdb2.ca/db2_2021.htm CCDUG, with the assistance of IDUG, will be hosting a 2-day Db2/IMS online technical conference with 2 parallel tracks ...

  • Our DEVOPS environment wants to use a "single" service ID for creation of Native Stored Procedures across all applications. What are others doing for authorities? I am thinking DBADM without dataacess, hoping this will allow Drop/Create of SP and Grant ...

  • Please join us tomorrow at 10 AM Central time for John Hornibrook speaking on query optimization. Register at https://register.gotowebinar.com/register/9157797577233636620 Thanks, and see you there. ============================================ ...

  • Hello Leila, You only need to rebind your NULLID packages with a new APPLCOMPAT if your applications want to exploit the new SQL functionality introduced by function level 500. You can see a list of all the SQL changes in the IBM documentation . You ...

  • Profile Picture

    database Size

    Hello - I have written the below query to find the size of DB, kindly let me know is this correct ? SELECT 'KB='||CHAR(SUM(A.KB+B.KB)), 'MB='||CHAR(SUM(A.KB+B.KB)/1024) FROM (SELECT SUM(SPACE) AS KB FROM SYSIBM.SYSTABLEPART WHERE DBNAME ...