Who thought that trying out the new UUID-related functions in Db2 12.1.3 could be that interesting? There are special bits in every UUID and NOW I know what to look for. Do you? Read my latest post https://data-henrik.de/2026/01/db2-generate-uuid-explained/
#Db2 #SQL #UUID #database #IDUG #DeDUG @ferdinand98 @globomike
#Db2
With some help from the SZE community, I can now log my service uptime and latency in #Db2 using #Golang !
I've got a service called CompInvZ which links into my Db2Z host to find services, then it periodically tries to connect and records the result back to DB2
A friend of mine took it a step further and is using #ISPF to interact with Db2 via #REXX
That means #CICS is next on the list, thanks #Walmart !
https://github.com/walmartlabs/zECS
CVE Alert: CVE-2025-36186 - IBM - Db2 - https://www.redpacketsecurity.com/cve-alert-cve-2025-36186-ibm-db2/
#OSINT #ThreatIntel #CyberSecurity #cve-2025-36186 #ibm #db2
#ADOdb 5.22.10 has been released (#DatabaseAbstractionLayer / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #OracleDatabase / #SQLServer / #MicrosoftSQLServer / #DB2 / #IBMDB2) https://adodb.org/
COBOL в XXI веке: почему банки и госслужбы не могут отказаться от языка 1959 года
Представьте, что расчёт вашей пенсии или миллионы банковских транзакций обрабатываются кодом, написанным до полёта человека в космос. COBOL живёт в мэйнфреймах банков, страховых и госслужб, и отказаться от него рискованно: один баг — и вся финансовая система может остановиться. Как старейший «серверный» язык справляется с XXI веком, где безопасность и гибкость важнее вечной стабильности?
https://habr.com/ru/companies/ruvds/articles/918156/
#ruvds_статьи #mainframe #банковские_технологии #cobol #финансовые_транзакции #API_фасады #CICS #db2 #миграция_с_COBOL #финансовые_технологии
COBOL в XXI веке: почему банки и госслужбы не могут отказаться от языка 1959 года
Представьте, что расчёт вашей пенсии или миллионы банковских транзакций обрабатываются кодом, написанным до полёта человека в космос. COBOL живёт в мэйнфреймах банков, страховых и госслужб, и отказаться от него рискованно: один баг — и вся финансовая система может остановиться. Как старейший «серверный» язык справляется с XXI веком, где безопасность и гибкость важнее вечной стабильности?
https://habr.com/ru/companies/ruvds/articles/918156/
#ruvds_статьи #mainframe #банковские_технологии #cobol #финансовые_транзакции #API_фасады #CICS #db2 #миграция_с_COBOL #финансовые_технологии
Some twenty years ago you could just order stuff on the Internet for free. Big companies were giving away cool things: I remember you could get IA-32 programming manuals from Intel at zero cost (and zero shipping costs).
Me being stupid me got this. A whole package of IBM DB2 8.1 for AIX (32-bit) disks including learning materials.
I still wonder what to do with these.
There's zero chance of me stumbling upon an AIX-supported hardware.
Today is the DBA Appreciation Day!
Bring your DBAs a cake and a coffee, please. And don't drop any tables in production, pretty please. It's weekend ...
#PostgreSQL #SQLServer #Oracle #DB2 #MySQL #MariaDB #Snowflake #SQLite #Neo4j #Teradata #SAPHana #Aerospike #ApacheSpark #Clickhouse #Informix #WarehousePG #Greenplum #Adabas
Today is the Database Administrator Appreciation Day!
DBA’s work happens behind the scenes, with no fanfares, often the carefully planned operations are on the weekends or in antisocial hours.
Let’s shout loud Happy DBA Day!
Whether you are a DBA or not please, share the website with your team mates.
#dba #databaseadministration #dbaday #postgresql #oracle #mysql #sqlserver #db2 #database #administration #appreciation #thanks
A new Db2 fixpack release, Db2 v12.1.2, is now available. An important new feature is a #vector data type with related functions. It allows to use #Db2 as vector store for #RAG / #genAI use cases, keeping biz data and vector data in one place. See https://data-henrik.de/2025/06/db2-v121-mod-pack2-available/ for details and links
Am Freitag, 11.07.25, ist das nächste Treffen der Deutschen Db2 User Group (DeDUG). Schon angemeldet? https://data-henrik.de/2025/06/german-db2-user-group-meeting-july-2025/ #db2 #database #usergroup #IDUGDb2 #IBM
Finding a Specific Value Across Multiple SQL Tables: A Comprehensive Guide
Find value in multiple tables SQL using DB2. Data type mismatches are a common query troubleshooting issue. Learn how to avoid errors by carefully considering data types. #DB2 #SQL #DataTypes #QueryTroubleshooting #Database #SQLQueries
https://tech-champion.com/programming/finding-a-specific-value-across-multiple-sql-tables-a-comprehensive-guide/
...
Finding the First Match of Names in a Large Database
Optimize DB2 LUW queries for speed! Find the first match of a name in a large table using ROW_NUMBER() window function. Avoid fetching all matches. #DB2 #SQL #ROW_NUMBER #WindowFunctions #DatabaseOptimization #QueryPerformance
https://tech-champion.com/programming/finding-the-first-match-of-names-in-a-large-database/
...
How to Format Timestamps in DB2 Script?
Transforming time stamps in DB2 queries is crucial for clarity and compliance with specific formatting requirements. Discover tips for using VARCHAR_FORMAT, troubleshooting SQL errors, and maintaining data integrity. #DB2 #Queries #DataFormatting #SQLErrors #DataIntegrity #TechTips
https://tech-champion.com/programming/how-to-format-timestamps-in-db2-script/
...
Troubleshooting DB2 REORG in Compound SQL Statements: Why Does It Fail?
Troubleshooting DB2 REORG compound statements. Learn the difference between compiled and inlined compound SQL blocks in DB2 LUW to avoid errors and optimize database reorganization. Key takeaways include best practices, error handling, and performance considerations. #DB2 #REORG #SQL #Database #Troubleshooting #Performance
https://tech-champion.com/programming/troubleshooting-db2-reorg-in-compound-sql-statements-why-doe...
How to Split Comma-Separated Values with Multiple Items in Brackets?
Efficiently parsing comma-separated values (CSV) in DB2 LUW strings, even with delimiters within the data, is now possible! Learn how XMLTABLE handles complex string formats for accurate data extraction. #DB2 #XMLTABLE #StringParsing #CSV #DataExtraction #DB2LUW
https://tech-champion.com/programming/how-to-split-comma-separated-values-with-multiple-items-in-brackets/
...
DB2 for i Date Comparison: A Guide to Efficient Date Handling
Master DB2 for i Date Comparison! Learn efficient techniques for accurate & reliable date handling in your DB2 applications. Improve query efficiency & avoid common pitfalls. #DB2 #DateComparison #Database #SQL #Programming #iSeries
https://tech-champion.com/database/db2luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/
...
Node.js Hourly Metrics: Efficient PostgreSQL Query for App Server Monitoring
Node.js Hourly Metrics: Optimize PostgreSQL queries for efficient data retrieval & processing. Learn techniques for accurate & fast application server monitoring. #nodejsmetrics #databaseoptimization #postgreSQL #hourlydata #db2 #monitoring
https://tech-champion.com/database/db2luw/node-js-hourly-metrics-efficient-postgresql-query-for-app-server-monitoring/
...
Dynamic SQL in DB2: Using Variables for Table Names
Learn about DB2 Dynamic SQL: build flexible queries with variables, but prioritize security! Use prepared statements to prevent SQL injection. Master secure coding practices for robust database apps. #DB2DynamicSQL #DynamicSQL #SQLInjection #PreparedStatements #DatabaseSecurity #DB2
https://tech-champion.com/database/db2luw/dynamic-sql-in-db2-using-variables-for-table-names/
...
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst