[B! db2] mogwaingã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mogwaing id:mogwaing

db2ã«é–¢ã™ã‚‹mogwaingã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

IBM BLU | DBMSÂ 2 : DataBase Management System Services
I had a good chat with IBM about IBM BLU, aka BLU Accelerator or Acceleration. BLU basics start: BLU is a part of DB2. BLU works like a columnar analytic DBMS. If you want to do a join combining BLU and non-BLU tables, all the BLU tables are joined first, and the result set is joined to the other tables by the rest of DB2. And yes â€” that means Oracle is now the only major relational DBMS vendor le
mogwaing 2013/10/09
database

db2

blu

column-store
ãƒªãƒ³ã‚¯
DB2 V8 Fixpakã®æ–°æ©Ÿèƒ½(2) - DB2_SCATTERED_IO | Unofficial DB2 BLOG
Fixpak4ã‹ã‚‰ã€DB2_SCATTERED_IOã¨ã„ã†ãƒ¬ã‚¸ã‚¹ãƒˆãƒªå¤‰æ•°ãŒè¿½åŠ ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®å¤‰æ•°ã¯Linuxã§ã—ã‹æœ‰åŠ¹ã§ã¯ãªã„ã®ã§ã™ãŒã€ã“ã‚Œã‚’ONã«è¨å®šã™ã‚‹ã¨ã€DB2ã¯ãƒ•ã‚¡ã‚¤ãƒ«I/Oã®éš›ã«readv()ã‚’ä½¿ç”¨ã™ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ readv()ã¯è¤‡æ•°ãƒ–ãƒãƒƒã‚¯ã‚’ä¸€åº¦ã«èªã¿è¾¼ã‚€ãŸã‚ã®ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ã§ã€readvI()è‡ªä½“ã¯æ˜”ã‹ã‚‰Linuxã«ã‚ã‚‹ã®ã§ã™ãŒã€kernel 2.4ã¾ã§ã¯å˜ç´”ã«readã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ã‚’è¤‡æ•°å›žå‘¼ã³å‡ºã™å½¢ã§å®Ÿè£…ã•ã‚Œã¦ã„ãŸãã†ã§ã™ã€‚ã§ã€ã‚«ãƒ¼ãƒãƒ«2.6ã§ã¯readv()ãŒè‰¯ã„å½¢ã§å®Ÿè£…ã•ã‚ŒãŸã®ã ãã†ã§ã™ã€‚ ãã®ãŸã‚ã€ä¸Šè¨˜ãƒ¬ã‚¸ã‚¹ãƒˆãƒªå¤‰æ•°ã‚’ONã«ã™ã‚‹æ„å‘³ãŒã‚ã‚‹ã®ã¯Kernel 2.6ã‚’ä½¿ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã‹ã€ãã®readv()ã‚’ãƒãƒƒã‚¯ãƒãƒ¼ãƒˆã—ãŸã‚«ãƒ¼ãƒãƒ«ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ DB2ãŒã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¦ã€ã‹ã¤ãã®æ©Ÿèƒ½ãŒæœ‰åŠ¹ãªãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¯
mogwaing 2013/03/14
vector i/o DB2_SCATTERED_IO

db2

database
ãƒªãƒ³ã‚¯
èœ‚ã®å‹ã¯Linuxï¼Ÿã€€Stingerã¯RDBMSå¸‚å ´ã‚’å¤‰ãˆã‚‹ã‹
é–“ã‚‚ãªããƒªãƒªãƒ¼ã‚¹äºˆå®šã®ã€ŒDB2 UDBï¼ˆUniversal Databaseï¼‰ V8.2ã€ã¯ã€Linuxã‚«ãƒ¼ãƒãƒ«2.6ã«å¯¾å¿œã™ã‚‹ãªã©ã—ã€å¤§ããå¤‰è²Œã‚’é‚ã’ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã€‚ 9æœˆ7æ—¥ã€8æ—¥ã®2æ—¥é–“ã€æ—¥æœ¬ã‚¢ã‚¤ãƒ»ãƒ“ãƒ¼ãƒ»ã‚¨ãƒ ï¼ˆæ—¥æœ¬IBMï¼‰ãŒé–‹å‚¬ã—ãŸã€ŒIBM Linux ã‚³ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï½žç§‹ã®Linuxç¥ã‚Šï½žã€ã§ã¯ã€Stingerã«ã¤ã„ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚‚è¡Œã‚ã‚ŒãŸã€‚ Stingerã¨ã„ãˆã°ã€ã“ã“1å¹´ã‚ã¾ã‚Šã€ç´°åˆ‡ã‚Œã«æŠ«éœ²ã•ã‚Œã¦ããŸDB2ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€ã€ŒDB2 UDBï¼ˆUniversal Databaseï¼‰ V8.2ã€ã®ã‚³ãƒ¼ãƒ‰ãƒãƒ¼ãƒ ã§ã‚ã‚Šã€é–“ã‚‚ãªããƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã£ã¦ãã®ç‰¹å¾´ãŒå…·ä½“çš„ã«ç´¹ä»‹ã•ã‚ŒãŸã€‚è¬›å¸«ã¯æ—¥æœ¬IBMã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢äº‹æ¥éƒ¨ã®ä¸‹ä½ç²‰æ˜æ°ãŒå‹™ã‚ãŸã€‚ Linuxã‚«ãƒ¼ãƒãƒ«2.6å¯¾å¿œã§ä½•ãŒå¤‰ã‚ã‚‹ã‹ï¼Ÿ Stingerã¯æ—¢å˜è£½å“ã‹ã‚‰å¤§å¹…ãªæ©Ÿèƒ½å¼·åŒ–ãŒè¡Œã‚ã‚Œã‚‹ã¨ã„ã†ã®ã¯å‰ã€…ã‹ã‚‰è¨€ã‚ã‚Œã¦ãŠã‚Šã€ãã‚ŒãŒä¸–é–“ã®èˆˆå‘³ã‚’ã‹
mogwaing 2013/03/14
vector i/o DB2_SCATTERED_IO

