UIIPA – Our 32nd Year!

UIIPA – Our 32nd Year!

Utah IBM i Professionals Association

October Meeting: SQL for the System Admin

UPDATE: Scott gave a great presentation with tons of useful information. If you missed the presentation or would like a copy of his PowerPoint slides, you can get a copy of them here: SQL for the system administrator – UIIPA- October-2014

New Picture (1)

Our October meeting will be held on Wednesday, October 8th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend.

NOTE: This will be a 90 minute session so plan accordingly. Also, lunch will be served!

Topic: SQL for the System Admin: IBM i Commands, APIs and the role of DB2 for i and SQL

Speaker: Scott Fortsie, DB2 for i Business Architect (Via Webcast)

Big-SQL_27224636This presentation will focus on the ways in which SQL on IBM i can be used to accomplish a number of tasks that are unrelated to traditional uses of SQL. Although the central theme of these capabilities will be systems administration, benefits can be realized beyond that topic.

You’ll learn about the SQL capabilities that exist for systems management purposes. This presentation will include working SQL examples and some compelling reasons to add SQL to your set of skills.

Note that this session has been updated for IBM i 7.2 and will include a preview of the new services coming to 6.1, 7.1 and 7.2 in 4Q/2014.

Here is the basic outline for this presentation:

  • Traditional IBM i Interfaces
  • SQL is Key for IBM i
  • SQL Catalogs
  • SQL’s TCP/IP Services
  • SQL’s Work Management Detail
  • Security with SQL
  • SQL Storage Devices
  • SQL Journal Details
  • Find SQL Catalogs and Services
  • Get Going with SQL on IBM i

There are a lot of great new SQL-based services for you to use on IBM i 7.1 (and 6.1). By coming to this presentation you will position yourself for success by having the recipe to get you started in learning and implementing SQL.

