Product Documentation
Download IBM Data Studio. Select to download from the web, or from Passport Advantage. Select to download the Data Studio client. When you complete the download, depending on your operating system, run one of the following commands as administrator. Data studio generates incorrect update statement for table statistics. 7: IC87419: Data studio unable to deploy sqlj stored procedure to db2 z/os v10cm8. 8: IC88034: Using ellipsis button to enter data for in or inout parameter trims spaces: 9: IC88090: Data studio keeps connection thread on.
Abstract
This document provides the list of APARs that are fixed in Data Studio 4.1.x.
Content
- Data Studio 4.1
- Data Studio 4.1.0.1
- Data Studio 4.1.1
- Data Studio 4.1.2
- Data Studio 4.1.3
Data Studio 4.1
| Sr. No. | APAR Number | Description |
|---|---|---|
| 1 | IC82080 | Documentation topic is missing configuring data studio for running high performance unload (hpu) utility on unix platforms. |
| 2 | IC83380 | Tablespaces in data studio do not recognize partitioned tables. |
| 3 | IC83799 | Simultaneously updating source and user privileges for stored procedure in properties view may result in incorrect generated ddl. |
| 4 | IC85153 | Unable to retian autoresize keyword change after alter on dms tablespace |
| 5 | IC86915 | Local stored procedure marked as syntax error in data studio |
| 6 | IC87265 | Data studio generates incorrect update statement for table statistics. |
| 7 | IC87419 | Data studio unable to deploy sqlj stored procedure to db2 z/os v10cm8. |
| 8 | IC88034 | Using ellipsis button to enter data for in or inout parameter trims spaces |
| 9 | IC88090 | Data studio keeps connection thread on fail udf run |
| 10 | IC88756 | Datastudio 3.1.1 generates -206 error code in edit mode while used in db2 z 10 cm8 environment |
| 11 | IC88928 | 'Grant to role' statements are not generated for a role which name matches the name of an existing user |
| 12 | IC89499 | Incorrect extra comma in create nickname statement for the non relational data source file_wrapper. |
| 13 | IC89577 | Data type declaration of for bit data ignored by data studio. |
| 14 | IC89910 | Sql2036n error when backup command is executed from admin explorer. |
| 15 | IC90135 | Database catalog filter produces incorrect result in data studio |
| 16 | IC90322 | Statements in before run should be treated as a single unit of work. |
| 17 | IC90808 | The statistics advisor keeps offering the same statistics advise even after running recommendations on server. |
| 18 | IC90904 | Can not input alphanumeric in pmr number's branch field when user use capture query environment after tuning a sql. |
| 19 | IC90928 | Data studio does not run properly when authentication mode is data_encrypt |
| 20 | IC91252 | Data studio's optim query tuner do not display proper values for low2key, high2key, frequency. |
| 21 | IC91348 | Unable to use analyze impact function for temporary tables. |
| 22 | IC91480 | User gets 'internal error occured' when running a select on table containing character for bit data column |
| 23 | IC91710 | Calling a stored procedure with a supplied value for inout |
| 24 | IC91838 | 'Generate ddl' function is not available for db2 for z/os |
| 25 | IC91906 | Comments at the beginning of sql script in sql editor will fail the running of the script. |
| 26 | IC92095 | User gets sqlstate=51002 in data studio administration perspective when trying to rebind a package which has v |
| 27 | IC92209 | Sql results view shows password plain text in result output for altering user mapping under federated database objects |
Data Studio 4.1.0.1
| Sr. No. | Description | |
|---|---|---|
| 1 | IC85675 | CREATE XML SCHEMA FOR DB2 Z/OS V10 FAILS IN DATA STUDIO |
| 2 | IC91253 | CANNOT START THE DATA STUDIO 3.2 INSTALLATION IN RED HAT ENTERPRISE LINUX 6.3 |
| 3 | IC92281 | ROUTINE EDITOR HAS A DELAYED SYNCHRONIZATION WITH USERS' INPUT AND MAY RUN AN OUTDATED VERSION OF AN SQL SCRIPT BEING EDITED |
| 4 | IC92596 | DATA STUDIO 3.2 DROPS THE COMMENTS FROM THE STORED PROCEDURE'S PARAMETER SECTION AFTER DEPLOYING IT ON DATABASE |
| 5 | IC92564 | SQL QUERY BUILDER IN DATA STUDIO SHOW NO RESULT FROM RUN |
| 6 | IC92709 | DATA STUDIO 3.2 OPTIM QUERY TUNER HANGS UP DUE TO THE CATALALOG LOADING DURING THE QUERY TUNNING PROCESS. |
| 7 | IC92857 | UPDATE STATISTICS FUNCTION ON NICKNAME IN DATA STUDIO 3.2 GIVES SQLCODE=-1131 |
| 8 | IC92908 | VIEWING XML COLUMNS IN 'SQL RESULTS' VIEW VIA ELLIPSIS BUTTON MAY SHOW GARBAGE INSTEAD OF SOME UNICODE CHARACTERS |
| 9 | IC92916 | 'GENERATE DDL' PRODUCES INVALID DDLS FOR DB2 Z/OS TRIGGERS WHICHDEFINITIONS HAVE SPARSE FORMATTING |
| 10 | IC93065 | WHEN SPECIFY A NETWORK DRIVE AT THE WORKSPACE LOCATION, GET 'START EXPLAIN WORKER HAS ENCOUNTERED A PROBLEM' ERROR |
| 11 | IC93016 | ERROR DIALOG POPS UP WHEN PRINTING A DIAGRAM IN DATA STUDIO |
| 12 | IC93152 | COMMAND TEXT FROM LOAD UTILITY DOES NOT REFLECT GUI |
| 13 | IC93927 | DDL IS NOT GENERATED WHEN ONLY PRIVILEGES OBJECT IS SELECTED FROM MODEL OBJECTS LIST AT CREATE DDL FROM DATA SOURCE EXPLORER |
| 14 | IC94069 | DDL GENERATION IN DATA STUDIO CONTAINS EXTRA QUOTES |
| 15 | IC94333 | DATA STUDIO DISPLAYS INCORRECT PARTITIONS FOR TABLESPACES |
| 16 | IC94615 | SYNCHRONIZATION OF DATA STUDIO CONNECTIONS, PRIMARY CONNECTION MUST BE ESTABLISHED FIRST |
| 17 | IC94940 | DATA STUDIO 4.1 FORMAT SQL RESULTS IN WRONG SQL FORMAT FOR HOST VARIABLES. |
| 18 | IC95168 | MISSING FILES FROM JAVA STORED PROCEDURES EXPORT |
| 19 | IC95072 | ERROR CAN BE GENERATED WHEN OPENING THE SEQUENCES FOLDER WHICH CONTAINS AN ALIAS OF A SEQUENCE. |
| 20 | IC95700 | FORMAT SQL FAILS WHEN HOST VARIABLE CONTAINS SPACE IN DATA STUDIO |
| 21 | IC96040 | RENAME ACTION IN DATA STUDIO FOR SQL SCRIPTS HAVE DIFFERENT BEHAVIOR FOR DIFFERENT PROJECT TYPES |
| 22 | IC96935 | UPON GENERATION OF THE DDL USING DATA STUDIO 4.1 THE UPDATE GRANT IS NOT SHOWN AS PART OF DDL. |
| 23 | IC97677 | DATA STUDIO SQL EDITOR - HOST VARIABLE NAME DOES NOT WORK FOR A MAJORITY OF UNICODE CHARACTERS |
Data Studio 4.1.1
Ibm Data Studio Versions
| Sr. No. | APAR Number | |
|---|---|---|
| 1 | IC98973 | DATA STUDIO DOES NOT DROP INACTIVE VERSIONS OF STORED PROCEDURES. |
| 2 | IC99118 | DATA STUDIO SQL EDITOR TO ALLOW THE USE OF !! AS CONCATENATION. |
| 3 | IC99609 | DEBUGGING A UDF (DEPLOYED ON DB2 FOR Z/OS) THAT IS USING PARAMETER CCSID UNICODE FAIL WITH SQLCODE332N. |
| 4 | IC87419 | DATA STUDIO UNABLE TO DEPLOY SQLJ STORED PROCEDURE TO DB2 Z/OS V10CM8. |
| 5 | IC90808 | THE STATISTICS ADVISOR KEEPS OFFERING THE SAME STATISTICS ADVISE EVEN AFTER RUNNING RECOMMENDATIONS ON SERVER. |
| 6 | IC99357 | DATA STUDIO NOT ABLE TO DROP DB2 Z/OS NATIVE STORED PROCEDURES WITH MULTIPLE VERSIONS. |
| 7 | IT00375 | MISSING PLAN_TABLE AND DIAGRAM TABS IN ACCESS PLAN GRAPH VIEW IN DATA STUDIO 4.1.0.1. |
| 8 | IT00680 | OPENING THE SOURCE OF A JAVA STORED PROCEDURE USING THE ROUTINE EDITOR MAY RESULT IN NO SOURCE BEING DISPLAYED. |
| 9 | IT00782 | BUILD OWNER FIELD IN DEPLOY OPTIONS NOT USED ON REBUILDS. |
| 10 | IT00850 | SQL SCRIPTS, THERE IS A SYMBOL ENGLISH POUND SIGN. AFTER SAVING, IT WILL AUTOMATICALLY SAVE AS A DIFFERENT SET OF CHARACTER. |
| 11 | IT00984 | CONNECTIONS LEFT 'OPENED' ON RUN FROM THE SQL EDITOR. |
| 12 | IT00998 | INSTALLED BROWSERS DO NOT SHOW UP IN REVIEW ACCESS PLAN GRAPH FOR DATA STUDIO 4.1.0.1. |
| 13 | IT00870 | DB2 LUW CREATE LARGE TABLE SPACE: TRANSLATED DATA TAG INHERIT KEYWORD CAUSED CREATION DDL ERROR. |
| 14 | IT01751 | DATA STUDIO 4.1 SHOULD TREAT AN IDENTIFIER OF UPPERCASE WITH # SIGN SAME AS LOWERCASE WITH # SIGN. |
| 15 | IT01997 | PLAN_TABLE IS NOT DISPLAYED WHEN OPEN VE FROM DATA STUDIO SQL EDITOR. |
| 16 | IT02101 | TIMESTAMP COLUMN DISPLAY PROBLEMS. |
| 17 | IT02688 | PERFORMING EXPLAIN IN DATA STUDIO 4.1 RESULTS IN CHARACTER CONVERSION ERROR. |
| 18 | IT02744 | DATA STUDIO 4.1 QUERY TUNER THROW ERROR FOR QUERY ANNOTATION ON DB2 V10NFM AND V11NFM. |
| 19 | IT02816 | DATA STUDIO 4.1.0.1 USER GET THE MESSAGE ABOUT NOT HAVING SUPPORTED BROWSER WHEN TRY TO DISPLAY AN ACCESS PATH GRAPH. |
| 20 | IT03308 | DATA STUDIO 4.1 GENERATES WRONG DDL FOR VIEWS FOR DB2 ZOS. |
Data Studio 4.1.2
Prerequisite: Data Studio (Client) 4.1.2
| Sr. No. | Description | |
|---|---|---|
| 1 | 93151,122,000 | Fixed the issue for improper removal of WLM Environment statement for native SQL stored procedure for DB2 for z/OS. |
| 2 | 71074,7TD,000 | Support tuning specific statement on DB2 for z/OS environment, which uses double quotes as SQL delimiter. |
| 3 | 88386,7TD,000 | Support running Workload Analytics Acceleration Advisor for specific static statements. |
| 4 | 78422,122,000 | Support NON-SYSADM users to create explain tables automatically. |
| 5 | 21130,057,649 | Support showing commands of workload statistic advisor recommendations in summary report when those commands are only recommended to collect complete statistics but not to repair problems. |
| 6 | 68100,072,649 | Support long query text for scheduling capture task from package cache. |
| 7 | 39230,033,724 | Support displaying cardinality of TBSCAN of a global temporary table. |
| 8 | 77846,122,000 | Support migration of workload control center view's privilege from Optim Query Workload Tuner 4.1.1. |
| 9 | 77846,122,000 | Support doing configuration for DB2 for z/OS by using JCL. |
| 10 | 81745,999,616 | Support tuning specific workload, which includes CREATE TEMPORARY table statement on DB2 for Linux, UNIX, and Windows. |
| 11 | 75336,122,000 | Support creating workload with query length between 3500 and 4000. |
Data Studio 4.1.2 APAR 2
| Sr. No. | Description | |
|---|---|---|
| 1 | 09910,122,000 | Fixed the issue for 'Edit Data' when using SSL Connection. |
| 2 | 17286,010,678 | Fixed the issue for default schema is not honored when used in SQL script on DB2 for z/OS. |
| 3 | 15430,999,760 | Fixed the issue for 'Run' button is not enabled for IMPORT when specify a valid path with Japanese character. |
| 4 | 45900,060,678 | Support deleting a row using Data Studio with specific Column type (Column type is VARCHAR, data type is HEX). |
| 5 | 72660,250,631 | Support tuning statements, which contain expressions with OLAP specifications on DB2 for z/OS. |
| 6 | 43125,L6Q,000 | Support capturing query environment by using the global setting for SQLID and SCHEMA. |
| 7 | 70533,077,649 | Support tuning specific statements, which use function with alias as select-clause item on DB2 for Linux, UNIX, and Windows. |
| 8 | 61526,077,724 | Support primaryAccess='P' for webVE. |
| 9 | 43125,L6Q,000 | Support tuning specific statement, which refers to the temporal table on DB2 for z/OS v11 environment. |
| 10 | 93151,122,000 | Fixed the issue for improper removal of WLM Environment statement for native SQL stored procedure for DB2 for z/OS. |
Data Studio 4.1.2 APAR 3
| Sr. No. | Description | |
|---|---|---|
| 1 | 71151,122,000 | Fixed the issue debugging for native stored procedure on DB2 for z/OS. |
| Fixed the issue of database statements generation for schema on DB2 for z/OS. |
Data Studio 4.1.2 APAR 4
| Sr. No. | Description |
|---|---|
| 1 | Fixed wrong display and editing of complex expressions in SQL Builder Editor. |
| Support IMS V14 SQL Parser. | |
| Support parser validation for DB2 for z/OS V12. |
| Sr. No. | Description | |
|---|---|---|
| 1 | 53832,L6Q,000 | Fixed the issue that Data Studio 'reorg' option is grayed out when a table has xml column. |
| 2 | 32105,756,000 | Fixed the issue for getting an error when trying to select 'configure' on a database (DB2 v11.1). |
| 3 | 88886,122,000 | Update the db2 jdbc driver to DB2 Level: v11.1 FP1 (4.22.29 and 3.72.24). |
Data Studio 4.1.2 APAR 6
| Sr. No. | Description | |
|---|---|---|
| 1 | 13113,999,706 | Fixed for Data perspective - Edit/Update of Columns in IBM Rational Developer for z systems to work as expected. |
| 2 | 39801,230,631 | Fixed for Data Studio script execution stuck during export functionality |
| 3 | 87831,100,838 | Fixed for Backup and configure functionality not working for DB2 11.1 |
| 4 | 73154,004,000 | Fixed for Data Studio not returning complete error messages back when it is connected to Big SQL. |
| 5 | 90398,031,724 | Fixed for SQL QUERY BUILDER to avoid CURRENT TIMESTAMP being quoted in the where clause. |
| 6 | 11752,999,706 | Fixed for com.ibm.datatools.* plugin issue in RDZ from Data Studio. |
Data Studio 4.1.2 APAR 7
| Sr. No. | PMR Number | |
|---|---|---|
| 1 | 89458,122,000 | Fixed for Data Studio reverse engineering missing tables. |
| 2 | 00411,160,846 | Fixed for Pasting filter string into object list view does not work properly. |
| 3 | 44510,442,000 | Fixed for Data Studio 'WLM Environment' field length limitation. |
| 4 | 21467,082,000 | Fixed for Stored procedure call failed when proceeded with comment line in sql script. |
| 5 | 86345,082,000 | Fixed for Version 4.1.2 does not display DPF partitioned table spaces correctly. |
| 6 | 62986,122,000 | Fixed for DEBUG source window shows the incorrect (inactive) version of the stored procedure in data studio for DB2 ZOS. |
| 7 | 05816,999,724 | Fixed IMS SQL Parser to support Java Application programming API. |
| 8 | 34340,442,000 | Fixed for fail to capture workload on Db2 z/OS version 11 compatible mode. |
| 9 | 90697,442,000 | Fixed for show the original -553 error of setting CURRENT SQLID when tune query on Db2 z/OS. |
| 10 | 75238,057,649 | Fixed the -104 error when tune a query contains “-“ character. |
| 11 | 93435,250,631 | Fixed the performance issue when tune Workload Statistics Advisor. |
| Fixed for IDz defect caused by DS package-duplicate namespace issue. | ||
| Fixed for fail to tune workload from Query Monitor due to certificate file has expired. | ||
| Fixed for tune Workload Statistics Advisor abend due to table columns count is bigger than 255. |
Data Studio 4.1.3
Data Studio 4.1.3 APAR 1
| Sr. No. | Description | |
|---|---|---|
| 1 | IT24573 | Failed to reflect default schema value while sql execution. |
| 2 | JR59058 | Data Studio cannot batch-create federated nicknames. |
| 3 | IT24636 | Byte to char converter error.java 1.4 is getting used though customer is using jdk 1.8. |
| 4 | IT24550 | Data Studio throwing Null pointer Error when attempt to filter browsing data on a table with column name 'value'. |
Data Studio 4.1.3 APAR 2
| Sr. No. | APAR Number | |
|---|---|---|
| 1 | IT24983 | Parameters are not included in stored procedure deployment on DB2 for iSeries 7.2. |
| 2 | IT24738 | User not able to set the default JDBC run option for all workspaces. Note: The following technote for this defect has been published: Set the default JDBC Run Option globally for the SQL Editor configuration |
| 3 | IT25174 | Not able to use the Explain option in Data Studio and getting an error: An internal Error occurred. |
| 4 | IT21676 | DDL generated for DB2 Z/OS database certain SCHEMA does not maintain the proper sequence of drop and create statements for user-defined functions according to dependent user-defined functions. |
| 5 | 97397 | Allow user to directly change password or ensure repeated connection attempts do not lock out passwords. Note: The following technote for this RFE has been published: Changing database password using IBM Data Studio |
| 6 | 103312 | Update version property in Data Source Explorer for DB2 iSeries 7.3. |
Data Studio 4.1.3 APAR 3
| Sr. No. | APAR Number | |
|---|---|---|
| 1 | IT26550 | DS and IDAA shell sharing issue for visual explain on DB2zOS V12. |
| 2 | IT26548 | Special symbols in a SQL statement. |
| 3 | IT25794 | Data studio filer does not work for DB2 ZOS. |
| 4 | IT25746 | User not able to view parameter marker window when sendDataAsIs property set to true. |
| 5 | IT22206 | When generating the DDL for a VIEW, DDL will incomplete. |
| 6 | IT25797 | Data Studio 4.1.3 and illegal timestamp format error when trying to open visual explain. |
| 7 | IT26018 | AUTONOMOUS is not considered as valid keyword in DB2 ZOS v11 and v12 parsers for DS 4.1.3. |
| 8 | Internal Defects | Breakpoints for SQLJ DS412 APAR3 hide related function from UI. |
| Failed to reflect currentSQLID schema value while sql execution. |
Data Studio 4.1.3 APAR 4
| Sr. No. | Description | |
|---|---|---|
| 1 | IT26807 | Data studio is incorrectly generating unique indexes for Primary Key constraints with incorrect names. |
| 2 | IT26109 | IDAA Data Studio Client issues with Db2 V12R1M502. |
| 3 | IT25174 | Not able to use Explain option in Data Studio and getting an error: An internal Error occurred. |
| 4 | IT25175 | Data Studio is not generating Access Plan Graph for Db2 LUW v11.1. |
| 5 | IT27066 | Handle ParseNameException exception while generating Access Plan Graph in Data Studio 4.1.3. |
| 6 | IT26806 | Two connections seen in the back end for one connection in data studio for Db2 LUW database. |
| 7 | IT26314 | Japanese installation of Data studio 4.1.3 is not showing characters in Japanese on the Japanese operating system. |
| 8 | 114724 | Platform - Data Studio support for SQL Server 2016. Note: Tech note for this RFE has been published: IBM Data Studio introduces support for MS SQL Server 2016 |
| 9 | 97397 | Security - Allow user to directly change password or ensure repeated connection attempts do not lock out passwords. Note: Tech note for this RFE has been published: Changing database password using IBM Data Studio |
| 10 | Internal Enhancement | Added support for Db2 for i table partitions. Note: Tech note for this RFE has been published: Support for table partition in Db2 for I database in Data Studio |
Data Studio 4.1.3 APAR 5
| Sr. No. | APAR Number | |
|---|---|---|
| 1 | IT28533 | Online Check during deployment. |
| 2 | IT27661 | DDL is not generated with the model for DB2 LUW. |
| 3 | IT28078 | Null Pointer exception while browsing table data, connection issue. |
| 4 | IT28403 | Data Studio DDL Generation for an ALIAS is not correct. |
| 5 | IT28432 | Data Studio does not show the data in Privilege tab in Properties view. |
| 6 | IT25174 | Not able to use Explain option in Data Studio and getting an error: An internal Error occurred. |
| 7 | IT28142 | Data Studio is not supporting null input into individual array elements. |
| 8 | IT27813 | Comma can now be added in String array element as input in DB2 z/OS Native Stored Procedure in Data Studio. |
| 9 | IT23365 | Native SQL Stored Procedure is failing with array as a parameter when called via Data Studio. |
| 10 | IT26495 | Added support in Storage Group for physical data model. |
Data Studio 4.1.3 APAR 5 Hotfix
Ibm Data Studio Download Mac
| Sr. No. | Description | |
|---|---|---|
| 1 | IT29901 | Add support for Salesforce Ticket while capturing statement’s environment. |
Data Studio 4.1.3 APAR 6
| Sr. No. | APAR Number | |
|---|---|---|
| 1 | IT29734 | The Instead Of parameter for Trigger is not shown properly after reverse engineering a model for table. |
| 2 | IT29993 | Support for handling extra characters in DB2 NSP. |
| 3 | IT29578 | Data Studio 4.1.3 APAR 5 Multivariate Distribution does not work with APAR 5 and previous versions. |
| 4 | IT28629 | z/OS parser to offer 'Set Current Accelerator' statement validation. |
| 5 | IT29543 | In Administration explorer, in Properties window of User / Role, in Privileges tab, the names of Package and Schema appear blank. |
| 6 | Enhancement | Support for Data Studio for V11.5 version of DB2 LUW. |
| 7 | Internal Defect | Null pointer issue breaks QueryTuning for DB2 z/OS. |
| 8 | Internal Defect | DDL does not generate Create Procedure statements in Data Studio 4.1.3 DB2 z/OS 12. |
| 9 | Internal Defect | In IBM DB2 Data Studio QueryTuning with Workload gives an error with specific workload files or queries. |
Data Studio 4.1.3 APAR 7
| Sr. No. | Description | |
|---|---|---|
| 1 | IT28700 | Issue while extracting data from a table. |
| 2 | IT30179 | The SYSTOOLS Explain table show unknown format error during configuration. |
| 3 | IT31001 | Added support for ISO format timestamp value for loading data in Db2 LUW. |
| 4 | IT31040 | Query Tuning > Visual Explain fails for z/OS SSL environment |
| 5 | IT32201 | Query Tuning > Generate recommendations > Statistics Explain hangs. |
| 6 | IT32286 | Modifying table fails with SSL connection. |
| 7 | IT32288 | Added support for the FETCH FIRST clause in Delete statement in Db2 z/OS 12. |
| 8 | IT33295 | Generated DDL for Load in the Alter function is not compatible with Db2 LUW parameter setup. |
| 9 | IT32482 | While configuring query tuning the DSN_Statement_Cache_Table appears in an unknown format in Db2 z/OS 12. |
| 10 | IT33418 | Data Studio is unable to differentiate between the Allow and Disallow Debug modes of different versions of a Stored Procedure. |
| 11 | Enhancement | Added support for Column Organized Tables property in a partitioned environment for Db2 LUW. |
| 12 | None | Qualified support for Db2 LUW 11.5.4. |
Content URL
[{'Business Unit':{'code':'BU053','label':'Cloud & Data Platform'},'Product':{'code':'SS62YD','label':'IBM Data Studio'},'ARM Category':[{'code':'a8m0z0000001jGMAAY','label':'rbrw'}],'ARM Case Number':','Platform':[{'code':'PF002','label':'AIX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'},{'code':'PF033','label':'Windows'}],'Version':'4.1.0;4.1.1;4.1.2;4.1.3','Line of Business':{'code':'LOB10','label':'Data and AI'}}]
Document Information
Modified date:
21 July 2020