Where has all the time gone? It seems between E-mail, Conference Calls and Content Development. Its past time to update you on my progression through "Getting Started with IBM Data Studio" ebook. Chapter 4 deals with creating SQL and XQuery scripts within Data Studio. I created a Data Project in Data Studio,selected my Database Connection and Default Schema. I was off to the races building SQL statements!
After creating a project, you'll find an "SQL Scripts" directory. Right clicking on it, you'll see the following: New > SQL Script which brings up the SQL editor.
You can create and run your own SQL scripts, just like what I've created below.
If your typing challenged like me, be sure to use the Command Completion feature by pressing Ctl+Space. To run your statement, simply right click and select "Run SQL"
Another neat feature in Data Studio is the SQL Builder. This Menu driven GUI builds the SQL statement for you. All you need to do is follow the prompts selecting Tables, Columns and if needed Conditions
You can view the SQL results in the lower right hand corner of Data Studio.
That's all there is to creating SQL Scripts! Remember, all you need to do is select New> Data Development Project, Name it, Connect it. When your Project is created right click on the SQL Directory and select New > SQL Script and start building your SQL. Next up is Developing Stored Procedures in Chapter 5
Looking for Skills in all the Wrong Places: "Keeping Skills current when you have No Time, No Budget and No Travel"
kczap 120000E62C Etiquetas:  xquery db2 data management studio skills sql information 1.458 Visitas
I had a choice between databases and sitting on a Sunny Beach. I choose the Beach. Sorry guys, I need to keep my priorities straight. The Beach trumps databases any day.
I’m back now with a slight tan and a better outlook on life.
After Spring Break, I jumped right into Chapter 3 – Maintaining the database. Unfortunately Chapter 3 reached out and bit me a couple of times. I should say DB2 failed to live up to its end of the bargain by tossing some transactional log errors my way. It was DB2’s way of welcoming me back from Spring Break. Once I figured out the error and increased the log file size DB2 stopped complaining and life was good.
This Chapter is all about Database Maintenance and starts off with a nice introduction about managing storage and table space creation pretty straight foreword stuff.
The book does a great job of showing you how to use Data Studio features for data management. I’m learning allot about Data Studio and refreshing my skills on data base concepts like Buffer Pools and Data Reorganization.
In Data Studio, Buffer Pools and Data Reorganization is just a right mouse click away!
Everything was going smooth until I reached the EXPORT/ IMPORT section towards the end of the Chapter. I was following the descriptions and pictures in the book. The book has you do a export of the following table, “Order Details”. No problems there. The book follows the export example by doing an Import next. Here’s where I stumbled again. I followed the book and selected the Import statement.
The IMPORT failed,(see page 106,fig 3.19). I followed the book and the book does a “INSERT” statement noting that the data will be appended to the existing data in the table. Does it really or does it look at the data and throw an error?
The next thing, I tried was the INSERT_UPDATE statement. That worked without any errors. It essentially compared my Import file with the data in the database and didn’t notice any updates.
So I’m assuming the book was incorrect in stating the data would be appended to the table if the data ???
The last part of the Chapter dealt with back up and restoring your database from data Studio. As I said before, Database Maintenance seemed just a couple of mouse clicks away.
All in all, the more I use Data Studio the more intuitive it becomes.
kczap 120000E62C Etiquetas:  data studio management db2 database skills information 1.209 Visitas
My congratulations go to the New Orleans Saints for a job well done. It wasn't that long ago the Saints were considered the laughing stock of the National Football League. I was worried that curse was coming back to haunt them ,when they ended up being down by 10 points. They met the challenge head on and never gave up playing like true champions during the second half. I'm sure the drinks poured all night long on Bourbon Street. I wonder how many folks made it to work Monday morning?
I completed Chapter 2 , " Managing your database environment" over the weekend. This chapter covered creating and connecting to databases. We also learned how to create database objects like Schemas. Schemas define database structures, such as Tables, Indexes, Views, etc. We also learned how to add new users and set Privileges on our sample database. One feature that I was unfamiliar with was the "Analyze Impact" option. Say your making changes to a database object and, you want to see or detect any object dependencies before you commit to the change. The Model Report view lists object dependencies for you.
One other note. Make sure you read the entire section including the Grey boxes before trying to follow along in Data Studio. They typically contain very useful information and will save you some time trying to figure out what went wrong. I must remember, "When in doubt read the Manual"..
I decided to take advantage of some unproductive time and read Chapter 1 the Overview and Installation section. I read it while my Son was taking his Guitar lesson. How Geeky can you get. Sitting in a car, reading a ebook from a Laptop. Chapter 1 covers the overview and installation of Data Studio, basic stuff. I've have a VMware workstation license and decided to load all my software onto a virtual image. In other words a Guest operating system. Using a Virtual system works great for skill building and training purposes. It allows you to take snapshots, revert back to previous configurations, etc. It works great for me, If I screw something up. I can always go back to the saved version.
I'm fairly familiar with DB2, receiving my DB2 Database Associate Certification several years ago. I also know my way around Eclipse having worked with various versions throughout the years. I've never used Data Studio and since it's replacing the DB2 Control Center and Developer Workbench. I'd like to get to know it better. I took the authors recommendation and downloaded, Data Studio, DB2 Express C 9.7, WebSphere Application Server Community Edition V2.1 and the Go Sales sample database.
The only issue I had, was the link to download the sample database. It didn't work. I Googled "GSDB download" and found the sample database here.
I'm good to go.
On to Chapter 2,
kczap 120000E62C Etiquetas:  database campus studio skills series db2 data ebooks 1 Comentario 2.169 Visitas
The old Chinese proverb states, "The Longest Journey begins with the First Step". When it comes to obtaining and keeping skills current the Journey never really ends. Technology changes so rapidly, as soon as you become proficient on one Programming Language, Architecture or Operating System. Bam, it's outdated,deprecated or just plain out of fashion. So, now what do you do? You can't rely on what you use to know. You have to keep your skills up, but how? You got no time, you got no money and travel is out of the question.
I struggle personally with Blogs, wanting to write one for some time. For the life of me, I couldn't figure out what to write about. I see no use in blogging just for the sake of blogging. It's a waste of the readers time and its a waste of my time too. The light bulb finally went off when I received a copy of IBM's DB2 on Campus ebook entitled," Getting started with Data Studio for DB2"
I like all IT Professionals need to keep my skills current and keep abreast of new skills offerings. So why not blog about my experiences with the new ebook offering? The game plan is to work through at least one chapter per week and talk about my experiences. If you're interested in Data Studio or DB2, your welcome to join me and we can share our thoughts. I'll try to post all relevant links to software, documentation and anything else I find useful.
Let's begin with the First Step,