CVE-2024-47118

-- CVE-2024-47118 PoC - IBM Db2 DoS via crafted query -- Note: This is a conceptual PoC based on the vulnerability description -- The actual exploit requires specific query patterns that trigger the crash -- Example of potential crash-inducing query patterns: -- The following is a simplified representation of the attack concept -- Subquery with complex joins and aggregations SELECT * FROM ( SELECT t1.col1, t2.col2, COUNT(*) FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id LEFT JOIN table3 t3 ON t1.id = t3.id WHERE t1.status IN ( SELECT status FROM ( SELECT DISTINCT status, ROW_NUMBER() OVER() as rn FROM table4 ) subq WHERE rn > 0 ) GROUP BY t1.col1, t2.col2 HAVING COUNT(*) > ( SELECT MAX(cnt) FROM ( SELECT COUNT(*) as cnt FROM table5 GROUP BY colX ) inner_subq ) ) final_query WHERE ROWNUM < 1000; -- The actual PoC may involve: -- 1. Deeply nested subqueries -- 2. Specific combination of JOIN types -- 3. Window functions with edge cases -- 4. Complex HAVING clauses with correlated subqueries -- For actual exploitation, refer to IBM security bulletin for specific details

{"cve": {"id": "CVE-2024-47118", "sourceIdentifier": "[email protected]", "published": "2025-11-07T19:15:45.413", "lastModified": "2025-11-19T16:49:17.190", "vulnStatus": "Analyzed", "cveTags": [], "descriptions": [{"lang": "en", "value": "IBM Db2 10.5.0 through 10.5.11, 11.1.0 through 11.1.4.7, 11.5.0 through 11.5.9, and 12.1.0 through 12.1.3 for Linux, UNIX and Windows (includes Db2 Connect Server) is vulnerable to a denial of service as the server may crash under certain conditions with a specially crafted query."}], "metrics": {"cvssMetricV31": [{"source": "[email protected]", "type": "Secondary", "cvssData": {"version": "3.1", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H", "baseScore": 6.5, "baseSeverity": "MEDIUM", "attackVector": "NETWORK", "attackComplexity": "LOW", "privilegesRequired": "LOW", "userInteraction": "NONE", "scope": "UNCHANGED", "confidentialityImpact": "NONE", "integrityImpact": "NONE", "availabilityImpact": "HIGH"}, "exploitabilityScore": 2.8, "impactScore": 3.6}, {"source": "[email protected]", "type": "Primary", "cvssData": {"version": "3.1", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H", "baseScore": 7.5, "baseSeverity": "HIGH", "attackVector": "NETWORK", "attackComplexity": "LOW", "privilegesRequired": "NONE", "userInteraction": "NONE", "scope": "UNCHANGED", "confidentialityImpact": "NONE", "integrityImpact": "NONE", "availabilityImpact": "HIGH"}, "exploitabilityScore": 3.9, "impactScore": 3.6}]}, "weaknesses": [{"source": "[email protected]", "type": "Secondary", "description": [{"lang": "en", "value": "CWE-121"}]}], "configurations": [{"nodes": [{"operator": "OR", "negate": false, "cpeMatch": [{"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:linux:*:*", "versionStartIncluding": "10.5.0.0", "versionEndIncluding": "10.5.0.11", "matchCriteriaId": "385D4613-C252-4075-8485-55B8E32DC970"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:unix:*:*", "versionStartIncluding": "10.5.0.0", "versionEndIncluding": "10.5.0.11", "matchCriteriaId": "9DD542DB-0839-4057-8551-55154788182A"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:windows:*:*", "versionStartIncluding": "10.5.0.0", "versionEndIncluding": "10.5.0.11", "matchCriteriaId": "D9ED6DEF-712F-4BB0-8676-D5DB6A269EBF"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:linux:*:*", "versionStartIncluding": "11.1.0", "versionEndIncluding": "11.1.4.7", "matchCriteriaId": "3B5A9A8A-5EE6-428A-8B3D-543B2F84D615"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:unix:*:*", "versionStartIncluding": "11.1.0", "versionEndIncluding": "11.1.4.7", "matchCriteriaId": "5971CCFD-FB34-4216-8A87-A4310EF34F23"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:windows:*:*", "versionStartIncluding": "11.1.0", "versionEndIncluding": "11.1.4.7", "matchCriteriaId": "960AA97F-0D2C-4B33-9754-69BC28399BCE"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:linux:*:*", "versionStartIncluding": "11.5.0", "versionEndIncluding": "11.5.9", "matchCriteriaId": "ECAF5576-B4A5-4DB7-94F0-942F656F0461"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:unix:*:*", "versionStartIncluding": "11.5.0", "versionEndIncluding": "11.5.9", "matchCriteriaId": "B1E165E8-F11B-4F13-B54A-90D29CA2ABF8"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:windows:*:*", "versionStartIncluding": "11.5.0", "versionEndIncluding": "11.5.9", "matchCriteriaId": "727E2804-2D3D-4C31-A3E5-F99107D02A27"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:linux:*:*", "versionStartIncluding": "12.1.0", "versionEndIncluding": "12.1.3", "matchCriteriaId": "2AA1764B-CD82-4B33-B85B-27CA2F7C0ED5"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:unix:*:*", "versionStartIncluding": "12.1.0", "versionEndIncluding": "12.1.3", "matchCriteriaId": "8F63D92C-AC19-4FB0-A605-08DC01875E7B"}, {"vulnerable": true, "criteria": "cpe:2.3:a:ibm:db2:*:*:*:*:*:windows:*:*", "versionStartIncluding": "12.1.0", "versionEndIncluding": "12.1.3", "matchCriteriaId": "E28DCDF3-EF5B-47D6-BD38-C98334B67BE4"}]}]}], "references": [{"url": "https://www.ibm.com/support/pages/node/7250473", "source": "[email protected]", "tags": ["Vendor Advisory"]}]}}