![IDUG: International Db2 Users Group](/img/default-banner.jpg)
- 106
- 102 113
IDUG: International Db2 Users Group
United States
Registrace 22. 06. 2011
IDUG is all about community; through education events, technical resources, unique access to fellow users, product developers and solution providers we offer an expansive, dynamic technical support community that delivers quality education, timely information and peer-driven product training and utilization that enable Db2 users to achieve organizational business objectives, and to drive personal career advancement
Maybe Profiling Isn't Always a Bad Thing... In Db2 that is Presented By Adrian Burke
Not all distributed workloads are well-behaved, predictable, uniform in execution, or should be treated equally. Most Db2 technicians are not able to calculate the total possible number of connections or even threads that could inundate their subsystem at any moment. In this API economy and ever-increasing Mobile workloads there are certain proactive measures which can be put in place to protect the security and availability of you Db2 for z/OS landscape.
zhlédnutí: 295
Video
IBM Db2 SQL Data Insights - Uncover insights based on hidden relationships in Db2 for z/OS data
zhlédnutí 1,8KPřed 2 lety
Db2 for z/OS SQL Data Insights - feature of Db2 13 for z/OS An industry-leading relational database with embedded AI capabilities Infuse AI directly into your database on existing data to discover hidden information. 1. Minimizes complexity of deploying AI into your applications 2. Single model used for a range of inferencing task over multiple fields 3. Exploit IBM z16 AI acceleration
Brining AI into the Database with Db2's New Python UDFs and Built-in Machine Learning Procedures
zhlédnutí 409Před 2 lety
In this video you'll be shown (with examples) how to use the built-in stored procedures to solve different types of problems and how to create, debug, and run your own Python functions. This will include taking models built in Jupyter Notebooks (and other applications) and embedding them in a Db2 Python function. Other approaches like using REST API calls within a Python function to do scoring ...
The Joys of Joins By Emil Kotrc
zhlédnutí 201Před 2 lety
Emil Kotrc reviews the history and theory of joins in relational algebra, explores the types of joins (including inner, outer, natural, equal, cross, anti-join and lateral join), and explains the implementation of joins and performance considerations.
Taming Python and Db2 for z/OS by Jørn Thyssen
zhlédnutí 2KPřed 2 lety
Taming Python and Db2 for z/OS by Jørn Thyssen
Going the Distance: Testing Networking Impacts on Db2 by Mark Murnane
zhlédnutí 186Před 2 lety
Going the Distance: Testing Networking Impacts on Db2 by Mark Murnane
Db2 for z/OS infused with AI increasing systems performance
zhlédnutí 220Před 2 lety
The digital world is exploding with application complexity, lack of experience work force, real-time data and cloud computing, enterprises are searching for a way to increase performance. Hear how Db2 infused with AI can help your Db2 systems run at peak performance to become a strategic contributor
Hear why Db2 for z/OS customer Garanti BBVA is interested in Db2 AI
zhlédnutí 682Před 2 lety
AI technology is innovating relational databases and at the same time improving employee productivity and reducing enterprise IT costs. Hear directly from Db2 for z/OS client Ibrahim Parlak from Garanti BBVA why Garanti see AI as an important Db2 strategy
Chris Crone of Broadcom invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
zhlédnutí 58Před 2 lety
Chris Crone of Broadcom invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
Greg Lotko of Broadcom invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
zhlédnutí 38Před 2 lety
Greg Lotko of Broadcom invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
Mehmet Cuneyt Goksu invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
zhlédnutí 31Před 2 lety
Mehmet Cuneyt Goksu invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
Bob Bersano invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
zhlédnutí 18Před 2 lety
Bob Bersano invites you to IDUG Virtual 2021 EMEA Db2 Tech Conference
CUNEYT GOKSU invites you to IDUG EMEA 2021
zhlédnutí 74Před 2 lety
Check out the buzz and excitement at at IDUG EMEA 2021 - don't miss the IBM Db2 Analytics Accelerator Workshop
IDUG EMEA 2021 - Don't Miss Barry Baker IBM VP at IDUG.
zhlédnutí 57Před 2 lety
Barry Baker, IBM VP of Product Management for IBM Z and LinuxONE share why you should not miss IDUG EMEA 2021 this year. Check it out!
Sowmya Kameswaran from IBM Db2 Development share why you should attend IDUG EMEA 2021
zhlédnutí 123Před 2 lety
Sowmya Kameswaran from IBM Db2 development shares why you should be planning to attend IDUG EMEA 2021
Julia Carter Presents Unlimited Fun (and Failures) with RLF
zhlédnutí 238Před 2 lety
Julia Carter Presents Unlimited Fun (and Failures) with RLF
How to Access the IDUG Australasia Db2 Tech Conference Sessions
zhlédnutí 105Před 2 lety
How to Access the IDUG Australasia Db2 Tech Conference Sessions
Interactive Db2 12 Client Panel with John Campbell IBM DE
zhlédnutí 365Před 2 lety
Interactive Db2 12 Client Panel with John Campbell IBM DE
Paul Bird Introducing Multi-Tenancy to the Db2 World
zhlédnutí 384Před 2 lety
Paul Bird Introducing Multi-Tenancy to the Db2 World
A Checklist?? Not for Solving Query Performance Problems
zhlédnutí 305Před 3 lety
A Checklist?? Not for Solving Query Performance Problems
Replication for Continuous Availability Technology
zhlédnutí 403Před 3 lety
Replication for Continuous Availability Technology
Make a Statement with Attention to Detail: Cached SQL Performance Statistics
zhlédnutí 185Před 3 lety
Make a Statement with Attention to Detail: Cached SQL Performance Statistics
IBM Db2 AI for z/OS evolution continues.
zhlédnutí 200Před 3 lety
IBM Db2 AI for z/OS evolution continues.
Security Enhanced Db2 with Security Enhanced Linux (SELinux)
zhlédnutí 239Před 3 lety
Security Enhanced Db2 with Security Enhanced Linux (SELinux)
db2 index : czcams.com/video/dEQqWzgKh6Y/video.html
A lot of solutions but no ranking in terms of time consuming, which is the best, etc
Thank you for this very useful video!
Really nice explained
Hi, can you show how to write a stored procedure that has statements delete , then insert into select then select that provides result set all this in one stored procedure
Is it possible to watch the other two "private" videos you show at min 55 ?
Thank you..Nice explanation..Kindly share the Git URL for code
Sir, How to implement batch deletion in JPA repository using cursor approach??
Thanks
Thanks. Will be watching 💯
very well explained. thank you!
Hi! I started working as a dbm and I was told that I will be given installations and system maintenance as you told during the first few months. Any advice for me?
Hi please can you try posting this on the IBM Db2 community community.ibm.com/community/user/hybriddatamanagement/communities/community-home?communitykey=621c2a2a-01f9-4b57-992f-36ed7432e3bb&tab=groupdetails
Hi very good
Thankyou so much the CTE helped me out to fix a very complex scenario in DB2 .
Thanks. I think CTE can help everyone make complex SQL more simple!
Really like this video Ember B.,I had gone through various notes you left on TSAMP . Just want to convey big thanks to you for all this stuff . I m TSAMP support team working with Clark Jackson ( You must know I think ) . In the end appreciate your effort .
At 30:00 the final close bracket is missing 😀
Can you ttell DB2 client software to support application Client or server system
That was Great ! Is the example code available on GitHub ? If so, please share the link. It would be great for all the beginners. Thanks
Thank you Brain for the very good session. One question. Few days my application upgraded to DB2 V12 R1 M505 function and all of sudden our DB2 COBOL stored procedure failing on the global temp temp tables. All these stored procedure calling from the front end Java. Now global temp tables sql are failing with SQL code -204, _601 within the stored procedure. Please help me thank u
I apologize for my late reply! I hope you found a solution by now. I am not familiar with this problem. If you have time... perhaps you can clarify your problem and tell us your solution! regards
very good. as someone who is familiar with DB2 as a DBA... this SPRING FRAMEWORK thing is all new to me. It was good... you gave me enough info to get started !
Just awesome ! Got what I wanted 😜😜
0:37 dirk-girl.com
I am facing a problem with temporary table, I searched it on Google and I found to your video. I'm new in DB2 so this is so useful for me. Thanks you Brian. But I have a concern that whether there's any difference of working between temporary table in a script and in a stored procedure? My problem is that I declared a temp table and inserted data into it (inserted successfully with 1 row - shown in message after execution) inside a script but there is no row when I selected it out after INSERT statement, this results to another issue that I cannot join this temp table with another table (cause no data to join). With the same code, I brought it into a stored procedure, it works, the temp table has data and it can be used for joining. Do you know why? Could you please give me advice, I will really appreciate about that. Thanks again!
Subtitled! GREAT
A couple of questions about the Data Server Client. Dose it require ROOT to configure? Do you have to create an "instance" first? I couldn't even source the db2profile since it is read-only. Why does't the "db2" command work - /db2 SQL10007N Message "-1390" could not be retrieved. Reason code: "3".
what is db2 version 11.5 edition and features?
good presentation that attempts to clarify a surprisingly subtle and challenging topic
Tony is awsome!! Can you put the IDUG link for the presentation here?
can we use this ibm_db api to connect to any On premise DB2 database ?
Thank you Brian ! Very good learning indeed 🙂
Thanks for watching! I like to know that someone finds my sessions useful!
wow looking forward to your session thank you
We have a lot of great content planned!
is there similar presentation for OLTP changes ?
another great vid on sqls and db2
Save yourself the waffle: 5:06
so With UR means......??
"UR" means Uncommitted Read. Using WITH UR in SELECT queries is highly recommended because UR does not take exclusive access.
He did not show any SQL till 20 minutes and later he went too fast as time ran out.
Fantastic video, but your microphone gain really needed an adjustment, made voice sound harsh
Please can you share the slides?
Thanks for sharing this, a big applause.
CREATE OR REPLACE VARIABLE JSON_VAR VARCHAR(8000); SET JSON_VAR='{ "id" : 901, "name" : { "first":"John", "last":"Doe" }, "phones" : [{"type":"home", "number":"555-3762"}, {"type":"work", "number":"555-7252"}] }'; I am passing JSON_VAR to the query as shown below . INSERT INTO JSONPROD VALUES ( 101, SYSTOOLS.JSON2BSON(JSON_VAR)); Note: JSONPROD is a table with columns (ID, JSONDATA) Issue is, above query reads the value of JSON_VAR as null. Can you help me on this?
I didn't know that Quota Query had a name, good stuff. Thanks for sharing the knowledge, Tony.
Preparing your DB2 12 System Administrator for z/OS C2090-318 Exam visit@ www.troytec.com/C2090-318-exams.html
Excelente concept I like it
Your awesome, thank you!
can I have contact number please very awesome video. will see it again and make a notes your awesome maam
I learned a lot from this video. Just what I was looking for. Thank you!
This is nice Video , Thanks for sharing these information. DataSunrise provide the security software .It is a very important Software to secure all databases in the organization. Visit here :- www.datasunrise.com
very interesting comparision
can't hear
Great presentation Michael and Jacek! Excellent topic!