Search results for query: *

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...

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

Thank you Ken, Which CPU is my question.

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...

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.

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?

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...

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...

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...

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..

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...

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...

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...

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...

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...

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....

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...

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...

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...

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...