StackOverflow is a collaborative programming Q&A community venture
Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.
db2RemStgManager analyse error based on error code
I am using a shell script to put a file in object storage. For this I am using;
For now I am deliberately providing wrong creds.
I want to log a different error message if authentication failed. Currenlty when I log what the above command returns I see:
From what I understand is 251 error code signifies shell's writing error. How can check for authentication errors? when I look at /tmp/a/db2diag.log I can't see any specific authentication error message.
qsh: 001-0078 Process ended by signal 5 when using stmt.bindParam()
Whenever I attempt to run the following code with the statement.bindParam(..) I receive the qsh: 001-0078 Process ended by signal 5 error. There is not much documentation on the error other than possibly not having permissions.
Here is the link to an explanation of the error:
I don't understand why it ONLY happens when the statement.bindParam() is in there. I can get it to run fine otherwise. Sadly, I need the bindParam and I need prepared statements here.
Correct My DB2 Query that I am Getting Error
I am using below DB2 query to get the Specific Length of Characterfrom CLASSIFICATION Coulmn with Condition 0 before the '\', but I am getting error.
Can you please Help me on this.
Already Gone to Stackoverflow for the answers
Getting error while configuring db2 database in ibm pim (ISPM)
We have setup IBM privileged identity manager(ISPM) and db2 instance has also been started. However while setting up standalone node and adding database configuration, we go below error.
Can you please help with this?
How does the DB2 .prepare() function work within Node?
I am attempting to setup prepared insert statements but I am having difficulty finding documentation on using DB2i with Node.
I found a website that shows how I would assume the function would work..
The issue is, stmt comes back as undefined and there is no error. I am very confused on how I am supposed to setup this function and I can't find documentation anywhere.
I have also done a
It shows a function exists.
Number of host variables not valid? I have one ? and one variable being used
I keep receiving the error that the "Number of host variables is not valid".
I am reading that this means the amounts do not match up. I clearly have one ? and one variable being used to fill that. I have tried many things and have had no success.
Edit: I have updated my post and gotten rid of the issue. Only problem is now I get the following...
How to assign a value of 0 if a row doesn't meet the requirements
I'm trying to return an actor name field (A_Name) and the movie role field (MR_Role) with the number of times each actor has an "Uncredited" in their role. I also want to return a 0 if that specific actor does not have an "Uncredited" in their role. You'll see in my table formats there's another table, but I don't need to use it to run this query since that just has movie id and year of release.
I've used this code to return the amount of uncredited roles for each actor, but without the 0's:
These are the formats of the tables I'm using:
Is there a way to interrogate the status of AS400 jobs from VBA?
I'm trying to provide a user interface in Access to display the status of scheduled AS400 jobs, to show them as either pending, running, or complete.
I've inherited some code which schedules several jobs, which runs fine - but there's no way the user can see what the job status is, and they sometimes hang.
Completion is currently signaled via a numeric counter held in the tables which the jobs update, and there's a Form Timer event which regularly checks for completion.
Using this method, the code can tell when processing on the AS400 is complete, but not if it's hung or failed, or if the server is heavily loaded and running slowly.
I've tried to find code examples on the internet but drew a blank. All I could find that helped was the IBM Database Manual (pdf and online) and a pdf slideshow entitled "iSeries Access ActiveX Development" by Troy C Bleeker of IBM.
Using these resources, I've written some code using the IBM i Access for Windows ActiveX Object Library (cwbx) to talk to the AS400 which works fine, and I can issue the WRKUSRJOB command to check job statuses, but I can't figure out how (or even if) it's possible to view the results of the command.
Is there a way of doing this, and if so, how?
It would be great if eg the Errors collection contained the results of the command, or if they could be piped or redirected to a file or queue that could be read by the ActiveX, but I keep drawing a blank.
How to store the select result to a new column from the same table?
I am using DB2 of IBM. I have a table
DB2 with .NET Core 2.1
I installed IBM.Data.DB2.Core Version (18.104.22.168) with Visual Studio 2017 & .Net Core 2.1. I was trying to test simple DB2 (z/OS server) connection and getting the below error. Our DB2 Server type is OS390 and version is 11.
ERROR  [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing problem.
Also I copied the license file to .nuget\packages\ibm.data.db2.core\22.214.171.124\build\clidriver\license folder. I tried everything mentioned here: https://www.ibm.com/developerworks/community/blogs/96960515-2ea1-4391-8170-b0515d08e4da/entry/Instructions_for_downloading_and_using_DB2_NET_Core_provider_package?lang=en