db2

database
ãƒªãƒ³ã‚¯
IBM DB2ã®æ–°ã‚¯ãƒ©ã‚¹ã‚¿ã¯ã€Oracle RACã¨åŒã˜ã€Œã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€æŽ¡ç”¨
IBM Press room - 2009-10-09 IBM pureScale Techno logy Redefines Transaction Processing Economics - United States ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¤‡æ•°ã‚µãƒ¼ãƒã‹ã‚‰ãªã‚‹ã‚¯ãƒ©ã‚¹ã‚¿æ§‹æˆã«ã™ã‚‹ã“ã¨ã§æ€§èƒ½å‘ä¸Šã‚’ã¯ã‹ã‚‹ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã¯ã€å¤§ããåˆ†ã‘ã¦ã€Œã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨ã€Œã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã®2ã¤ã®æ–¹å¼ãŒã‚ã‚Šã¾ã™ã€‚ ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã¯ã€è¤‡æ•°ã®ã‚µãƒ¼ãƒãŒ1ã¤ã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚’å…±æœ‰ã™ã‚‹ãŸã‚é«˜å¯ç”¨æ€§ã‚’å®Ÿç¾ã—ã‚„ã™ã„ä¸€æ–¹ã€ã‚µãƒ¼ãƒé–“ã§ãƒ‡ãƒ¼ã‚¿æ•´åˆæ€§ã®ãŸã‚ã®æƒ…å ±ã‚’å…±æœ‰ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€ã‚µãƒ¼ãƒãŒå¢—ãˆã‚‹ã”ã¨ã«æƒ…å ±å…±æœ‰ã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ãŒå¤§ãããªã‚‹ã¨ã„ã†èª²é¡Œã‚’æŠ±ãˆã¦ã„ã¾ã™ã€‚ ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã¯ã‚µãƒ¼ãƒé–“ã®æƒ…å ±å…±æœ‰ãŒä¸è¦ã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å„ªã‚Œã‚‹ä¸€æ–¹ã§ã€ãƒ‡
mogwaing 2012/05/21
database

parallel processing

db2

purescale
ãƒªãƒ³ã‚¯
DB2 OLTP scale-out: pureScale | DBMSÂ 2 : DataBase Management System Services
mogwaing 2012/05/21
ibm

database

purescale

db2
ãƒªãƒ³ã‚¯
IBM PK34803: ABEND04E 00E72100 AT DSNXGRDS.DSNXSPKY+04DA - United States
mogwaing 2012/05/11
An ABEND04E 00E72100 at DSNXSPKY+04DA may occur when a parallel nested loop join group has a sort composite on the outer table and the inner table is using index access with at least one index column defined in DESCENDING order.

database

db2

parallel processing
ãƒªãƒ³ã‚¯
https://www.db2dean.com/Previous/RangePart.html
mogwaing 2011/08/16
Partition local index is ... Default in 9.7 unless it does not meet local index criteria

database

db2

partitioning

index
ãƒªãƒ³ã‚¯
IBM Documentation
mogwaing 2011/08/07
If a distribution key is not defined for a table in a table space that is divided across more than one database partition in a database partition group, one is created by default from the first column of the primary key. ... A hashing algorithm is applied to the value of the distribution key

db2

database
ãƒªãƒ³ã‚¯
IBM Documentation
mogwaing 2011/08/07
database partition groups (formerly nodegroups)

db2

partition
ãƒªãƒ³ã‚¯
Edge Components æ¦‚å¿µã€è¨ˆç”»ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« / WebSphere Application Server
Delivering near infinite scalability, real-time analytics, and multicloud support, IBMÂ® Db2Â®Â is an AI-powered database that accelerates decision making, reins in costs by using a single engine and promotes security for your business data.
mogwaing 2011/08/07
db2 9.5

ibm

database

db2

infosphere
ãƒªãƒ³ã‚¯
Making Operating System Calls from SQL
mogwaing 2011/08/07
db2

database

ibm

mqt

