How to delete files older than x days in a network drive

When using the forfiles command on network shares, 

the forfiles command can be used to delete files older than x days in a folder 

however, direct use of UNC path may result in the ff error: 

 

"ERROR: UNC Paths <\\machine\share> are not supported."

 

 A solution to this would be to map the network drive (force map)

NET USE O: /delete /y
NET USE O: \\192.168.0.1\yourfolder

forfiles /p "O:\testdelete" /s /m *.* /c "cmd /c Del @path" /d -7 

ITIL training providers Manila

ITIL Foundation v.3 Training Providers as of 2018

The exam costs about $200 so I would advise taking a seminar with exam included in the package.

A few (non-exhaustive list of training providers below).

1) MITC (Makati)
    - no exam, seminar only
    - Location: Buendia Makati at Mapua school

2) Phoenix One (Makati)
    - ?
    - Makati office

3) Active Learning (Greenhills)
    - with exam, online proctored exam to be scheduled at your convenience,
      can be taken at home or at office
    - location: Annapolis St. San Juan training center

4) ECCI (Makati)
    - with exam, but needs to be scheduled on site, paper exam
    - location of training: Holiday Inn Makati
    - location of exam: Makati office of ECCI


 

How to Install DB2 Web Query IBM i 7

Here are the instructions on how to install using EZ install on IBM i.
First step is get in touch with IBM Web Query Team: Please refer any questions to QU2@us.ibm.com

 

Just as a reference, here are the instructions as of Jan 202 I got.

Please read the following important information:

The installation assumes you do not already have Version 2.2.1 of DB2 Web Query installed.
- If you have Version 2.2.1 installed, it will not overwrite your currently installed version.

- If you have a previous Version 2 level installed you will be prompted to install or not. If you choose to install Version 2.2.1, it will upgrade your Version 2 code (but will not replace any current reports or meta data). Having a good backup of the previous level is ALWAYS a good idea. Refer to the backup guide on our wiki: http://ibm.biz/db2wqwiki.

KNOWN INSTALLATION or STARTUP ISSUES that you may run into:

- CCSID 65535. The webquery startup will fail with this message when running under CCSID 65535: "REPLACE has invalid operators and the reason code is 12: the CCSID of the operators are not compatibles." For example, if user profile starting webquery has a CCSID value of *SYSVAL, and your QCCSID value is set to 65535.

SOLUTION: Before running the QWQINSTALL/SETUP command, enter this command CHGJOB CCSID(xxx), where xxx is the default CCSID for primary language. For example, on an English system, before running SETUP, enter the command CHGJOB CCSID(37).

- LOCALE errors. If you get an error referencing an issue with LOCALE, it most likely implies that the user profile you are using to run SETUP - or the System Value for QLOCALE - is not set. If you are running Web Query under English CCSID 37, then set the locale value to /QSYS.LIB/EN_US.LOCALE. The locale for a profile should match the CCSID. For other CCSIDs, you can review the table here for the appropriate setting: https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzahz/rzahznls.htm.

- Security user exit blockers. Programs in place called “user exits” that block things like ODBC and SQL calls can cause the installation to fail because the QWQADMIN user profile is blocked

- Missing or downlevel pre-reqs. Note that the ez-install process does run a pre-req checker, and that this is also available standalone in the box if you want to run it before you try to install. Most common issues will be:

For i7.2 and up:
PREREQ MISSING: 5770JV1 FEATURE 0016
PREREQ MISSING: 5770SS1 FEATURE 0013

For i7.1
PREREQ MISSING: 5761JV1 FEATURE 0016
PREREQ MISSING: 5770SS1 FEATURE 0013

If you are missing the JV1 feature, you can read about how to acquire it here:

http://www-01.ibm.com/support/docview.wss?uid=nas8N1020692

Note: After installing the JV1 feature, if you have the Java group PTF applied then you must reapply the Java group PTF to pick up missing PTFs for the feature.

Do not run the ezinstall SETUP command until the Java group is reapplied.

The Java group PTF numbers are:

7.4 - SF99665
7.3 - SF99725
7.2 - SF99716
7.1 - SF99572

ddf

s

f

k