About: Pavan Kristipati

pavan_kristipati_200px

My name is Pavan Kristipati.  Currently, I work as a Database Administrator / Technical Specialist for a regional Banking/Finance company in Columbus, OH since May 2010. In my current role, I manage and support an Enterprise Data Warehouse (EDW) on DB2 LUW DPF (Database Partitioning Feature) and Highly Available (24/7) OLTP (DB2  / HADR) applications. I am an IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, UNIX and Windows.

I love sharing complex architectures / ideas in simple words / pictures. I have a tendency to put abstract topics/ideas in pictures/figures for better visualization. Writing UNIX scripts to simplify and to automate my daily work-life is something that I do on a regular basis. Driving database solutions to business problems and seeing them solve a challenge is something that I enjoy in my work-life. I love working with people and prefer  human interaction in a room over online meetings.. 🙂

In February 2014, I started to write this blog to share few ideas/concepts/challenges in DB2 LUW administration  / development that I have either worked on / currently working on. I consider myself eclectic and technophile. I love to read books. I often start to watch a movie but would take 2-3 sittings (days) to finish watching. I sign up for online courses and I love to stay cutting edge. I consider Coursera, Udacity to be a blessing to everyone. I usually work out 2-3 times a week… So, that is about me.

 Thanks for stopping by and knowing about me.

Here is my LinkedIn profile if you want to stay connected or if you want to drop me a message: www.linkedin.com/in/pavankristipati/

If you want to drop me an email, my email id is pavan @db2talk.com (no space before @)

Advertisements

4 thoughts on “About: Pavan Kristipati

  1. Praveen,, It’s my pleasure to read your db2 blog. I enjoyed it. I have recently switched over my career to db2 luw. I hope I can keep moving forward with help of people like you. Pls keep up your good work for people like me. Thx

    ~ Tony

    • Tony,
      Happy to know that you are enjoying content on db2talk.com. I appreciate you taking time to comment.
      If you would like, please suggest few topics that you would like to see covered on db2talk. I would make an attempt to blog about them.
      Thanks and Best Regards.
      Pavan Kristipati.

  2. Hello Pavan,

    I have a question,can we convert DPF database into a non-DPF database,if so what would be the easiest way to do that.

    • Hello Sekhar,
      I am not aware of an easy way to “convert” a DPF database into a non-DPF database.
      Couple of ways I would approach this are:
      1) Create a new database on a different server, create database objects, use load from cursor to load data. One quick you might have is what to do with the ‘distribute by hash’ syntax in table creations. I don’t think there is a real need to get rid of this syntax in tables’ DDL as any ‘distribute by hash…’ statement will simply be ignored in a single partitioned database. I have migrated ~10 TB DPF database using this method.
      2) If there is no option to stand up a different server, create a new single partitioned database on the catalog/admin node or one of the other nodes. Use the above approach to copy data.

      One thing to remember when you use load utility is that the data on source (dpf) might change when the load process is under way. You would have to have source database in an offline state or have to be absolutely sure that the source data is static. Some data warehouses have semi-static data. In those cases, it could be possible to copy (load) data in chunks. To copy the last chunk of data, you would have to take the database down to avoid data from changing.

      Hope this helps. Feel free to follow-up with additional questions. As always, please use my suggestions/input with caution as I am not aware of your operating work environment.
      on on one of the database servers (in the DPF database)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s