materialized view
ãƒªãƒ³ã‚¯
ï¼ ITï¼šé€£è¼‰ã€€DB2ã§XMLã‚’æ“ä½œã™ã‚‹ï¼ˆ1ï¼‰ XMLã®æ ¼ç´æ–¹æ³•ã‚’2ç¨®é¡žå‚™ãˆã‚‹DB2
XMLã®æ™®åŠã¨ã¨ã‚‚ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚XMLã‚’æ ¼ç´ã§ãã‚‹æ©Ÿèƒ½ãŒæè¼‰ã•ã‚Œã¦ãã¦ã„ã‚‹ã€‚ã—ã‹ã—ãã®æ©Ÿèƒ½ã¯ã€è£½å“ã”ã¨ã«å›ºæœ‰ã®ã‚‚ã®ã ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€IBMã®è£½å“ã§ã‚ã‚‹DB2 UDBã§ã©ã®ã‚ˆã†ã«XMLã‚’æ‰±ã†ã‹ã€ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã€‚ ãŸãŒã‚è£½ä½œæ‰€ 2002/11/14 ã“ã®é€£è¼‰ã¯ã€IBMã®è£½å“ã§ã‚ã‚‹ã€ŒDB2 Universal Databaseã€ï¼ˆä»¥ä¸‹DB2ï¼‰ã‚’ç”¨ã„ãŸXMLæ–‡æ›¸ã®ç®¡ç†ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã‚‚ã®ã§ã™ã€‚DB2ã¯çš†ã•ã‚“ã‚‚ã”å˜ã˜ã®ã¨ãŠã‚Šã€IBMã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸ25å¹´ã®æ´å²ã‚’æŒã¤ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBMSï¼‰ã§ã™ã€‚å¤§ãã„ã¨ã“ã‚ã§ã¯ãƒ›ã‚¹ãƒˆã‹ã‚‰ã€å°ã•ã„ã¨ã“ã‚ã¯PDAã¾ã§ã¨å¹…åºƒã„ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚2002å¹´10æœˆç¾åœ¨æ™‚ç‚¹ã§ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯7.2ã§ã‚ã‚Šã€è¿‘ã€…8.1ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹äºˆå®šã§ã™ï¼ˆç·¨é›†æ³¨ï¼š11æœˆ21æ—¥ã«å‡ºè·é–‹å§‹äºˆå®šã€‚ï¼‰ã€‚ DB2ã¯ã‚‚ã¨ã‚‚ã¨RDBMSã®æ©Ÿèƒ½ã‚’æŒ
mogwaing 2009/06/05
db2

xml
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
mogwaing 2009/04/24
db2

linux
ãƒªãƒ³ã‚¯
DB2é€†å¼•ãWiki
æœ¬ã‚µã‚¤ãƒˆã¯ IBMè£½RDBMSã§ã‚ã‚‹DB2ã®é€†å¼•ãæ©Ÿèƒ½ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ æŠ€è¡“è©•è«–ç¤¾ã‹ã‚‰å‡ºç‰ˆã•ã‚Œã¦ã„ãŸåŒåæ›¸ç±ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚ ãã®ãŸã‚ã»ã¨ã‚“ã©ã®ãƒšãƒ¼ã‚¸ãŒDB2ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.1.5ãƒ™ãƒ¼ã‚¹ã®è¨˜è¿°ã«ãªã£ã¦ã„ã¾ã™ã€‚8.2ä»¥é™ã§è¿½åŠ ã•ã‚ŒãŸæ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã«è¿½è£œã¨ã—ã¦ã¾ã¨ã‚ã¦ã‚ã‚Šã¾ã™ã€‚ å°†æ¥çš„ã«å‡ºç‰ˆå¾Œã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãªã©ã‚’åæ˜ ã—ãŸå†…å®¹ã«æ›´æ–°ã—ã¦ã„ãäºˆå®šã§ã™ã€‚ ã“ã¡ã‚‰ã‹ã‚‰ DB2é€†å¼•ããƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ç›®æ¬¡ DB2é€†å¼•ãWiki:å…è²¬äº‹é …
mogwaing 2009/04/24
db2
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
æ€ã„ã¯è¨€è‘‰ã«ã€‚ ã¯ã¦ãªãƒ–ãƒã‚°ã¯ã€ã‚ãªãŸã®æ€ã„ã‚„è€ƒãˆã‚’æ®‹ã—ãŸã‚Šã€ ã•ã¾ã–ã¾ãªäººãŒç¶´ã£ãŸå¤šæ§˜ãªä¾¡å€¤è¦³ã«è§¦ã‚ŒãŸã‚Šã§ãã‚‹å ´æ‰€ã§ã™ã€‚
mogwaing 2009/04/24
db2

mac
ãƒªãƒ³ã‚¯
IBM Software | IBM
IBM Watson Assistant Quickly build and deploy virtual assistants across channels
mogwaing 2009/04/17
free edition

db2

database
ãƒªãƒ³ã‚¯
IBM Documentation
mogwaing 2009/03/20
dababase

db2

predicate
ãƒªãƒ³ã‚¯
1