Re: Time to Time DB2 Backup Faliure

Hi,

We have Networker 9.1 that deployed on a Win 2012 R2. We are schedule a DB2 full backup on every day 3 am. Past few months we are facing the backup failure in time to time. In the every time when the backup failed we got the below error.

Backing up the ‘PB_PROD’ database.

Unable to backup PB_PROD database due to backup request failure, SQLCODE : -2025, SQL2025N An I/O error occurred. Error code: “3”. Media on which this error

occurred: “VENDOR”.

NMDA backup failed.

64673:nsrdasv: Unable to backup PB_PROD database due to backup request failure, SQLCODE : -2025, SQL2025N An I/O error occurred. Error code: “3”. Media on which this error

occurred: “VENDOR”.

— Job Indications —

prdbsvr1:DB2:/PB_PROD/NODE0000: retried 1 times.”



But after we restart the NW services from next day onwards backup was run as normal. DB backup size is ~1.5 TB. We have open several SR‘s with DELL EMC NW support team. As per them in the very first time they advised to restart the NW services. As I previously said after restarting the services it was runnin fine. In the second time when we open the SR they asked to created a separate ddboost device to backup the data. That thing also we already did. Now we yesterday backup was again failed with the same error.



Is anyone can advised how to solve this issue permanently.

Related:

  • No Related Posts

IBM Cognos TM1 10.2 new Features

1656_900.jpg

IBM Cognos TM1 10.2. has a versatile application that interfaces with an IBM Cognos TM1 Server and coincides with other work area and web programs that associates with a similar server. You can utilize the Mobile application to do the accompanying errands:

Access all arranging applications from Cognos TM1 Applications.

View accommodation status for all endorsement hubs.

Communicate with solid shape sees in a network or graph design.

Change esteems on the iPad and submit back to the arrangement where the information is refreshed on the Cognos TM1 server.

One awesome element I adore is the “Change instrument for Microsoft Excel .xls documents.” I was as of late at customer where we confronted a couple of issues because of the utilization of 2007 and with this most recent update IBM Cognos TM1 10.2, you can change over Microsoft Excel 2007 or higher worksheets into OpenXML design.

Another great move up to IBM Cognos TM1 10.2 is the new highlights to Performance modeler. Presently some might be content with this, while a portion of the more established coders who adored the old method to make 3D squares, measurements and so on the physically way may not. Be that as it may, IBM has now included a couple of new things with Performance modeler, for example, Cube count, Feeder Optimization, Data stream charts, Data stream graphs, TurboIntegrator forms activated from work process activities, and then some!

IBM Cognos TM1 training

Related:

  • No Related Posts

7023392: IND$FILE File Transfer trouble-shooting tips with Reflection for the Web

Basic Trouble-Shooting:

Verify that the Host session is at a location where it can launch the Host-based IBM IND$FILE file transfer program:

The user typically needs to be located at one of two following host screen locations:

1.) At the TSO “READY” prompt logged into the MVS system but outside of ISPF

2.) At the ISPF Menu Option 6 – “ISPF Command Shell”

– the cursor must be on the line that begins with the “===>”

– if there are two “===>” prompts on the screen, then make sure the cursor is located on the top one

Note: To determine if a prompt on the Host screen will allow access to the IND$FILE command:

– At the current cursor location type the words “IND$FILE” then press the ENTER key.

– If this command gives get back a TRANS type error or information that says “IBM File Transfer Program”
than the user can access the IND$FILE program on the Host from this location.

(Depending on the Host system, the user may have to press the ENTER key a second or third time to get back to the prompt they started at)


Resolve any TRANS errors that occur during the file transfer attempt:

The IBM IND$FILE file transfer application will generate a TRANS code for specific type of errors that can be detected. There are lists of these codes available in a variety of locations on the internet including: https://www.microfocus.com/documentation/rumba/desktop951/RumbaSystemAdminGuide/GUID-44F7F207-D285-43B0-92D0-B5E641DB5CC6.html. These errors typically appear in a Reflection for the Web dialog box for easy review and must be dismissed to continue. After an error of this sort, make sure the Host session has returned to a READY prompt before attempting the next file transfer.

One of the more common TRANS errors seen in TSO is the “TRANS18 – Incorrect Option Specified” error. To resolve this error on a SEND command, in the Reflection for the Web file Transfer settings change the “Record Format” from the value of “variable” to the value of “default”.


Confirm that the naming convention for the TSO file/dataset is correct:

Each element (username, dataset, member) of a TSO dataset is limited to a maximum of 8 characters.

When in doubt, use the fully qualified name of the TSO data set surrounded by single tick marks and include any member names inside matched sets of parenthesis.

Example:

‘username.dataset(member)’


Problems with figuring out PC File Names or Host Dataset/Member Names:

