IBM Data Studio is replacing DB2® Control Center and other tools for
DB2. In conjunction with DB2 Express-C, the no-charge edition of DB2, Data
Studio is ideal for DBAs, developers, students, ISVs, or consultants because
it's easy and free to use. Data Studio can be used with other data servers, and
you can extend Data Studio with additional robust management and development
capabilities from IBM to help accelerate solution delivery, optimize
performance, protect data privacy, manage data growth, and more. This note
covers the following topics: getting started with IBM data studio couldnot be
easier, read this free ebook to: find out what IBM data studio can do for you,
learn everyday data management tasks, write sql scripts and schedule them as
jobs, back up and recover db databases, tune queries and use visual explain,
write and debug sql stored procedures and routines, convert existing sql or
stored procedures to web services and practice using hands-on exercises
Author(s): Dimple Bhatia, Vinod
Chirayath, Adam Faeth, Praveen Ghantasala, Hassi Norlen, Hardik Patel, Daniel
Zilio.
This note covers the
following topics: Traditional DDS, SQL Interface, Data Definition Language,
Advanced DML, Security and Admin, DB Connectivity, Query Manager, Object and Row
Locking, Save Files, Override DB Files.
This book introduces you to DB2® application
development using DB2 Express-C. Learn about DB2 stored procedures, functions
and Data Web services using SQL and XQuery. Learn how to work with DB2 and JavaTM,
C/C++, .NET, PHP, Ruby on Rails, Perl, and more!
Author(s): Raul F. Chong, Xiqiang Ji, Priyanka
Joshi, Vineet Mishra, Min Wei Yao