Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pmking

    Creating Stored Procedure on z/OS DB2

    I am trying to create a stored procedure on z/OS DB2. After the create runs successfully, what is the next step so that DB2 knows it's there? When I run a program with sqlexec invoking a the stored procedure, it says it can't be found. Here is the stored procedure. create procedure...
  2. pmking

    How to determine what CPU.

    You said, "what CPU you are using". That is what I want, but also, what process a CPU is bound to. So this command wouldn't help me? -chris
  3. pmking

    How to determine what CPU.

    Thank you Ken, Which CPU is my question.
  4. pmking

    How to determine what CPU.

    Thanks. I have tried man and I can't find info. So if anybody knows of the command, I would GREATLY appreciate it, and if this can even be done.. The reason for this forum is usually a last resort, I have tried the man and have searched on the internet for this... But I can't find anything...
  5. pmking

    How to determine what CPU.

    On Solaris 10, four CPU's. Is there a command I can use that will show what CPU a process is using? Hope this is the right forum for this. Thanks.
  6. pmking

    How does one create a db2 user?

    On Unix (AIX) How does one create a user 'inside' DB2? New to DB2 and would like to do this.. Another question: If I have a OS level user with DB2 Admin privileges, would this suffice without having to create a user 'inside' db2?
  7. pmking

    Gathering Process Information.

    Thank you PHV, It looks like this script (the example link you sent me) will create the table every time the script is executed. I have the tables in place now, since dba's won't allow tables to be created on the fly.. My question is, how do I get my shell script output to populate the...
  8. pmking

    Gathering Process Information.

    Thanks. When I am fully done, I will post all my scripts for people to use. And would love to help you all with the same questions to get started and even maybe do your work for you. You can analyze my scripts and learn from them. My scripts work, and of course there are other programmers...
  9. pmking

    Gathering Process Information.

    Hi, I have written scripts before, but I am not a full timer script person anymore and I have forgotten so much. It has been over 24 months since I touched a script. I am starting from scratch here. I would like to create a shell script that will gather CPU, Memory, IO, and other performance...
  10. pmking

    SQL AND SCHEMA.

    blom0344... THANKS SO MUCH!! I just searched on syscat and was WOW'd by all the info available, I think all the info I need is there. You get a star. Again thanks so much..
  11. pmking

    SQL AND SCHEMA.

    Can somebody else assist me in getting started with my DB2 sql script. All I need is a starting point. blom0344--Thanks for the response and suggestion to look in the syscat and sysibm schemas for metadata tables. I wasn't asking you to write it all for me, just assist with a starting point...
  12. pmking

    SQL AND SCHEMA.

    blom0344, Thanks for the note. Do you know where I can read on DBA views to screen for name and contents? Below is a snipit of the Oracle sql script that I mentioned. So with what is below and the naming conventions in DB2, how would I change, or what syntax would be changed with regard to...
  13. pmking

    SQL AND SCHEMA.

    Hello.. Can somebody please assist me here? My goal is to have a sql script that will parse a DB2 schema and help identify the following: NOTE: I HAVE ONE (WORKING SQL SCRIPT) FOR ORACLE AND IT WORKS, BUT WHAT SQL SCRIPTING DIFFERENCES WILL I HAVE TO ACCOUNT FOR, FOR DB2 UDB. My goal is to...
  14. pmking

    My chmod is not working.

    Thank you columb, It will not take any longer than 2 minutes, per our study, the reason is, if the user runs the script at 12:00:56, and by the time the user gets to the end of the menu to run the script, the time is now 12:01:15. I have noticed this error only when the minute hand changes, so...
  15. pmking

    My chmod is not working.

    Thank you for you help and suggestions.. It is working finally, but I am getting a date range issue per another part of the script.. My question to you is how can I add 2 minutes to current server time. For example: 'date' is a variable in the script, but what I would like to do is add 2...
  16. pmking

    My chmod is not working.

    I will try this tomorrow morning, the admins are going to reboot the server now (maintenance time), so I won't be able to try this until tomorrow.. I will keep you posted.. Thanks again PHV....
  17. pmking

    My chmod is not working.

    Here is the correct verion, apparently I have too much info on a directory path from my last post. I will take my time now.. sorry, I just feel rushed from my job:( if test ! -f /var/logs/collect$month.log then touch /var/logs/collect$month.log chmod 662 /var/logs/collect$month.log chown...
  18. pmking

    My chmod is not working.

    Here is the part of the script in full. The fi is there.. if test ! -f /var/best1_logs/collect$month.log then touch /var/logs/collect$month.log chmod 662 /var/logs/collect$month.log chown ligv:support /var/logs/collect$month.log fi I am having issues getting my set -x to work, this is what I...
  19. pmking

    My chmod is not working.

    So sorry.. I should have put more info. No error message. The unexpected result is that my /var/logs/collect$month.log file is not chaning permissions, thus not changing owner, which is the next line. Could it be that I am using write without read, would my current results be that the...
  20. pmking

    My chmod is not working.

    Hello Below is a snipit of shell script and the process works, but was wondering the chmod part is not working. if test ! -f /var/logs/collect$month.log then touch /var/logs/collect$month.log chmod 662 /var/logs/collect$month.log chown userid:usergroup /var/logs/collect$month.log Also.. I...

Part and Inventory Search

Back
Top