Monday, June 24, 2013

About DB2 Consistency Token(CONTOKEN), DB2 SQL ERROR -805 and -818

What is contoken or consistency token in DB2?
 If we remember during precompilation process, the SQL part and COBOL part  are separated.While doing so, compiler engraves a time stamp to each part, so that later they can identify each other. at run time. This time stamp is what we call Contoken or consistency token
We get SQL code of -818 when the Consistency Token placed by DB2 precompilation Step  does not match between the DBRM and the Load Module.
80N or -805 is what we get when the DBRM or Package is not found in Plan which we used in JCL.

Steps to find out the contoken and verify if both are same??
STEP1:
We can go to QMF or run the below query
SELECT NAME, HEX(CONTOKEN), BINDTIME,PDSNAME
FROM SYSIBM.SYSPACKAGE WHERE
NAME='PORGRAM-NAME'
ORDER BY BINDTIME DESC

 
We fetch the HEX value for the contoken.Otherwise we wont be able to see the value,if fetched normally.
This Fetches the program-name, its contoken, bind time and the DBRM Library order by latest bind time.

 


we can get the same Contoken (with out using the above query also) by looking into the DBRM library for the program.
Open the DBRM Library and give the command HEX ON
Position of contoken in DBRMLIB
Look for 25 to 32nd position in the first line. That will show the contoken.

 






Next Step 2:
Remember the Date and Time part of Contoken are swapped in Loadlib, you need to split the above contoken into two halves of 8 characters each and swap their positions like below:
Taking the above example, contokens are
1st Half : 18DAE169
2nd Half: 1F0420A5

Swapping and joining them results in
1F0420A518DAE169

Now go to the LOAD MODULE library and search for it like
 f x'1F0420A518DAE169'


 You should be able to see this. Else There is a contoken mismatch.Rebind again or recompile to get rid of this freaking problem. -:)
Note:  F x 'search-string' . Here x implies the search string in quotes is hex value.

Thanks!

22 comments:

  1. Having 10+ years exp, I never know how to look for inconsistency in DBRM & Loadlib. Only used to follow the -818 and recompiled/re-binded the package. Appreciate your efforts. May God Bless You.. :-)

    ReplyDelete
    Replies
    1. MRS  BELLA PATNOS, UNITED KINGDOM , LONDON
      Hi Viewers Get your Blank ATM card that works in all ATM machines all over the world. officialhackingcompany@gmail.com have specially programmed ATM cards that can be used to hack ATM machines, the ATM cards can be used to withdraw at the ATM or swipe, at stores and POS, the card has a limit of $ 50,000 on ATM depending on the kind of card you order for, and also if you are in need of any other hack services, contact them via Email: officialhackingcompany@gmail.com

      Delete
  2. Too good. Thanks for informative read.

    ReplyDelete
  3. This is an excellent tip and know-how for a DB2 z/OS programmer Thanks a lot.

    ReplyDelete
  4. Couldn't get better. Your blog is excellent! Helps one make their concepts clear.

    ReplyDelete



  5. INSTEAD OF GETTING A LOAN,, I GOT SOMETHING NEW
    Get $10,050 USD every week, for six months!

    See how it works
    Do you know you can hack into any ATM machine with a hacked ATM card??
    Make up you mind before applying, straight deal...
    Order for a blank ATM card now and get millions within a week!: contact us
    via email address:: besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    We have specially programmed ATM cards that can be use to hack ATM
    machines, the ATM cards can be used to withdraw at the ATM or swipe, at
    stores and POS. We sell this cards to all our customers and interested
    buyers worldwide, the card has a daily withdrawal limit of $2,500 on ATM
    and up to $50,000 spending limit in stores depending on the kind of card
    you order for:: and also if you are in need of any other cyber hack
    services, we are here for you anytime any day.
    Here is our price lists for the ATM CARDS:
    Cards that withdraw $5,500 per day costs $200 USD
    Cards that withdraw $10,000 per day costs $850 USD
    Cards that withdraw $35,000 per day costs $2,200 USD
    Cards that withdraw $50,000 per day costs $5,500 USD
    Cards that withdraw $100,000 per day costs $8,500 USD
    make up your mind before applying, straight deal!!!

    The price include shipping fees and charges, order now: contact us via
    email address::besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    ReplyDelete
  6. Are you in a financial crisis, looking for money to start your own business or to pay your bills?
    GET YOUR BLANK ATM CREDIT CARD AT AFFORDABLE PRICE*
    We sell this cards to all our customers and interested buyers
    worldwide,Tho card has a daily withdrawal limit of $5000 and up to $50,000
    spending limit in stores and unlimited on POS.

    YOU CAN ALSO MAKE BINARY INVESTMENTS WITH LITTLE AS $500 AND GET $10,000 JUST IN SEVEN DAYS

    **WHAT WE OFFER** 

    *1)WESTERN UNION TRANSFERS/MONEY GRAM TRANSFER*
    *2)BANKS LOGINS*
    *3)BANKS TRANSFERS*
    *4)CRYPTO CURRENCY MINNING*
    *5)BUYING OF GIFT CARDS*
    *6)LOADING OF ACCOUNTS*
    *7)WALMART TRANSFERS*
    *8)BITCOIN INVESTMENTS*
    *9)REMOVING OF NAME FROM DEBIT RECORD AND CRIMINAL RECORD*
    *10)BANK HACKING*
    **email blankatmmasterusa@gmail.com *
    **you can also call or whatsapp us Contact us today for more enlightenment *
    *+1(539) 888-2243*
    **BEWARE OF SCAMMERS AND FAKE HACKERS IMPERSONATING US BUT THEY ARE NOT
    FROM *
    *US CONTACT US ONLY VIA THIS CONTACT **
    *WE ARE REAL AND LEGIT...........2019 FUNDS/FORGET ABOUT GETTING A LOAN..*

    IT HAS BEEN TESTED AND TRUSTED

    ReplyDelete
  7. I want to share my testimony on how i got the blank ATM card. I was so wrecked that my company fired me simply because i did not obliged to their terms, so they hacked into my system and phone and makes it so difficult to get any other job, i did all i could but things kept getting worse by the day that i couldn’t afford my 3 kids fees and pay my bills. I owe so many people trying to borrow money to survive because my old company couldn’t allow me get another job and they did all they could to destroy my life just for declining to be among their evil deeds. haven’t given up i kept searching for job online when i came across the testimony of a lady called Judith regarding how she got the blank ATM card. Due to my present state, i had to get in touch with Hacker called OSCAR WHITE of oscarwhitehackersworld@gmail.com and he told me the procedures and along with the terms which i agreed to abide and i was told that the Blank card will be deliver to me without any further delay and i hold on to his words and to my greatest surprise, i received an ATM card worth $4.5 million USD , All Thanks to OSCAR WHITE , if you are facing any financial problem contact him asap email address is oscarwhitehackersworld@gmail.com or whats-app +1(323)-362-2310

    ReplyDelete
  8. Need a Debt Loan To Pay Off Bills?
    Take control of your debt today
    Available Now Business Expansion Loan Offer?
    Do you need a loan to pay off Bills?
    Do you need a loan?
    Do you need Personal Loan?
    Business Expansion Loan?
    Business Start-up, Education,
    Debt Consolidation Loan
    Hard Money Loans
    Loan for any thing ?
    We offer loan at low interest rate of 3%
    Loan with no credit check,
    Email us: financialserviceoffer876@gmail.com
    Call or add us on what's app +918929509036

    ReplyDelete
  9. MRS  BELLA PATNOS, UNITED KINGDOM , LONDON
    Hi Viewers Get your Blank ATM card that works in all ATM machines all over the world. officialhackingcompany@gmail.com have specially programmed ATM cards that can be used to hack ATM machines, the ATM cards can be used to withdraw at the ATM or swipe, at stores and POS, the card has a limit of $ 50,000 on ATM depending on the kind of card you order for, and also if you are in need of any other hack services, contact them via Email: officialhackingcompany@gmail.com

    ReplyDelete

  10. This card are real i got my card few hours ago and am just coming back from the ATM where i made my first withdraw of $4500, i am going crazy this is fucking real OSCAR WHITE sorry for being so skeptical about it at first don’t blame me the street these days got fucked up lots of scammers and now i can recommend whoever needs a blank ATM card with about $50,000,000.00 on it which you can withdraw within a month because the card has a daily limit.if you are facing any financial problem contact him asap email address is oscarwhitehackersworld@gmail.com or whats-app +1(513)-299-8247 as soon as possible .

    ReplyDelete
  11. My name is Mr. Klaus Dieter, I work for the French financial institution Crédit Mutuel with the partnership of the bank BNP Paribas, we offer you offers at an interest rate of 3% per year, to start with new projects:
    - You have unpaid debt.
    - Buying a new house.
    - buy a new car.
    - Buying a new apartment or property.
    Get personal loans, business loans.
    If you would like loans for setting up your business and project, do not hesitate to send us an email:
    bnpfinanzenhilfe@gmail.com

    Whatsapp: +4917694954827

    ReplyDelete
  12. GET RICH WITH BLANK ATM CARD ... Whats-app: +1(209)-643-1515

    I want to testify about Oscar White blank ATM cards which can withdraw money from any ATM machines around the world. I was very poor before and have no job. I saw so many testimony about how Oscar White hackers send them the ATM blank card and use it to collect money in any ATM machine and become rich. ( oscarwhitehackersworld@gmail.com ) I email them also and they sent me the blank ATM card. I have use it to get 75,000 dollars. withdraw the maximum of 4,500 USD daily. Oscar White is giving out the card just to help the poor. Hack and take money directly from any ATM machine vault with the use of ATM programmed card which runs in automatic mode.
    Email:oscarwhitehackersworld@gmail.com
    Text & Call or Whats-app: +1(209)-643-1515

    ReplyDelete
  13. GET RICH WITH THE USE OF BLANK ATM CARD FROM
    (jimleehacker07@gmail.com)
    Has anyone here heard about blank ATM card? An ATM card that allows you to withdraw cash from any ATM machine in the world. No name required, no address required and no bank account required. The ATM card is already programmed to dispense cash from any ATM machine worldwide. I heard about this ATM card online but at first i didn't pay attention to it because everything seems too good to be true, but i was convinced & shocked when my friend at my place of work got the card from guarantee ATM card vendor. We both went to the ATM machine center and confirmed it really works, without delay i gave it a go. Ever since then I’ve been withdrawing $1,500 to $5000 daily from the blank ATM card & this card has really changed my life financially. I just bought an expensive car and am planning to get a house. For those interested in making quick money should contact them on: Email address : jimleehacker07@gmail.com

    ReplyDelete
  14. Hello,We are a professional Cyber Tech credit team with a large ring around
    the globe infected with more than 3 million debit malware and
    skimmers, we get a blank ATM card and load them with a lot of money
    quickly and safely, with which one can withdraw Cash either in euros or
    Swiss franc from ATM and can be used by any POS system
    Note: Our cards are Illegal but trust me its 100% safe
    Contact: calvin grayson
    Email: officialblankatmservice@gmail.com

    ReplyDelete
  15. Get A Blank ATM CARD And Cash Good Money/Funds Pay Your Debt directly today in any ATM machine around you anywhere in the world. contact oscarwhitehackersworld@gmail.com , It's 100% guaranteed secure with no worries of being caught because the blank card it's already programmed and loaded with good funds in it, in such a way that's not traceable which also have a technique that makes it impossible for the CCTV to detect you, i am not a stupid woman that i will come out to the public and start saying what someone have not done. For more info contact Mr Oscar White and also on how you are going to get your Card, Order yours today via Email: oscarwhitehackersworld@gmail.com ,Text & Call or Whats-app: +1(209)-643-1515

    ReplyDelete
  16. Hello my name is Scott Mcall. I want to use this medium to share to you guys about how my life changed for the better after meeting good hackers, I got $15,000USD while working with them. They are really efficient and reliable, they perform various hack such as.
    BLANK ATM CARD
    PAYPAL HACK TRANSFER
    WESTERN UNION HACK
    MONEY HACK
    BITCOIN INVESTMENT

    Please if you are interested in any of this, contact them via Jaxononlinehackers@gmail.com
    WhatsApp: ‪+1 (219)2714465

    Contact them today and be happy

    ReplyDelete
  17. iI’m lauriel from New York, United States. I lost my job a few months back after my divorce with my wife. I tried everything positive to make sure I took good care of my kids but all failed, and I was in debt which makes everything worse. I was kicked out of my home and i had to live with my neighbor after pleading with her to allow me to stay with her for some days while I figured out how to get a home which she agreed to, but no one was willing to help anymore. I bumped into this page from google and I was excited about this, then I contacted the hackersBill Dean. I had just $200, so I pleaded with them to help me because of my condition but they never accepted. I believed in this, so I managed to pawn a few things and got $500. I ordered the $10,000 card and I got my card delivered to me by Ups 4 days later. I never believed my eyes! I was excited and upset as well, I managed to withdraw $2000 on the ATM and $2500 the second day. I went to Walmart and a grocery store and bought a couple of things for $3000. The card got blocked the third day and I contacted them and I was told it's a mistake from my end. I’m so happy, I have started all over again and have a good apartment with my kids you can contact him through is via email (globalatmcardhackingservice@gmail.com)or his whatsap contact (+1 301-887-5071) 

    ReplyDelete
  18. I was searching for loan to sort out my bills& debts, then i saw comments about Blank ATM Credit Card that can be hacked to withdraw money from any ATM machines around you . I doubted thus but decided to give it a try by contacting (globalatmcardhackingservice@gmail.com} they responded with their guidelines on how the card works. I was assured that the card can withdraw $5,000 instant per day & was credited with$50,000,000.00 so i requested for one & paid the delivery fee to obtain the card, after 24 hours later, i was shock to see the UPS agent in my resident with a parcel{card} i signed and went back inside and confirmed the card work's after the agent left. This is no doubts because i have the card & has made used of the card. This hackers are USA based hackers set out to help people with financial freedom!! Contact these email if you wants to get rich with this Via: globalatmcardhackingservice@gmail.com or WhatsApp +1 301-887-5071

    ReplyDelete

  19. My name is Boris Mitchell! I'm here to testify about Mr harry Blank ATM Cards which can withdraw money from any ATM machines all over the world. I applied for the Blank Card to my greatest surprise I have used it to get 24,000 dollars. You can withdrawal up to $1,200 per day. You can also use it to shop online and attach it to your PayPal account. The card is already been hack, loaded and programmed with fund. If you want to get one for yourself, contact him via his email: (harrybrownn59@gmail.com) Do not miss this great opportunity.

    ReplyDelete
  20. Best Bitcoin Recovery Expert To Recover

    Have you lost hope of ever recovering your money from scam brokers? I have good news for you and yes it is 97% possible for you to recover
    your money through binary cash refund (BCRF)but to do this you need an expert ,I lost over 76,000$ to fake broker and I lost any hope of
    ever making profit through binary trading until I met an awesome recovery Hacker known as Ultimate Hacker Jerry who introduced me to (BCRF)..and to recover any lost money to any Cryptocurrency i was able to recover my money and with an amazing recovery Hacker guidance I have been able to make profits after recovering my lost funds. l recommend Jerry to anyone email him at (Ultimatehackerjerry@seznam. Cz) Don’t forget to mention Isaac recommended you

    ReplyDelete