Scott ForstieScott Forstie is the DB2 for i Business Architect, SQL Development team leader, and IBM i developerWorks content manager. In addition to his development roles, he is a frequently published author on SQL and database topics. (http://iprodeveloper.com/author/scott-forstie) He has worked for IBM nearly 25 years, working primarily on IBM i. Scott can be reached by email at forstie@us.ibm.com or followed on Twitter at @Forstie_IBMi, where he is trying to mix DB2 for i, business, and social.

581 Responses to October Meeting: SQL for the System Admin

  1. hello there and thank you for your info – I’ve certainly picked up something new from right here. I did however expertise a few technical issues using this web site, since I experienced to reload the website a lot of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I’m complaining, but slow loading instances times will very frequently affect your placement in google and can damage your quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my e-mail and can look out for a lot more of your respective interesting content. Make sure you update this again soon..

    Permalink
  2. F*ckin’ tremendous things here. I’m very happy to see your post. Thank you a lot and i’m taking a look ahead to contact you. Will you kindly drop me a e-mail?

    Permalink
  3. Hello, i think that i noticed you visited my weblog so i got here to “return the favor”.I’m trying to to find things to improve my web site!I guess its adequate to use some of your ideas!!

    Permalink
  4. Thanks for sharing excellent informations. Your web site is so cool. I’m impressed by the details that you have on this web site. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found simply the info I already searched all over the place and simply couldn’t come across. What a great website.

    Permalink
  5. I precisely needed to thank you so much again. I am not sure the things that I might have created without the actual tricks shown by you directly on this question. It previously was a troublesome crisis in my circumstances, but being able to see a new specialised technique you managed the issue took me to weep over happiness. I will be happier for the support and thus trust you recognize what a powerful job you are always providing educating others thru your webblog. Most probably you’ve never met any of us.

    Permalink
  6. Nice blog here! Also your web site loads up fast! What host are you using? Can I get your affiliate link to your host? I wish my web site loaded up as quickly as yours lol

    Permalink
  7. This really answered my drawback, thank you!

    Permalink
  8. I truly enjoy examining on this site, it contains good articles. “Never fight an inanimate object.” by P. J. O’Rourke.

    Permalink
  9. Do yoᥙ have any video of that? I’d love to fіnd out mоre details.

    Permalink
  10. At thіs time it looks like WordPress iѕ the top blogging platfodm out
    tһere right now. (from what I’ve read) Is that what you’re սusing
    on your blօg?

    Permalink
  11. Cool blog! Is your theme custom made or did you download it from somewhere?
    A design like yours with a few simple tweeks would really make my blog stand
    out. Please let me know where you got your theme. Many thanks http://Guardiandevils.de/index.php?site=profile&id=225532

    Permalink
  12. I blog quite often and I truly appreciate your content.
    Your article has really peaked my interest.
    I will bookmark your site and keep checking for new details about once per
    week. I subscribed to your Feed too.

    Permalink
  13. Hello, Neat post. There is an issue with your website in web explorer, may test this… IE still is the market chief and a large component to other folks will omit your magnificent writing due to this problem.

    Permalink
  14. Wonderful items from you, man. I have understand your stuff prior to and you’re simply too excellent. I really like what you have received here, really like what you are stating and the best way in which you assert it. You’re making it entertaining and you still take care of to stay it sensible. I can’t wait to learn far more from you. That is really a great web site.

    Permalink
  15. Excellent site. Lots of helpful info here. I¡¦m sending it to some buddies ans also sharing in delicious. And obviously, thank you to your effort!

    Permalink
  16. I like what you guys are up also. Such intelligent work and reporting! Carry on the excellent works guys I’ve incorporated you guys to my blogroll. I think it’ll improve the value of my website :).

    Permalink
  17. I am not sure where you’re getting your information, but good topic. I needs to spend some time learning much more or understanding more. Thanks for excellent information I was looking for this information for my mission.

    Permalink
  18. Can I simply say what a reduction to find someone who actually knows what theyre talking about on the internet. You undoubtedly know tips on how to deliver a difficulty to mild and make it important. Extra folks have to read this and understand this aspect of the story. I cant consider youre no more popular since you undoubtedly have the gift.

    Permalink
  19. Hello, Neat post. There’s a problem with your web site in web explorer, may test this¡K IE nonetheless is the market leader and a big component to other folks will miss your excellent writing due to this problem.

    Permalink
  20. Heya i am for the first time here. I came across this board and I to find It truly helpful & it helped me out much. I’m hoping to offer one thing back and help others like you aided me.

    Permalink
  21. Fantastic blog you have here but I was wanting to know if you knew of any message boards that cover the
    same topics discussed here? I’d really love to be a part of online community where I can get responses from other knowledgeable people that share the same
    interest. If you have any recommendations, please let me know.
    Kudos! http://forum.verygames.net/member.php?u=562739-WildaHiggs

    Permalink
  22. Some really nice and useful info on this web site, likewise I think the pattern holds fantastic features.

    Permalink
  23. I enjoy the efforts you have put in this, thankyou for all the great blog posts.

    Permalink
  24. Hi there very nice blog!! Man .. Beautiful .. Amazing .. I’ll bookmark your site and take the feeds also…I am satisfied to search out numerous helpful information here in the post, we’d like develop extra strategies on this regard, thanks for sharing. . . . . .

    Permalink
  25. I feel this is among the most vital info for me. And i’m happy reading your article. However wanna statement on few basic issues, The web site taste is perfect, the articles is really excellent : D. Good activity, cheers

    Permalink
  26. I got what you mean , thankyou for posting .Woh I am delighted to find this website through google. “Those who corrupt the public mind are just as evil as those who steal from the public.” by Theodor Wiesengrund Adorno.

    Permalink
  27. http://bit.ly/2hp3nTF Most piano benches on the websites for purchase
    are new piano benches, packed inside a box using the detachable legs stored inside.
    Unfortunately, the Go Cart Track must be closed to produce way for these developments.
    Your other legitimate source for your NY Giants tickets may be the many licensed New York ticket brokers, who walk out of the way to arrange your tickets for you.

    Permalink
  28. I am continuously looking online for posts that can facilitate me. Thank you!

    Permalink
  29. Appreciating the hard work you put into your site and detailed information you offer. It’s awesome to come across a blog every once in a while that isn’t the same out of date rehashed material. Great read! I’ve saved your site and I’m adding your RSS feeds to my Google account.

    Permalink
  30. Good day I am so excited I found your blog, I really found you by error, while I was browsing on Yahoo for something else, Anyhow I am here now and would just like to say thanks a lot for a marvelous post and a all round entertaining blog (I also love the theme/design), I don’t have time to read it all at the moment but I have saved it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the fantastic job.

    Permalink
  31. There are some interesting closing dates on this article but I don’t know if I see all of them center to heart. There is some validity however I will take maintain opinion until I look into it further. Good article , thanks and we want extra! Added to FeedBurner as properly

    Permalink

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>