Reflection for the Web 12.1 HF80, Reflection for the Web 12.2 HF40, Reflection for the Web 12.3 HF5, and later versions now fully support the ability to drag-and-drop files during an IND$FILE file transfer to and from the members of a TSO dataset. In the past, the user had to use the SEND AS and RECEIVE AS options and type in the name of either the PC or the Host file including possible PC path information and Host dataset and member information. Having to remember to type the proper format could lead to errors especially in the TSO naming conventions. If the SEND AS or RECEIVE AS is failing, try using the drag-and-drop method so that Reflection for the Web is responsible for figuring out the proper naming conventions. Also, if using drag-and-drop and having a file name issue, try using the SEND AS or RECEIVE AS methods and manually enter in the appropriate names of the files.

Advanced Trouble-Shooting:

Examine Java Console Logs with Reflection for the Web Client logging turned on

The Java Console Log can be used to view historical data about previous IND$FILE file transfer success and failures. Short of taking a full-blown communication trace, the Java Console log can be used to quickly examine previous file transfers but before the Java Console can be used, there is some configuration that must occur.

1. In the Windows Control Panel, open the Java applet and go to the Advanced Tab and check the boxes under “Debugging” to “Enable tracing” and “Enable logging”.

2. In the Reflection for the Web Administrative WebStation, go to the Settings option and select the Logging tab, and check the box for “Write client debug output to console”.

3. Launch the Windows browser and the Reflection for the Web session.

The Java Console log can be viewed from the Java Console itself or from the Windows WordPad or Notepad application by opening the file that is saved in the C:Users<username>AppDataLocalLowSunJavaDeploymentlog location. Use the log file created with the *.trace extension for information about IND$FILE transfers.

What to look for:

– Look for the strings “IND$FILE PUT” or “IND$FILE GET” to find the start of the file transfer attempt. This line will show you the Host name that was generated by Reflection for the Web and sent to the Host, as well as any file transfer options specified. A quick check of this line can tell you if the correct or appropriate command was sent to the Host

– Look for a string that contains the words “TRANS…”. This line(s) will show the results of the file transfer. A TRANS03 is success, but other errors can be listed.


Communication Trace from Reflection for the Web

When all else fails, a communication trace taken in the Reflection for the Web session (from the Help / Trace menu) with a description of what was tested can be used to examine a IND$FILE transfer failure. The Reflection for the Werb communication trace shows all the exchanges of data with the Host including the commands sent and the responses received so if any Host error messages or data has scrolled off the screen it will be captured in this trace. This step requires that the trace be sent to Micro Focus Technical Support and a Support Engineer with IND$FILE file transfer expertise be available to review the trace.

Related:

  • No Related Posts

Prevention policy for DB2

I need a solution

I see under the AIX prevention the only DB prevention policy for MySQl.  Is there a best practice or template  for DB2? We are trying to set up prevention for an AIX 7.2 server running IBM DB2. We have a policy in place for the  OS – but want one geared toward the Data Base.

0

Related:

Netwoker Client Direct Backup not Working

Hi,

We have the NW 9.1 deployed on a VM. OS is Win 2012 R2. We are expecting backup slowness on our DB client. It contains ~1.4 TB data. We are use the client direct for backup the data to DD. To investigate this issue we have rendered the daemon.raw file in the NW server and go through it. Then we are able to identified client direct backup it not happening. Pls refer the below log output.

70896 9/19/2018 4:00:50 AM 0 0 2 8440 1320 0 win-afvg9er8ckm nsrd NSR info prdbsvr1:DB2:/PB_PROD/NODE0000 saving to pool ‘Digital_Banking_Prod_DB’ (DigitalBankingProdDB.001)

91797 9/19/2018 4:00:50 AM 4 5 0 4664 9432 0 win-afvg9er8ckm nsrmmd NSR severe Unable to perform direct file save with Data Domain device ‘DWHDD1_Digital_Banking_Prod_DB’; setting up traditional save for save-set ID ‘3600907418’ (prdbsvr1:DB2:/PB_PROD/NODE0000)

71659 9/19/2018 7:44:12 AM 0 0 2 8440 1320 0 win-afvg9er8ckm nsrd NSR info prdbsvr1:DB2:/PB_PROD/NODE0000 done saving to pool ‘Digital_Banking_Prod_DB’ (DigitalBankingProdDB.001) 1358 GB

70896 9/19/2018 7:44:15 AM 0 0 2 8440 1320 0 win-afvg9er8ckm nsrd NSR info prdbsvr1:DB2:/PB_PROD/NODE0000 saving to pool ‘Digital_Banking_Prod_DB’ (DigitalBankingProdDB.001)

91797 9/19/2018 7:44:15 AM 4 5 0 4664 9432 0 win-afvg9er8ckm nsrmmd NSR severe Unable to perform direct file save with Data Domain device ‘DWHDD1_Digital_Banking_Prod_DB’; setting up traditional save for save-set ID ‘2124525815’ (prdbsvr1:DB2:/PB_PROD/NODE0000)

Then we have check the connectivity between the client and DD vice versa. Connectivity is fine. And we are use the dedicated VLAN for the backup purpose. That means all the backup clients and DD are in the same range.

How can we solve this issue. Pls advised.

Related: