Namastey Hyderabad !
Posted by: apuna on: June 22, 2009
Sunday 21/06/2009 11:00AM
I am here finally back to writing, after a long break, let me check when was my last post.. 20 days short of an year that i visited this page ha !! its not too much, but yes i was little busy, a lot happens in a year, i fell sick during november, got admitted into hospital, circuitcity(my previous account) got bankrupted(its back now operating with online stores though), m0ved into a different account in work where i joined a team of almost 20 dba’s (thats a great change for me, to be part of a team, as i used to work alone in all of my previous assignments. It was really weird in the beginning, first 10 to 15 days to go to office daily and to communicate with so many people!! but now I’ve become quite comfortable with everyone in the team, who would have known that i am funny with people around !!:) ) I vacated the room in bangalore where i was staying with our graduate friends from past 18 months or so, got a break for myself from my bestfriend, Changed into a new 2bhk flat together with Arun and now here i am in the city of nawab’s to provide training in db.
well, the training schedule is for 3 weeks and i have only one week of stay to go here in hyderabad.. practically in the 2 weeks that i have passed, i have not been to any place apart from shuttling between guesthouse n office in hitec city. There isn’t any time to roam around during weekdays, i had to provide training from 3pm to 9pm IST and then had to attend to my account work rest of the night. After the first week of training, i had to go back to bangalore and by the end of 3rd week friday, night i would start from here, so this is the only weekend (or only sunday, since i have slept thru saturday and killed entire day until night, when i met up with another colleague and his friend for dinner and drinks ) i have got to feel hyderabad.. well so i have decided to go out now and then continue this post after the day is over (saved the post as draft 
)
Monday 22/06/2009 03:41AM
Continuing from above..
All about Training
Okay, Sunday is over. And i am back in guesthouse trying to finish this post. so let me start with obvious things.. I have managed to complete db2 training for 2 batches, that said i barely managed to cover all topics in db2. People who attended the training are supporting SAP on oracle and since they are expecting migrations from oracle to db2 on most of their servers, they desperately wanted to get hands on db2. So was i told, but then i came to know that on the first day in training that management perspective on the idea of this sessions is totally different. According to them, people attending the sessions have already gone through an initial training on db2 (to me most of them doesnt seem like they had initial training) and these sessions i provide are suppose to teach them advanced troubleshooting and prepare them to start working on db2.. The management here expected people to do their certifications in db2, after listening to one week of classes! which i think is too much pressure on them and yes on me too.. I felt they were being pushy, but then its their decision and I am no one to judge it, all I want to do is to try and share the most with them and make them atleast comfortable with db2. Ah!! Enough of this crazy prologue to the training.
Alright, let me tell you what these sessions meant to me. I always secretly thought about teaching, I even imagine /day dream sometimes myself standing infront of a class and presenting something innovative to think about. So obviously, when my previous manager asked me to take this job, i didnt think much. Before these sessions, i had an opportunity when i joined my company in bangalore to train a batch of freshers, who were junior to me. (since i wasnt allocated to any project at that time, they had assigned me and 3 more people to take sessions to fresh guys, and based on positive feedback from those sessions I was later assigned to a project (Britannia)! which turned out to be a great experience for me) And even though I am a shy person if you dont know me, and had my own fears about public speaking, I did give myself into it once i started saying something about db2. Part of the reason must be that i like db2 so much that i forget about the fear of facing people, whatever the reason is these sessions are great experience to me and helped me a lot to overcome stage fear to considerable extent. At this point, i remember an embarassing incident from my engineering days, during final semister, when i went up the stage for the first time ever in my life to present my seminar on Wi-Fi technology infront of my class and lecturers in my department. I can still remember how big a disaster it was, I had prepared so much on the topic, and all i managed to say was just to read out the headings of the contents i wrote down!! While words were stuck in my throat as i was standing on the stage, i still remember i couldnt recognize any face in my class.. I was not staring at anyone of them, my mind was just blank.. Finally i just came down from the stage, somehow managing to give an end to that jarring incident. Now all that has changed i suppose, thanks to these sessions. I have to thank so many of them at my workplace for this, coz directly or indirectly they are responsible for the changes in me.
Having said all of that, Now I have come to a decision that my thirst for teaching has been quenched enough due to the 2 weeks of training !! one would think, what happened all of a sudden.. well let me explain, 5 to 6 hours of standing and talking everyday, then the most important one is to go through the same stuff for the next batch of guys in the 2nd week !! God, i hate to repeat the same things, that too coming back to the same point within a span of one week, and I get irritated by the fact that i have one more week to go through all of them again!!! I would definitely be relieved by the end of next friday. Now I realize, how tough it is to teach the same text books year after year for the new set of kids!! Without those patient teachers, we would be lost. Imagine what would happen if nobody wants to teach and mentor anymore!! I bow to All Teachers and Guru’s who take pleasure in guiding the children and prepare them to face the world. I have got kinda bored due to this repeatitive classes and i have decided not to take up such assignments for sometime. I would be better off just doing my work, rather than getting tired and bored on something that i am not even being paid for..
Hyderabadi Biryani and its after effects !
Okay, I was definitely excited to comeback to the city. This is the capital of my native state, so why wouldnt I be excited? but i have to say that i am not very much impressed with some things here. Let me start with the things that i didn’t like. First of all, Language. I mean one would expect to talk or communicate in regional language telugu when they visit hyderabad!! which is not true at all. And i for one was expecting to speak in telugu when i land here. As its the place ruled by Nawab’s, its natural that most of them here speaks Hindi rather than telugu !! But thats not all, people who doesnt know any other language but telugu, and who come and settle here also tend to pickup hyderabadi hindi very soon.. I have to say that, i am disappointed in speaking nothing but hindi through out my stay. It feels like i am not in andhra at all, what difference is there in bangalore n hyderabad then, atleast in bangalore i speak kannada if i want to catch an auto.. And the accent of people here when they speak hindi or telugu is different, telugu obviously comes out in telangana Yaasa. Blame me for expecting to speak in telugu in hyderabad. Then the next one on the list is traffic sense of the people. I agree that Bangalore traffic is far more worse due to their limited infrastructure, but hyderabad has got huge space, there are abundant free spaces between offices, houses here, something not possible in bangalore. But yet, traffic police are less effective in hyderabad. I noticed that, people just havent yet developed the sense of personal responsibility here. They drive and jump signals, as and when they want, and i think nobody even thinks about the traffic discipline!! When you go to any malls, forget about queue, hyderabidi doesnt stand in a queue, he is a king, he just pushes and goes forward. And then one more important and obvious thing i couldnt help to hate, is Climate.. it just takes 5 minutes in auto from my guesthouse to reach office, and after that 5 minutes, I would get down auto as a 5 foot 8 inch walking roasted chicken!! And when i mention about the hot weather to one of the fellow colleague, He calmly said, its just tip of the iceberg, and there isnt much heat now since summer is about to complete !! THank Heavens I have not faced the wrath of sun god.. So i have decided that, I would relocate to hyderabad, only when i am able to Rent or Buy myself an AC house and AC car to commute here.. otherwise no chance of coming here. I dont want to be a new item in the menu of kentucky’s fried chicken.
Well, coming to good thing about hyderabad, its their FOOD .. Hyderabadi’s loveeeeee Food, not just hyderabadi’s, all andhra people love Food i think.. The canteen in the company itself holds a variety of items, i had chance to have bonda’s, dosa’s, chats, biryani in the company canteen itself!! Which is impossible in Bangalore.. they just shell out a puff and a juice and charge you a cool amount for that in bangalore:). Instead people in hyderabad demand good food i think, and the quantity of food they serve, as correctly noted by my good friend murthy is also far more compared to other cities. And then there is famous Hyderabad Biryani, which is a brand in itself wherever you go. Also, the Rates of Cinema halls, Multiplexes is less compared to bangalore!! cant help noticing that fact, being a frequent visitor to movies.. And the recreation places inside the city are far better compared to bangalore. In Bangalore, its just malls and shopping and hanging out at cafe coffee days, it becomes little boring after sometime. You have to venture out of bangalore city now and then to escape from the city walls closing in on you!! But thats not the case with Hyderabad, It has huge space, so many places you can visit without putting a hole in your pockets, and where you can have very good time. This city has its identity, whatever it is, It has nativity.. THat is i think something that is not so much visible in Bangalore, due to the fact that it has become mixed up with many people coming from many parts of the country.. And thats exactly what i Love about bangalore too.. it is a cosmopolitan city. (I love to see people from different cultures n different places come and adjust with each other at one place, that tolerance towards other human beings no matter where they are from, and what they do is what i love most)
Sunday Superbrunch – Cartoons, Movies, Gaming
Hmm.. I dont know what i am rambling about here, just going on saying some stupid stuff about what i feel about hyderabad. okay, let me quickly finish this post by taking you through what i did on sunday.
Before i started writing this post and saving it as a draft, i started the sunday like any day with browsing the channels of movies n cartoons on tv as soon as getup. There it was, on cartoon network, continuous episodes of ben10 alien force, and i started watching it without looking at time.. Oh boy, how much i love cartoons!!!, i would have to definitely write a post on Cartoons separately. So around 1pm, i started from guesthouse, and reached prasadz (thats the only multiplex i have visited in hyderabad). Had a mcchicken meal, and went to movie counter. I didnt had plan to go to movie, I actually went there to spend sometime playing video games, but then at 2:30pm, there was a show for Prayanam movie, so i took it, then spent my time in the gaming zone of prasadz.. Meanwhile, I called my colleague and we decided to go to XMen-origins in IMax-Bigscreen for 10:45pm show. So i had to go for a movie to kill time till night, i dont wanted to come back to guesthouse.. so i took prayanam tickets. That movie is a decent one, though comedy didnt work greatly for me, and i did feel little bored at times, it did had you guessing about what would happen next.. its good to see that, directors are now atleast considering psychology when writing their scripts. There is a character in the movie who is psychology student and starts saying about how people would react, although all the things that he would say are again Filmi style.. atleast its a starting point, where people may try to see the character beneath our skin. And i didnt like the characters of hero or heroine either, they are unreasonable, as in any telugu love story. By the end of the story, director has to show happy endings in such a fantasy love stories.. But what happens after they get together..no one tries to show that, No one lives happily ever after!! And our moviegoers eat anything that they are fed.. so they should be fine i think.. I would sincerely hope, our directors can do much better than this, not just show hero n heroine, but dwelve into their psyche, and explore and present their characters infront of audiences rather than showing the things by their facevalue.. okay anyway, after the prayanam movie at 5:30pm, i came out of prasadz and went to Lumbini park, played net-cricket for a while, and boarded onto boat that took me to the buddha statue in between hussain sagar lake. This is the first time, i have seen this 70feet buddha statue upclose. Then came back to Prasadz multiplex around 7pm, and again went to gamingzone(more funtime).. then while looking around in Prasadz, i came through certain store called “Ludu’s “.. Thats one fantastic theme store, Loved it totally, they have PS3, XBOX 360, and Nintendo WII consoles and games you can play on a 50 inch flatscreens, and they have a restaurant opening soon with home theatres in the coffee shop!!! They charge you 40 bucks for 15minutes of gameplay.. I played NFS and Tennis on Xbox n Wii respectively, on a 70 inch LCD. Also their main theme is about intelligent gaming for children, what they call it as edutainment, they have games with building blocks, and puzzles which would improve creativity in a child. And they have membership options too, with which you get around 200 hours of free gaming!!:) That’s a Fantastic store, and i would definitely visit it when i come back to hyderabad in August for Ram’s sister marraige. Then I had my dinner at Ohri’s food court in prasadz, amazingly they had variety of combo’s in their menu. I never had food at Ohri’s chain before. After dinner, it was time to pay a visit to Hugh Jackman, and i didnt like the movie much, it could have been much better, but any fan of X-men or woulverine character can sit through the movie i guess. I didnt regret watching the movie in bigscreen.. So that was it. That ended my sunday and experience in hyderabad. I came back to my guesthouse at 1am Monday. Its time to sleep. Gotto go, another week, another monday, another post.. till then …
Life & Death
Posted by: apuna on: July 10, 2008
Recently, One of my friend remebered this
” The tragedy of life is not death,but what we let die inside of us while we live “
how true !!! infact, i got this thought that death may not be a tragedy at all !! It might just be a transit from our limited consciousness to a universal consciousness.. now whats an universal consciousness !! Lets talk a little about our Limited Consciousness first. Imagine this, as a living person till the end of our lifetime, how many people we can come across ? may be 300 or 500.. obviously we cant remember that many names also at any given point of time. Our world, Our Brain, Our Body function only when our consciousness is LIMITED.. We live in a narrow world, surrounded by very few people through out our lifetime compared to the world we have.. A guy or his name, who is living in japan/US doesnt make sense to us (our brain), since he is not part of our Conscious world, that each one of us have built around us.
This is all well known for all of us, i am just re-iterating it. Now whats the Universal Consciousness could be ??? Imagine you sitting in one part of world, can sense and feel what george bush is doing in his white house, or What a small creature in one of the oceans is doing right now.. and so on how would it be if you can sense everything in this whole world ? whats going on in space ? whats going in far far galaxies ? Imagine a Consciousness which is part of everything and which is everything.. Ofcourse i am speaking about GOD. So how would it be ? being part of such consciousness which is Universal ?
We cant feel a thing or express anything then, Coz we all are ONE then.. there is no you and no me. In such case, We would loose our individual consciousness, and be part of a greater thing.. How can you express something to yourself which you are already part of ? Wouldn’t Death be something like that ?? Why not ?? I or anyone can’t tell you how it would be, coz we have not experienced it. But we can definitely try to imagine it.. We can imagine anything, isnt it ? Why not imagine After Death to be beautiful then ? Afterall, who knows !! It might definitely be more than beautiful, more than anything we experienced. Only that You won’t be able to Express how it would feel, coz you would have lost your INDIVIDUAL & LIMITED Consciousness and gained a HIGHER Consciousness.
Well, by the end of the day what difference it makes to us right now ?? What difference it makes, by whatever we imagaine about death/after death to be beautiful than Life?? Truly speaking NOTHING. All we can do is to TRY AND KEEP WHAT’S INSIDE US AND WHAT’S SURROUNDING US ALIVE TILL WE DIE.. You know What i mean !!!
Act of Life !!
Posted by: apuna on: June 18, 2008
What an Act is Life …
I suppose we all act every now & then in our lives, sometimes consciously and unconsciously at other times. We put on these beautiful plays infront of other human beings, that it (acting) has subconsciously become part of our life.
We put up these faces, these roles everyday to get something done or to please others or whatever the reason might be.. the reason itself is not important, whats important is that we act perfectly when the time demands, We cry, We laugh, We blame, We do lot many other things that academy award winners can only imagine to do. I guess these acts are part of our sub-conscious brain that, we dont even realize any more that we are acting.. it becomes a habit.
Everyone will act.. A child may act to get his toy or chocolate from his/her mother. A student may act to escape from his/her superiors or parents to get away with his low grades in studies, A husband may act before his wife, and a wife before her spouse to get things what she needs.
Sometimes I feel like surrounded by all these puppets, people who are constantly acting out to get along with their lives… And at times, I become one of them. And perhaps, we act to conform to the strings of society, such as Culture, Religion, Sex, Fame, Money.. i’m not getting perfect picture here though.. what i see is that people hanging onto these strings until they die..
What A splendid Act we put up by the end of the day.
What An Act is Life …
P.S:- Its dramatic and load of shitt, i know, still i did kind of liked when i got the thought.. so there goes the crap above..
WALL-E Widget
Posted by: apuna on: May 26, 2008
My resolution for 2008
Posted by: apuna on: January 3, 2008
My Resolution for this Year – 1024 by 768 pixels !!!!!! he hee
Friends
Posted by: apuna on: August 9, 2007
Wow.. without them this life would be so awful to live !! I dont want to say how great friendship is and how beautiful friends are ( opposite sex ones especially!! ), because everyone knows that…its an obvious fact. But i really wonder what gene is responsible for us to feel such an beautiful feeling about other people. This feeling which is so JOYFUL, HAPPY and Amazing only happens when we are with Friends. LOVE, yes i agree that is something which can defy anything, But Only Friendship is the only bond that is much needed and equals love on all levels or may be surpasses love. I mean you love, and you get pain at some point of time. But Friendship, all it offers in its true form is Happiness. I couldnt imagine or for the matter no one can ever imagine not having a friend who is so close to heart, who makes you smile when you think about him/her. There will be lots of friends who make you feel like that.. if there are you are luckiest one..you can go ahead and give your girlfriend my number !! i know totally inappropriate. Ok anyhow, what can i write about the people with whom we spend most of our life with !! with whom we share the most memorable moments in our life, without which our life would become as tasteless as the coffee that comeout of Vending machines in coorporate offices :). without them life would be like watching daily serials in local channels for 60 years, without them life suckssssssss.. So My DEAR FRIENDS.. This is to all those people that surround us and make our life worth living every day until we die.. I LOVE YOU ALL. HAPPY FRIENDSHIP DAY.
So no one told you life was gonna be
this way *clap*clap*clap*
Your jobs a joke, you’re broke,
your love life’s D.O.A.
*clap*clap*clap* ( How much true, anyday when you are broke, your friend is there with you to say its alright )
It’s like you’re always stuck in second gear
When it hasn’t been your day,
your week, your month,
or even your year
but..
I’ll be there for you
When the rain starts to pour
I’ll be there for you
Like I’ve been there before
I’ll be there for you
Coz you’re there for me too…
You’re still in bed at ten and
work began at eight
*clap*clap*clap*
You’ve burned your breakfast so
far… things are goin’ great
*clap*clap*clap*
Your mother warned you
there’d be days like these
Oh but she didn’t tell you when
the world has brought
You down to your knees that… (Each one of us should go through the hardships life will put us into, parents cant help you in that, but a friend can )
I’ll be there for you
When the rain starts to pour
I’ll be there for you
Like I’ve been there before
I’ll be there for you
‘Cuz you’re there for me too…
No one could ever know me
No one could ever see me
Seems you’re the only one who knows
What it’s like to be me
Someone to face the day with
Make it through all the rest with
Someone I’ll always laugh with
Even at my worst I’m best with you, yeah ( Now this is the true meaning of what friendship is, only a friend can know more about you than you know yourself, and definitely when with friends we are Almighty in our own respect)
It’s like you’re always stuck in second gear
And it hasn’t been your day,
your week, your month,
or even your year…
I’ll be there for you
When the rain starts to pour
I’ll be there for you
Like I’ve been there before
I’ll be there for you
Coz you’re there for me too…
I’ll be there for you
I’ll be there for you
I’ll be there for you
Coz you’re there for me too…
Thankyou People for being there..
Good one about love
Posted by: apuna on: January 31, 2007
An interesting excerpt from someothers blog…
link is here http://luvzlabourzneverlost.blogspot.com/
LOVE’S LABOUR IS NEVER LOST
My husband is an engineer by profession, I love him for his steady nature, and I love the warm feeling when I lean against his broad shoulders.
Three years of courtship and now, two years into marriage, I would have to admit, that I am getting tired of it. The reasons for me loving him before have now transformed into the cause of all my restlessness. I am a sentimental woman and extremely sensitive when it comes to a relationship and my feelings. I yearn for the romantic moments, like a little girl yearning for candy. My husband is my complete opposite, his lack of sensitivity, and the inability of bringing romantic moments into our marriage has disheartened me about love.
One day,I finally decided to tell him my decision,that I wanted a divorce.”Why?” he asked, shocked. “I am tired, there are no reasons for everything in the world!” I answered.
He kept silent the whole night, seemed to be in deep thought with a lighted cigarette at all times. My feeling of disappointment only increased. Here was a man who can’t even express his predicament, what else can I hope from him? Finally he asked me: what can I do to change your mind?
somebody said it right: it’s hard to change a person’s personality, and I guess, I have started losing faith in him. Looking deep into his eyes I slowly answered: Here is the question. If you can answer and convince my heart, I will change my mind– Let’s say, I want a flower located on the face of a mountain cliff, and we both are sure that picking the flower will cause your death. Will you do it for me? He said: I will give you your answer tomorrow.. My hopes just sank by listening to his response.
I woke up the next morning to find him gone, and saw a piece of paper with his scratchy handwriting, underneath a milk glass, on the dining table near the front door.
The note read: ” My dear, I would not pick that flower for you, but please allow me to explain the resons further.” This first line was already breaking my heart. I continued reading…” When you use the computer, you always mess up the software programs, and you cry infront of the screen. I have to save my fingers so that I can help to restore those programs and wipe off your tears.
You always leave the house keys behind, so I have to save my legs to rush home to open the door for you. You love travelling but always lose your way in a new city, I have to save my eyes to show you the way. You always have the cramps whenever your ‘good friend’ approaches everymonth, I have to save my palms so that I can calm the cramps in your tummy. You like to stay indoors, and I worry that you will be infected by infantile autism. I have to save my mouth to tell you jokes and stories to cure your boredom. You always stare at the computer, and that will do nothing good for your eyes, I have to save my eyes so that when we grow old, I can help to clip your nails, and help to remove those annoying white hairs.
So I can also hold your hand while strolling down the beach, as you enjoy the sunshine and the beautiful sand… and tell you the colour of flowers, just like the colour of the glow on your face…
So, My dear, unless I am sure that there is someone who loves you more than I do, I could not pick that flower yet, and die…”
My tears dropped on the letter, and blurred the ink of his handwriting. I continued reading… “Now, that you have finished reading my answer, if you are satisfied, please open the front door for I am standing outside, like everyday, with your favourite bread and fresh milk.” I rush to pull open the door, and saw his anxious face, clutching tightly with his hands, the milk bottle and loaf of bread. Now I am very sure that no one will ever love me as much as he does, and I have decided to leave the flower alone. That’s life, and love. When one is surrounded by love, the feeling of excitement fades away, and one tends to ignore the true love that lies in between the peace and dullness.
Love shows up in all forms, even very small and cheeky forms. It has never been a model, it could be the dullest and boring form. Flowers and romantic moments are only used and appear on the surface of the relationship. Under all this, the pillar of true love stands. And that’s reason enough to live.
Akira
Posted by: apuna on: January 19, 2007
Akira – Cartoon Movie ( 1988)
I strongly recommend this to everyone who likes cartoons and sci-fi and action. I watched it when i was a kid, may be in 7thclass i dont remember exactly but till now i remember the most of the scenes from the movie, that was the impact it had in those days. Memories were almost fading, so i decided to watch it again yesterday night. Its intriguing story and the direction makes you totally absorbed into it. Right from the starting scene you will feel the thru st and you will grow more and more desperate to seehow its going to end. And after sometime you will forget you are actually watching a cartoon movie. Somehow I feel we wont take cartoons so seriously, coz back in our mind we know they are not human and every minute our brain sends a signal saying that they are just for entertainment, fun or just to make us laugh. what i want to say, its tough to get connected with cartoons coz its not the humans acting before us, or we know there is no life in the characters and since we have this prenotion in our mind, its hard to feel for the cartoons the way we feel when we watch the regular movies. But as i said earlier, this one is different, you just get lost in this. You wonder about the AKIRA- the energy that resides in every living being when Kei speaks about it, and the ability within everyone of us to realize its strength and to choose how to use it. you can understand Tetsuo’s arrogance, his desperatness to prove that he doesnt need any help, and how this desperatness transforms into hatred for Kanedaa.. You admire the perservance of Kaneda, his caring for Tetsuo and then his Will to stop him and then his revenge to kill him through out the story. You can feel Scientists urge to discover the bigger truths that no one of us had ever known, their search for Akira, for Universe. You can feel the Power of Tetsuo when he destroys the Colnel’s army with the superb background music. Its pure brilliance how the director Brings NEO-TOKYO to Life. His way of narrating the story, the Political and Social Unrest after the WorldWarIII in Neo-Tokyo. At the end you will feel ” Did i watch a cartoon film until now !!!!!!!! ” And some scenes when you see the colnel entering the Underground facility the director gives every detail of the doors and the locks to enter the chamber, and after that when Tetsuo arrives at the same place, you release why he showed that in so much detail. All these things are so brilliant that this movie will stay in your memories for long long time…
Now i can see why i loved it when i was a kid….
Db2 on SAP
Posted by: apuna on: January 18, 2007
SAP is the application which i am working with right now. So let me give an eagle view of DB2 on SAP.
SAP is one hell of a package, it is nice to work with and simplifies all the Commands that we issue in DB2 into simple Transaction codes. SAP has its own customized tablespaces, bufferpools, tables, which it will create during the Installation of the software. As we know db2 creates 3 tablespaces in the beginning to work for, one SYSCATSPACE, one USERSPACE1, and one TEMPSPACE. While installing SAP, it makes lot of changes in the DB2. Basically in SAP, for every Instance an Unique Systemidentifier will be given, which they call as SID. While installing, SAP creates an instance named as DB2<SID>, it creates users with sysadm and sysctrl privileges with userids db2sid and sidadm. SID can be anything that is specified by us, i.e for a production system we can give SID as PRD. In that case, the instance name would be db2prd and users db2prd and prdadm will be created. Also it will drop Userspace and tempspace and creates its own customized tablespaces. Based upon the installation you are performing (i.e whether you are installing r3 or B.W or ICH or APO e.t.c these are few names of the modules in SAP ) tablespaces with customized tables will be created. For eg:- in R3 system most of the data will be stored in PSAPBTABD tablespace, likewise for a B.W system the data will go into PSAPFACTD, PSAPODSD, PSAPDIMI tablespaces.
Tablespaces in a R3 system
TBSPACE
————————–
PSAPBTABD
PSAPBTABI
PSAPCLUD
PSAPCLUI
PSAPDDICD
PSAPDDICI
PSAPDIMD
PSAPDIMI
PSAPDOCUD
PSAPDOCUI
PSAPEL31GI
PSAPEL46BD
PSAPEL46BI
PSAPEL640D
PSAPES31GI
PSAPES46BD
PSAPES46BI
PSAPES640D
PSAPFACTD
PSAPFACTI
PSAPLOADD
PSAPLOADI
PSAPODSD
PSAPODSI
PSAPPOOLD
PSAPPOOLI
PSAPPROTD
PSAPPROTI
PSAPSOURCED
PSAPSOURCEI
PSAPSTABD
PSAPSTABI
PSAPTEMP
PSAPUSER1D
PSAPUSER1I
SYSCATSPACE
SYSTOOLSPACE
SYSTOOLSTMPSPACE
38 record(s) selected.
Also SAP will set the registry variables of DB2, in newer versions SAP WORKLOAD knob is available. That is registry variables DB2_WORKLOAD is set to SAP which automatically influences other registry variables to be set according to SAP.
Then there is the physical layout of the tablespaces and containers. Naming convention used by SAP to store the datafiles or containers is
/db2/SID/sapdataN in unix where N is an integer can be from 1 to 10
C:\db2\SID\sapdataN in windows where the drive ‘C’ is not mandatory, anydrive can be specified which has enough space.
As far logs are considered, SAP identifies the logs in the directory /db2/SID/log_dir/SID. So after installing we should create a symbolic link from the usual Log Directory i.e /db2/SID/db2SID/NODE0000/SQL00001/SQLOGDIR/ to the /db2/SID/log_dir/SID, so that all logs will be transferred to the new location and stored there from now on. So all active logs can be found at the path /db2/SID/log_dir/SID
Similarly folders /db2/SID/log_archive/SID and /db2/SID/log_retrieve/SID are used for the archiving and retrieving purposes. After the SAP is installed, the Database with name SID is created. And this database would be in Circular Logging Mode. One has to turn on Logretain On and Userexit On and take a backup to change it to Archival Logging mode. Then the Logs will start archiving to /db2/SID/log_archive/SID once they get offline. For that to happen SAP supplies a Customized Admin Tools which sets the environment variables in the .Profile file as follows :-
setenv DB2DB6_ARCHIVE_PATH /db2/DVL/log_archive # used for ARCHIVE
setenv DB2DB6_RETRIEVE_PATH /db2/DVL/log_retrieve # used for RETRIEVE
This Admin Tools has to be downloaded from SAP service marketplace and has to installed using the command sddb6ins..you can search for db2udb admintools in the service marketplace to find the procedure to install admin tools. while installing the admin tools we can specify to create a Admindatabase or not to create it. If we choose to create it, one more database named as ADMSID will be created in the local database directory. you can see two databases if you list the database directory as below :-
System Database Directory
Number of entries in the directory = 3
Database 1 entry:
Database alias = PRD
Database name = PRD
Local database directory = /db2/PRD
Database release level = a.00
Comment = SAP R3 database PRD
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 2 entry:
Database alias = ADMPRD
Database name = ADMPRD
Local database directory = /db2/PRD
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
And the Dump files are stored in /db2/SID/db2dump directory.
An example of physical layout of SAP on Unix system is given below :-
/dev/log_dirlv 9.00 7.75 14% 26 1% /db2/DVL/log_dir
/dev/trans_lv 27.50 26.25 5% 20603 1% /usr/sap/trans
/dev/lv_datavg1 15.00 4.00 74% 17 1% /db2/DVL/sapdata1
/dev/lv_datavg2 20.00 4.59 78% 20 1% /db2/DVL/sapdata2
/dev/lv_datavg3 19.00 3.94 80% 21 1% /db2/DVL/sapdata3
/dev/lv_datavg4 18.00 4.53 75% 18 1% /db2/DVL/sapdata4
/dev/lv_datavg5 27.50 10.92 61% 19 1% /db2/DVL/sapdata5
/dev/lv_sapdata6 14.00 2.01 86% 16 1% /db2/DVL/sapdata6
/dev/lv_sapdata7 13.00 3.95 70% 14 1% /db2/DVL/sapdata7
/dev/put_lv 4.00 1.07 74% 4365 2% /usr/sap/put
/dev/db2dump 15.00 14.90 1% 30 1% /db2/DVL/db2dump
/dev/log_retrieve 5.00 5.00 1% 5 1% /db2/DVL/log_retrieve
/dev/log_archive 26.00 14.23 46% 236 1% /db2/DVL/log_archive
/dev/sapmnt 5.00 4.02 20% 80279 8% /sapmnt
/dev/sapdatat 5.00 5.00 1% 8 1% /db2/DVL/sapdatat
So this is the basic setup that of DB2 on SAP.
signing off for now…
siva
Chris Cornell – You know My Name
Posted by: apuna on: January 9, 2007
- In: DB2
- Leave a Comment
This is definitely one of the best song in the James Bond movies.
Chris Cornell has given his wonderful voice and the beats of the song are truly superb.
Here are the lyrics of the song
Lyrics of the YKMN
If you take a life do you know what you’ll give?
Odds are, you won’t like what it is
When the storm arrives, would you be seen with me?
By the merciless eyes of deceit?
I’ve seen angels fall from blinding heights
But you yourself are nothing so divine
Just next in line
Arm yourself because no-one else here will save you
The odds will betray you
And I will replace you
You can’t deny the prize it may never fulfill you
It longs to kill you
Are you willing to die?
The coldest blood runs through my veins
You know my name
If you come inside things will not be the same
When you return to the night
And if you think you’ve won
You never saw me change
The game that we all been playing
I’ve seen diamonds cut through harder men
Than you yourself
But if you must pretend
You may meet your end
Arm yourself because no-one else here will save you
The odds will betray you
And I will replace you
You can’t deny the prize it may never fulfill you
It longs to kill you
Are you willing to die?
The coldest blood runs through my veins
Try to hide your hand
Forget how to feel
Forget how to feel
Life is gone with just a spin of the wheel
Spin of the wheel
Arm yourself because no-one else here will save you
The odds will betray you
And I will replace you
You can’t deny the prize it may never fulfill you
It longs to kill you
Are you willing to die?
The coldest blood runs through my veins
You know my name
You can listen to the song in the ChrisCornell’s Myspace Page
CHRIS CORNELL’s MYSPACE PAGE—-
